The update databasepassword subcommand of the raccli utility updates the password in the keystore (wallet) and optionally updates the password of the SYS and SYSTEM users. raccli update databasepassword -password password [-saveonly] If you are executing this command following an update to the cloud tooling from release 17.2.1 or earlier, you must execute the command with […]
All posts by Skant Gupta
Oracle Database Gateway for Microsoft SQL Server
The gateway system identifier (SID) is an alphanumeric character string that identifies a gateway instance. You need one gateway instance, and therefore one gateway SID, for each SQL Server database you are accessing. The SID is used as part of the file name for the initialization parameter file. The default SID is dg4msql. You can […]
Oracle 18c: RMAN New Features
This article was written by Skant Gupta and Joel Perez in Oracle OTN. Full Index of Oracle Cloud Articles: Sir.CloudDBaaSjoelperez Before starting to read, if you want to access others Oracle RMAN Cloud Articles, you can go here: #6 Oracle Cloud (DBaaS): Migrating Databases to Oracle Cloud Using RMAN Backup #11 Oracle Cloud (DBaaS): Migration “On-prem” database to Cloud Using […]
Oracle 18c: Data Warehousing New Features
This article was written by Skant Gupta and Joel Perez in Oracle OTN. Full Index of Oracle Cloud Articles: Sir.CloudDBaaSjoelperez If you want to be updated with all our articles send us the Invitation or Follow us: Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/ or Join our LinkedIn group: Oracle Cloud DBaaS Data Warehousing will be the focus of […]
Prepare standby and configure primary database for far sync
This depend on distance between primary and standby and network bandwidth. So this feature that came with 12c resolve this situation. We are preparing a database one more. This database take archive–log primary database and then send this archive–log to standby. Primary and far sync standby database are sync, whereas far sync standby database and physical standby database are async. Let’s begin with creating the physical standby with FAR SYNC instance in place. First of […]
Oracle 18c: RAC New Features
This article was written by Skant Gupta and Joel Perez in Oracle OTN. If you want to be updated with all our articles send us the Invitation or Follow us: Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/ or Join our LinkedIn group: Oracle Cloud DBaaS Oracle Real Application Cluster is an Oracle solution that seems will improve in a […]
Oracle Database 12c: Interactive Quick Reference
The Oracle Database 12c: Interactive Quick Reference is a multimedia tool for various terms and concepts used in the Oracle Database 12c release. Built as a multimedia web page, this diagram provides descriptions of database architectural components, as well as references to relevant documentation. Use this helpful reference as a cheat sheet for writing custom […]
Installation of Oracle Database Gateway
Downloading Gateway Products Oracle Database Gateway products can be downloaded from the following – 1. Oracle Technology Network – OTN – http://www.oracle.com/technology/software/products/database/index.html Choose the relevant platform and version then the ‘See All‘ option. Under that there will be an option to download the Gateway products, for example – Oracle Database Gateways 11g Release 2 (11.2.0.1.0) […]
Overview For Oracle Database Gateway
Gateway Installation You can install Oracle Database Gateway in either of the following configurations: ■ On the same computer as an existing Oracle database but in a different Oracle home. ■ On a system with no Oracle database. ■ On the same computer as the Oracle database and in the same Oracle home directory. Note that in this […]
Create Far Sync Standby Database
This depend on distance between primary and standby and network bandwidth. So this feature that came with 12c resolve this situation. We are preparing a database one more. This database take archive–log primary database and then send this archive–log to standby. Primary and far sync standby database are sync, whereas far sync standby database and […]