Home » RDBMS Server » Enterprise Manager » Oracle 11g RAC EM rebuilding failed. (Oracle 11g RAC (11.2.0.2), AIX v6.1)
Oracle 11g RAC EM rebuilding failed. [message #616322] Sun, 15 June 2014 21:44 Go to next message
cuijin
Messages: 15
Registered: June 2010
Junior Member
My system environment is IBM AIX v6.1 and Oracle 11g(v11.2.0.2) RAC.
I deconfigged dbcontrol by emca, and dropped repos by manual.
$ sqlplus / as sysdba
SQL> drop user sysman cascade;
SQL> drop role MGMT_USER;
SQL> drop user MGMT_VIEW cascade;
SQL> drop public synonym MGMT_TARGET_BLACKOUTS;
SQL> drop public synonym SETEMVIEWUSERCONTEXT;
SQL> exit
When I reconfig dbcontrol and repos ($ emca -config dbcontrol db -repos create -cluster), it failed and intereupted.
Error masseges say: sys username and password is not correct. But I input correct username and password, I have tried that by Sqlplus.
In Oracle .profile file, I have define variables ORACLE_HOME, ORACLE_UNQNAME, ORACLE_HOSTNAME(is hostname in AIX).
My Grid and Oracle is in different path. So I think that there are some setup wrong.
May I shoul dropped some other public synonym ownered by sysman? May I should setup other veriables?
Could someone help me? Very thanks to you!
Re: Oracle 11g RAC EM rebuilding failed. [message #616324 is a reply to message #616322] Sun, 15 June 2014 21:54 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
tell me what is the password to my SYS schema
SQL> connect / as sysdba
Connected.
SQL> show user
USER is "SYS"
SQL> connect sys/fubar as sysdba
Connected.
SQL> show user
USER is "SYS"
SQL> connect sys/ID10T as sysdba
Connected.
SQL> show user 
USER is "SYS"
SQL> connect sys/IT_DOES_NOT_MATTER as sysdba
Connected.
SQL> show user
USER is "SYS"
SQL> 


>Error masseges say: sys username and password is not correct.
BELIEVE the error message.

I bet that Oracle reports reality better than you.


Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/
Re: Oracle 11g RAC EM rebuilding failed. [message #616876 is a reply to message #616324] Sun, 22 June 2014 00:55 Go to previous messageGo to next message
cuijin
Messages: 15
Registered: June 2010
Junior Member
I have rebuilding EM again. But it is failed again. I can not visit th web. The displayed masseges are bellow:

$ emca -config dbcontrol db -repos create -cluster

STARTED EMCA at Jun 22, 2014 10:03:10 AM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database unique name: ora11g
Service name: ora11g
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]: /u01/app/11.2.0/grid/bin
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Cluster name: testdb-cluster
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
ASM ORACLE_HOME [ /u01/app/11.2.0/grid ]:
ASM port [ 1521 ]:
ASM username [ ASMSNMP ]:
ASM user password:
Jun 22, 2014 10:08:01 AM 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

-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db_1

Database instance hostname ................ Listener ORACLE_HOME ................ /u01/app/11.2.0/grid/bin
Listener port number ................ 1521
Cluster name ................ testdb-cluster
Database unique name ................ ora11g
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
ASM ORACLE_HOME ................ /u01/app/11.2.0/grid
ASM port ................ 1521
ASM user role ................ SYSDBA
ASM username ................ ASMSNMP

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Jun 22, 2014 10:11:12 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/ora11g/emca_2014_06_22_10_03_10.log.
Jun 22, 2014 10:17:17 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jun 22, 2014 10:23:56 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Jun 22, 2014 10:24:10 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Jun 22, 2014 10:27:25 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Jun 22, 2014 10:27:26 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_testdb1_ora11g to remote nodes ...
Jun 22, 2014 10:35:27 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_testdb2_ora11g to remote nodes ...
Jun 22, 2014 10:45:31 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /u01/app/oracle/product/11.2.0/db_1/testdb1_ora11g to remote nodes ...
Jun 22, 2014 10:53:33 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /u01/app/oracle/product/11.2.0/db_1/testdb2_ora11g to remote nodes ...
Jun 22, 2014 11:07:37 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Jun 22, 2014 11:55:20 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jun 22, 2014 12:05:37 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://testdb1.dlg.com:1158/em <<<<<<<<<<<
Jun 22, 2014 12:11:01 PM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage
INFO:
**************** Current Configuration ****************
INSTANCE NODE DBCONTROL_UPLOAD_HOST
---------- ---------- ---------------------

ora11g testdb1 testdb1.dlg.com
ora11g testdb2 testdb1.dlg.com


Jun 22, 2014 12:11:01 PM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************ WARNING ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in the file: /u01/app/oracle/product/11.2.0/db_1/testdb1_ora11g/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost.

***********************************************************
Jun 22, 2014 12:11:01 PM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING: Error starting Database Control on nodes testdb1,testdb2. Execute the following command(s) on nodes: testdb1,testdb2.

1) Set the environment variable ORACLE_UNQNAME to Database unique name
2) /u01/app/oracle/product/11.2.0/db_1/bin/emctl start dbconsole


