Friends,
DB: Oracle 11gR2 (11.2.0.3) 64 bit
OS(rac1): OEL 6.3 64 bit in virtual box 4.2
DB: Oracle 11gR2 (11.2.0.3) 64 bit
OS(rac2): OEL 6.3 64 bit in virtual box 4.2
Just now installed 2 node rac db...the db is working fine...and the em also working fine before i restart the server.
after restarting...em is not starting automatically.
[oracle@rac1 ~]$ echo $GRID_HOME
/u01/app/11.2.0/grid
[oracle@rac1 ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/db_1
[oracle@rac1 ~]$
[oracle@rac1 ~]$ emctl status dbconsole
Can't locate CompEMdbconsole.pm in @INC (@INC contains: %s_javapOracleHome%/sysman/admin/scripts %s_javapOracleHome%/bin /u01/app/11.2.0/grid/perl/lib/5.10.0/x86_64-linux-thread-multi /u01/app/11.2.0/grid/perl/lib/5.10.0 /u01/app/11.2.0/grid/perl/lib /u01/app/11.2.0/grid/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /u01/app/11.2.0/grid/perl/lib/site_perl/5.10.0 /u01/app/11.2.0/grid/perl/lib/site_perl /u01/app/11.2.0/grid/perl/libwww-perl/lib /u01/app/11.2.0/grid/perl/ext/POSIX /u01/app/11.2.0/grid/perl/URI /u01/app/11.2.0/grid/perl/HTML_Parser /u01/app/11.2.0/grid/perl/HTML-Parser/lib /u01/app/11.2.0/grid/sysman/admin/scripts /u01/app/11.2.0/grid/bin /u01/app/11.2.0/grid/sysman/admin/scripts/Net-DNS-0.48/lib/ /u01/app/11.2.0/grid/sysman/admin/scripts/libnet-1.19/ .) at /u01/app/11.2.0/grid/bin/EmctlCommon.pm line 598.
[oracle@rac1 ~]$ echo $ORACLE_HOME
/u01/app/11.2.0/grid
[oracle@rac1 ~]$ dg_env
-bash: dg_env: command not found
[oracle@rac1 ~]$ db_env
[oracle@rac1 ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/db_1
[oracle@rac1 ~]$ emctl status dbconsole
OC4J Configuration issue. /u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_rac1_rac not found.
[oracle@rac1 ~]$
[oracle@rac1 ~]$ emca -config dbcontrol db -repos recreate -cluster
STARTED EMCA at Sep 23, 2012 3:55:18 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.
Enter the following information:
Database unique name: rac
Service name: rac1
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]: /u01/app/oracle/product/11.2.0/db_1
Password for SYS user:
Sep 23, 2012 3:55:58 PM oracle.sysman.emcp.ParamsManager setConfiguredNodeSidList
WARNING: Error determining the nodes associated with cluster database rac
Sep 23, 2012 3:55:58 PM oracle.sysman.emcp.ParamsManager setConfiguredNodeSidList
WARNING: Error determining the nodes associated with cluster database rac
Sep 23, 2012 3:56:00 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: Error during db connection : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Sep 23, 2012 3:56:06 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Password validation failed. Some of the possible reasons may be:
1) Invalid username/password.
2) Database is not up.
3) Scan listener not up.
4) Database service is not registered with scan listener.
5) Password file may be missing or configured incorrectly.
Password for SYS user: [oracle@rac1 ~]$
[oracle@rac1 ~]$
[root@rac1 ~]# cemutlo -n
rac
SQL> show parameter db_uniqu
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string orcl
SQL>
[oracle@rac1 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 23-SEP-2012 15:59:45
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 23-SEP-2012 11:41:35
Uptime 0 days 4 hr. 18 min. 9 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/rac1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.3)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.4)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "orcl.sathy.net" has 1 instance(s).
Instance "rac11", status READY, has 1 handler(s) for this service...
Service "rac1XDB.sathy.net" has 1 instance(s).
Instance "rac11", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@rac1 ~]$
i tried with +ASM1, rac1, rac11 for the service name.
and the database unique name is rac....
i gone thru document for dropping and creating the em...but not succeeded...