Oracle DBA Place

These are the steps of creating Far Sync instance in the command line: Create 12.1 primary db Create 12.1 physical standby Create regular standby DG broker configuration modify network file (on primary and standby) and add entries for the far_sync instance, add to tnsnames.ora on Primary hosts and standby hosts: FarSyncInst =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = FarSyncHost)(PORT = 1521))     )     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = FarSyncInst)       (UR=A)     )   )     Note: (UR=A) is needed to connect to a BLOCKED unmounted database instance. Copy tnsnames.ora to new farsync server – ensure all hosts mentioned in tnsnames are written also in /etc/hosts Add to listener.ora in far sync server LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =     ...

Connection manager is working as oracle SQL*NET proxy and firewall. In this example, I am using Connection Manager of Oracle Database 12c Release 2 running on Linux x86_64 Footprint Storage: 1.7 G Memory: 5~28.4 MB Requires: Installation of Oracle Client in a separated folder than the database software Register the connection manager in the grid infrastructure as a cluster resource Configure and install on the intermediate host Download Oracle Database 12c Release 2 Client unzip linuxx64_12201_client.zip Change response file /client/response/client_install.rsp: UNIX_GROUP_NAME= INVENTORY_LOCATION= ORACLE_HOME= ORACLE_BASE= oracle.install.client.installType=Custom oracle.install.client.customComponents=oracle.network.cman:12.2.0.1.0 Start silent installation: cd /client ./runInstaller -silent -responseFile /client/response/client_install.rsp -ignoreSysPrereqs -ignorePrereq -noconfig -waitforcompletion -force -showProgress run root.sh sudo /oracle/prod...

Step by step for installing instant client 12.1 Install RPMs 1. Download Oracle Instant client RPM files from http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html Download "Basic lite", and "SQL*Plus". 2. Convert these .rpm files into .deb packages and install using " alien " (" sudo apt-get install alien " if you don't have it). alien -i oracle-instantclient12.1-basiclite-12.1.0.2.0-1.x86_64.rpm alien -i oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm 3. Test your Instantclient install by using "sqlplus" to connect to your database: sqlplus username/password@//dbhost:1521/SID Integrate Oracle Libraries & ORACLE_HOME Add the Oracle libraries to the LD_LIBRARY_PATH to the system library list create a new file as follows: sudo vi /etc/ld.so.conf.d/oracle.conf && sudo chmod o+r /etc/ld.so.conf.d/oracle.conf and add the oracle library path as the first line: /usr/lib/oracle/12...

Hi , At Oracle Open World 2016 I collected the main improvements and changes   are going to be implemented in Oracle Database 12 Release 2 : 1.        Data Guard Creation with dbca, support automatic creation of Standby database and Far Sync instance   not for RAC (at this point) command : dbca -silent -createDuplicateDB     - PrimartDBConnectionString myprymary.domin:1523/chicago.domain     - gdbName chicago.domain -sid boston     - initParams instance_name=boston -createAsStandby     - customScripts /tmp/test.sql 2.        Multi-Instance Redo Apply, Parallel, multi-instance recovery - when standby is RAC, all of its instances will use the MRP0 process for applying 3.        Supports Diagnostic Pack on Active Data Guard   AWR+ADDM Reports for Standby are kept in the Primary 4.  ...

Looking for installed patches on the database I have always used opatch lsinventory (since 9.2 and up) From CPUJan2006 onwards you can just query select * from registry$history; See Metalink Note:352783.1 for more information.

installing or upgrading on Ubuntu is not supported but can be done thanks to other bloggers it is well documented here https://lostinmac.com/2012/01/29/installtion-doracle-11gr2-sur-ubunutu-11-10/ thanks

before oracle 11.2 we should have do this steps: cd $ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk dv_off cd $ORACLE_HOME/bin relink all from now this is simpler and shorter cd %ORACLE_HOME%/bin chopt disable dv All options are written in the usage syntax: usage: chopt [enable|disable] {option} options: dm = Oracle Data Mining RDBMS Files dv = Oracle Database Vault option lbac = Oracle Label Security olap = Oracle OLAP partitioning = Oracle Partitioning rat = Oracle Real Application Testing

Some times there are problems using installation with GUI, the reason can be: 1. Firewall 2. Unix security 3. Client software (missing or not working( and maybe some more reasons If your environment is cooperative helping you solve this - it is simple - go for it. But if you are on your own and can't reach "the right guys" - do it yourself " Silently " Look for the proper response file fits for your needs in /database/response/ Edit it and run the following command: $ ./runInstaller -force -invPtrLoc /oraInst.loc -silent -noconfig -ignoreSysPrereqs -responseFile /database/response/enterprise.rsp You can also run the installer without a response file as mentioned in Metalink Note 782918.1 $ ./runInstaller -silent -force -debug \ FROM_LOCATION="/mount/dvd/database/stage/products.xml" \ ORACLE_HOME="/u01/app/oracle/product/11.1.0/db_1" \ ORACLE_HOME_NAME="Ora11gDb1" ORACLE_BASE="/u01/app/oracle" \ TOPLEVEL_COMPONENT='{...

I noticed that many DBAs are not aware of the need to run a prerequisite system check before installation of an oracle product. This special check should be done in addition to the installation document and the check inside the installer. The utility called RDA with a module for Health Check called HCVE. It is well documented for RAC but can be used for simple installation. RDA is maintained frequently and adjusted to the OS version against the oracle software. You can read about it in Metalink Doc ID: 250262.1 "RDA - Health Check / Validation Engine Guide" Sample ./rda.sh -T hcve Processing HCVE tests ... Available Pre-Installation Rule Sets: 1. Oracle Database 10g R1 (10.1.0) PreInstall (AIX) 2. Oracle Database 10g R2 (10.2.0) PreInstall (AIX) 3. Oracle Database 11g R1 (11.1.0) PreInstall (AIX) 4. Oracle Application Server 10g (9.0.4) PreInstall (AIX) 5. Oracle Fusion Middleware 11g R1 (11.1.1) PreInstall (AIX) 6. Oracle Portal PreInstall (Generic) Availab...