Posts

Showing posts from 2018

Data Guard Physical Standby Setup in Oracle Database 11g Release 2

System Configuration: Two VMS          1. Primary Server                  OS - Redhat Linux 5.11          Oracle - 11.2          IP - 192.168.1.100          Hostname - sourcenode01        2. Standby Server          OS - Redhat Linux 5.11          Oracle - 11.2 (Only software has installed)          IP - 192.168.1.101          Hostname - targetnode01 Primary Server Setup Logging Check that the primary database is in archivelog mode. SQL> select name from v$database; NAME --------- SRC01 SQL> select log_mode from v$database; LOG_MODE ------------ ARCHIVELOG SQL> If it is noarchivelog mode, switch is to archivelog mode. SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER DATABASE...

OEM reconfiguration

Image
Set ORACLE_HOSTNAME=sourcenode01 [oracle@sourcenode01 ~]$ $ORACLE_HOME/bin/emca -deconfig dbcontrol db STARTED EMCA at Sep 24, 2018 12:20:04 PM EM Configuration Assistant, Version 11.2.0.0.2 Production Copyright (c) 2003, 2005, Oracle.  All rights reserved. Enter the following information: Database SID: src01 Do you wish to continue? [yes(Y)/no(N)]: Y Sep 24, 2018 12:20:13 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/src01/emca_2018_09_24_12_20_03.log. Sep 24, 2018 12:20:13 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration WARNING: EM is not configured for this database. No EM-specific actions can be performed. Enterprise Manager configuration completed successfully FINISHED EMCA at Sep 24, 2018 12:20:13 PM [oracle@sourcenode01 ~]$ [oracle@sourcenode01 ~]$ $ORACLE_HOME/bin/emca -config dbcontrol db -repos recreate STARTED EMCA at Sep 24, 2018 12:21:22 PM EM Configuration A...

11.2.0.1.0 database creation through dbca

Image
Login to oracle set the oracle enviornment if not set Create Listener through netca [oracle@localhost ]$ dbca Click "Yes" Click "Next" Click "Finish" Installation complete.

12.1.0.1.0 database creation through dbca

Image
In case :  A fatal error has been detected by the Java Runtime Environment Sol: [oracle@oel66401 Desktop]$ export LD_BIND_NOW=1 [oracle@oel66401 Desktop]$ dbca