Error starting Database Control on nodes testdb1,testdb2. Execute the following command(s) on nodes: testdb1,testdb2.

1) Set the environment variable ORACLE_UNQNAME to Database unique name
2) /u01/app/oracle/product/11.2.0/db_1/bin/emctl start dbconsole
$


So, I have inputted some commands in node testdb1. It is bellow:


$ ps -ef|grep dbconsole
oracle 16121952 1 0 11:56:41 pts/0 0:00 /u01/app/oracle/product/11.2.0/db_1/perl/bin/perl /u01/app/oracle/product/11.2.0/db_1/bin/emwd.pl dbconsole /u01/app/oracle/product/11.2.0/db_1/testdb1_ora11g/sysman/log/emdb.nohup
$
$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
https://testdb1.dlg.com:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is not running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/testdb1_ora11g/sysman/log
$
$ echo $ORACLE_UNQNAME
ora11g
$ $ /u01/app/oracle/product/11.2.0/db_1/bin/emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
https://testdb1.dlg.com:1158/em/console/aboutApplication
- An instance of Oracle Enterprise Manager 11g Database Control is already running.
$


Could you help me for some messages?


Re: Oracle 11g RAC EM rebuilding failed. [message #616893 is a reply to message #616876] Sun, 22 June 2014 08:37 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> ORA-12514: TNS:listener does not currently know of service requested in connect descriptor


ORA-12514 ALWAYS only occurs due to a problem on DB Server system.
One cause of this problem is when the Oracle database is down & needs to be started.
A remote client send a request to the Listener asking to be connected to a specific service.
If/when the listener does not know anything about that service, the listener responds with ORA-12514

post results from the following two OS commands:
lsnrctl status
lsnrctl service

Since every connection request to the listener gets logged, listener.log file will contain a line with 12514 as status code.

This line contains valuable debugging details. So post this line & surrounding lines.

for additional debugging suggestions read the URL below:
http://edstevensdba.wordpress.com/2011/03/19/ora-12514/

Re: Oracle 11g RAC EM rebuilding failed. [message #616897 is a reply to message #616893] Sun, 22 June 2014 09:41 Go to previous messageGo to next message
cuijin
Messages: 15
Registered: June 2010
Junior Member
I have inputed commands. It is billow:

$ hostname
testdb1
$
$ lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production on 22-JUN-2014 21:58:03

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
Start Date 21-JUN-2014 15:35:26
Uptime 1 days 6 hr. 23 min. 57 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/testdb1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.9.7.151)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.9.7.171)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "ora11g" has 1 instance(s).
Instance "ora11g1", status READY, has 1 handler(s) for this service...
Service "ora11gXDB" has 1 instance(s).
Instance "ora11g1", status READY, has 1 handler(s) for this service...
The command completed successfully
$
$ lsnrctl service

LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production on 22-JUN-2014 21:58:59

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:8 refused:0 state:ready
LOCAL SERVER
Service "ora11g" has 1 instance(s).
Instance "ora11g1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:75 refused:0 state:ready
LOCAL SERVER
Service "ora11gXDB" has 1 instance(s).
Instance "ora11g1", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: testdb1, pid: 12976368>
(ADDRESS=(PROTOCOL=tcp)(HOST=testdb1.dlg.com)(PORT=35840))
The command completed successfully
$
$ hostname
testdb2
$
$ lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production on 22-JUN-2014 21:58:25

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
Start Date 21-JUN-2014 15:30:21
Uptime 1 days 6 hr. 29 min. 24 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/testdb2/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.9.7.172)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.9.7.161)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "ora11g" has 1 instance(s).
Instance "ora11g2", status READY, has 1 handler(s) for this service...
Service "ora11gXDB" has 1 instance(s).
Instance "ora11g2", status READY, has 1 handler(s) for this service...
The command completed successfully
$
$ lsnrctl service

LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production on 22-JUN-2014 21:59:35

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:9 refused:0 state:ready
LOCAL SERVER
Service "ora11g" has 1 instance(s).
Instance "ora11g2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:63 refused:0 state:ready
LOCAL SERVER
Service "ora11gXDB" has 1 instance(s).
Instance "ora11g2", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: testdb2, pid: 14614622>
(ADDRESS=(PROTOCOL=tcp)(HOST=testdb2.dlg.com)(PORT=35438))
The command completed successfully
$
Re: Oracle 11g RAC EM rebuilding failed. [message #616898 is a reply to message #616897] Sun, 22 June 2014 09:47 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Could you help me for some messages?
reboot the system & try again.
Re: Oracle 11g RAC EM rebuilding failed. [message #616899 is a reply to message #616897] Sun, 22 June 2014 09:50 Go to previous messageGo to next message
cuijin
Messages: 15
Registered: June 2010
Junior Member
But in node testdb2(10.9.7.161), listener.log have some errors today. It is bellow:


$ hostname
testdb1
$
$ pwd
/u01/app/grid/diag/tnslsnr/testdb1/listener/trace
$
$ cat listener.log|grep 12514
13-MAY-2014 08:36:50 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=ora11g)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.9.7.152)(PORT=33119)) * establish * ora11g * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
13-MAY-2014 08:36:50 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=ora11g)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.9.7.152)(PORT=33134)) * establish * ora11g * 12514
$
$ hostname
testdb2
$
$ pwd
/u01/app/grid/diag/tnslsnr/testdb2/listener/trace
$
$ cat listener.log|grep 12514
22-SEP-2013 14:45:31 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ora11g2)(CID=(PROGRAM=sqlplus)(HOST=testdb2)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.9.7.161)(PORT=34490)) * establish * ora11g2 * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
22-SEP-2013 14:46:06 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ora11g2)(CID=(PROGRAM=sqlplus)(HOST=testdb2)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.9.7.161)(PORT=34494)) * establish * ora11g2 * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
22-SEP-2013 14:47:07 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ora11g2)(CID=(PROGRAM=sqlplus)(HOST=testdb2)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.9.7.161)(PORT=34505)) * establish * ora11g2 * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
13-MAY-2014 08:36:52 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=ora11g)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.9.7.152)(PORT=33125)) * establish * ora11g * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
13-MAY-2014 08:36:52 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=ora11g)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.9.7.152)(PORT=33128)) * establish * ora11g * 12514
$


I do not know how service_name becomes 'ora11g2'. Meybe in some files, is it set to 'ora11g2'?
Re: Oracle 11g RAC EM rebuilding failed. [message #616900 is a reply to message #616899] Sun, 22 June 2014 09:56 Go to previous messageGo to next message
cuijin
Messages: 15
Registered: June 2010
Junior Member
My Oracle11g RAC is running certainly. Some applications are on that. Today I have reboot the systems.
Re: Oracle 11g RAC EM rebuilding failed. [message #616901 is a reply to message #616900] Sun, 22 June 2014 10:04 Go to previous messageGo to next message
cuijin
Messages: 15
Registered: June 2010
Junior Member
Thanks to BlackSwan!
I am sorry that I can not visit the web 'http://edstevensdba.wordpress.com/2011/03/19/ora-12514/'. Could you give out that article on other webs?
Re: Oracle 11g RAC EM rebuilding failed. [message #616904 is a reply to message #616876] Sun, 22 June 2014 11:37 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
This situation can arise if DB Control is halfway up and halfway down. One solution is to kill all the java and perl processes. DB Control will then start. Unless there is some other problem, of course.

But really, why bother? Database Control dies not exist in the current release. So why try to use it?
Re: Oracle 11g RAC EM rebuilding failed. [message #616910 is a reply to message #616904] Sun, 22 June 2014 20:55 Go to previous messageGo to next message
cuijin
Messages: 15
Registered: June 2010
Junior Member
Thanks to John Watson!
My situation is what you say. when EM rebuilded on node1, dbcontrol is displayed running on node2 'testdb2', but not running on node1 'testdb1'.
Can i kill the java and perl processes follow you? I input commands, it is bellow:


# hostname
testdb1
#
# ps -ef|grep perl
#
# ps -ef|grep java
root 6029508 5898472 0 Jun 21 - 0:28 /var/opt/tivoli/ep/_jvm/jre/bin/java -Xmx384m -Xminf0.01 -Xmaxf0.4 -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -Xbootclasspath/a:/var/opt/tivoli/ep/runtime/core/eclipse/plugins/com.ibm.rcp.base_6.2.1.20091117-1800/rcpbootcp.jar:/var/opt/tivoli/ ep/lib/com.ibm.logging.icl_1.1.1.jar:/var/opt/tivoli/ep/lib/jaas2zos.jar:/var/opt/tivoli/ep/lib/jaasmodule.jar:/var/opt/tivoli/ep/lib /lwinative.jar:/var/opt/tivoli/ep/lib/lwinl.jar:/var/opt/tivoli/ep/lib/lwirolemap.jar:/var/opt/tivoli/ep/lib/lwisecurity.jar:/var/opt /tivoli/ep/lib/lwitools.jar:/var/opt/tivoli/ep/lib/passutils.jar:../../runtime/agent/lib/cas-bootcp.jar -Xverify:none -cp eclipse/launch.jar:eclipse/startup.jar:/var/opt/tivoli/ep/runtime/core/eclipse/plugins/com.ibm.rcp.base_6.2.1.20091117-1800/launcher. jar com.ibm.lwi.LaunchLWI
pconsole 7078140 3670196 0 Jun 21 - 0:18 /usr/java5/bin/java -Xmx512m -Xms20m -Xscmx10m -Xshareclasses -Dfile.encoding=UTF-8 -Xbootclasspath/a:/pconsole/lwi/runtime/core/eclipse/plugins/com.ibm.rcp.base_6.2.1.20091117-1800/rcpbootcp.jar:/pconsole/lwi/lib/ISC JaasModule.jar:/pconsole/lwi/lib/com.ibm.logging.icl_1.1.1.jar:/pconsole/lwi/lib/jaas2zos.jar:/pconsole/lwi/lib/jaasmodule.jar:/pcons ole/lwi/lib/lwinative.jar:/pconsole/lwi/lib/lwinl.jar:/pconsole/lwi/lib/lwirolemap.jar:/pconsole/lwi/lib/lwisecurity.jar:/pconsole/lw i/lib/lwitools.jar:/pconsole/lwi/lib/passutils.jar -Xverify:none -cp eclipse/launch.jar:eclipse/startup.jar:/pconsole/lwi/runtime/core/eclipse/plugins/com.ibm.rcp.base_6.2.1.20091117-1800/launcher.jar com.ibm.lwi.LaunchLWI
root 10354742 17825866 0 08:27:52 pts/0 0:00 grep java
#
# hostname
testdb2
#
# ps -ef|grep perl
root 20578424 14680088 0 08:28:52 pts/0 0:00 grep perl
#
# ps -ef|grep java
root 5439650 5243080 0 Jun 21 - 0:27 /var/opt/tivoli/ep/_jvm/jre/bin/java -Xmx384m -Xminf0.01 -Xmaxf0.4 -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -Xbootclasspath/a:/var/opt/tivoli/ep/runtime/core/eclipse/plugins/com.ibm.rcp.base_6.2.1.20091117-1800/rcpbootcp.jar:/var/opt/tivoli/ ep/lib/com.ibm.logging.icl_1.1.1.jar:/var/opt/tivoli/ep/lib/jaas2zos.jar:/var/opt/tivoli/ep/lib/jaasmodule.jar:/var/opt/tivoli/ep/lib /lwinative.jar:/var/opt/tivoli/ep/lib/lwinl.jar:/var/opt/tivoli/ep/lib/lwirolemap.jar:/var/opt/tivoli/ep/lib/lwisecurity.jar:/var/opt /tivoli/ep/lib/lwitools.jar:/var/opt/tivoli/ep/lib/passutils.jar:../../runtime/agent/lib/cas-bootcp.jar -Xverify:none -cp eclipse/launch.jar:eclipse/startup.jar:/var/opt/tivoli/ep/runtime/core/eclipse/plugins/com.ibm.rcp.base_6.2.1.20091117-1800/launcher. jar com.ibm.lwi.LaunchLWI
pconsole 5570772 6226144 0 Jun 21 - 0:18 /usr/java5/bin/java -Xmx512m -Xms20m -Xscmx10m -Xshareclasses -Dfile.encoding=UTF-8 -Xbootclasspath/a:/pconsole/lwi/runtime/core/eclipse/plugins/com.ibm.rcp.base_6.2.1.20091117-1800/rcpbootcp.jar:/pconsole/lwi/lib/ISC JaasModule.jar:/pconsole/lwi/lib/com.ibm.logging.icl_1.1.1.jar:/pconsole/lwi/lib/jaas2zos.jar:/pconsole/lwi/lib/jaasmodule.jar:/pcons ole/lwi/lib/lwinative.jar:/pconsole/lwi/lib/lwinl.jar:/pconsole/lwi/lib/lwirolemap.jar:/pconsole/lwi/lib/lwisecurity.jar:/pconsole/lw i/lib/lwitools.jar:/pconsole/lwi/lib/passutils.jar -Xverify:none -cp eclipse/launch.jar:eclipse/startup.jar:/pconsole/lwi/runtime/core/eclipse/plugins/com.ibm.rcp.base_6.2.1.20091117-1800/launcher.jar com.ibm.lwi.LaunchLWI
#
Re: Oracle 11g RAC EM rebuilding failed. [message #616911 is a reply to message #616910] Sun, 22 June 2014 21:02 Go to previous messageGo to next message
cuijin
Messages: 15
Registered: June 2010
Junior Member
The application developers want to use EM for programming debug. So I mast do something to enable EM to be available.
Re: Oracle 11g RAC EM rebuilding failed. [message #616983 is a reply to message #616911] Mon, 23 June 2014 20:14 Go to previous messageGo to next message
cuijin
Messages: 15
Registered: June 2010
Junior Member
I have stopped and kill java processes. But EM start failed. The listener.ora has not error with 12514. which log file i should read also?
Re: Oracle 11g RAC EM rebuilding failed. [message #616985 is a reply to message #616983] Mon, 23 June 2014 21:52 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
cuijin wrote on Mon, 23 June 2014 18:14
I have stopped and kill java processes. But EM start failed. The listener.ora has not error with 12514. which log file i should read also?


is SEARCH broken for you?

Redundancy is the best way to teach slow learners.
Redundancy is the best way to teach slow learners.
Redundancy is the best way to teach slow learners.
Redundancy is the best way to teach slow learners.

http://www.orafaq.com/forum/mv/msg/193171/616893/#msg_616893
Re: Oracle 11g RAC EM rebuilding failed. [message #617073 is a reply to message #616911] Tue, 24 June 2014 12:44 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
cuijin wrote on Sun, 22 June 2014 22:02
The application developers want to use EM for programming debug. So I mast do something to enable EM to be available.

What? And you will allow this?
Developers should use SQL Developer instead, EM is for ADMINISTRATORS not developers!!!

PS: Prepare your resume ASAP, you may get fired if the Auditors find out.

[Updated on: Tue, 24 June 2014 13:13] by Moderator

Report message to a moderator

Re: Oracle 11g RAC EM rebuilding failed. [message #617112 is a reply to message #617073] Wed, 25 June 2014 03:29 Go to previous message
cuijin
Messages: 15
Registered: June 2010
Junior Member
I have rebuilding EM again. But failed to start. It is bellow:

$ hostname
testdb1
$
$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
https://testdb1.dlg.com:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is not running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/testdb1_ora11g/sysman/log
$
$ ps -ef|grep dbconsole
oracle 9437258 1 0 11:12:12 pts/0 0:02 /u01/app/oracle/product/11.2.0/db_1/perl/bin/perl /u01/app/oracle/product/11.2.0/db_1/bin/emwd.pl dbconsole /u01/app/oracle/product/11.2.0/db_1/testdb1_ora11g/sysman/log/emdb.nohup
oracle 14745780 10354904 0 15:04:01 pts/0 0:00 grep dbconsole
$
$ hostname
testdb2
$
$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
https://testdb1.dlg.com:1158/em/console/aboutApplication
EM Daemon is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/testdb2_ora11g/sysman/log
$
$ ps -ef|grep dbconsole
oracle 12910666 1 0 11:17:52 - 0:01 /u01/app/oracle/product/11.2.0/db_1/perl/bin/perl /u01/app/oracle/product/11.2.0/db_1/bin/emwd.pl dbconsole /u01/app/oracle/product/11.2.0/db_1/testdb2_ora11g/sysman/log/emdb.nohup
oracle 15073458 18219190 0 14:58:31 pts/0 0:00 grep dbconsole
$

During rebuiding, it is displayed error with ora-12514 just like above. Mey be some setup about network are wrong?
Previous Topic: emctl start dbconsole ...... failed - in oracle 11g r2
Next Topic: Some scheduled jobs are not showing on EM Cloud Control 12c R3
Goto Forum:
  


Current Time: Thu Mar 28 09:36:46 CDT 2024