Home » RDBMS Server » Enterprise Manager » Issue while install and configure EM. (Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit)
Issue while install and configure EM. [message #631932] Thu, 22 January 2015 01:29 Go to next message
Manoj.Gupta.91
Messages: 239
Registered: March 2008
Location: Delhi
Senior Member
Hi All,

I'm facing an issue while trying to install EM. My oracle database is in open state and running fine.

Error :
$ emca -config dbcontrol db -repos create

STARTED EMCA at Jan 22, 2015 12:34:38 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: oradb
Exception in thread "main" oracle.sysman.emcp.exception.DatabaseUnavailableException: Database instance unavailable.
        at oracle.sysman.emcp.DatabaseChecks.throwDBUnavailableException(DatabaseChecks.java:151)
        at oracle.sysman.emcp.DatabaseChecks.checkDbAvailabilityImpl(DatabaseChecks.java:144)
        at oracle.sysman.emcp.DatabaseChecks.checkDbAvailability(DatabaseChecks.java:163)
        at oracle.sysman.emcp.DatabaseChecks.getDbServiceName(DatabaseChecks.java:582)
        at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1267)
        at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)
        at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)



Listener Entry in listener.ora
LISTEN_ABC =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.1.194)(PORT = 5001))
  )


Thanks & Regards
Manoj
Re: Issue while install and configure EM. [message #631934 is a reply to message #631932] Thu, 22 January 2015 01:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Post the result of:
env | egrep 'ORACLE|PATH|TNS' | sort
sqlplus / as sysdba

[Updated on: Thu, 22 January 2015 02:15]

Report message to a moderator

Re: Issue while install and configure EM. [message #631935 is a reply to message #631934] Thu, 22 January 2015 01:57 Go to previous messageGo to next message
Manoj.Gupta.91
Messages: 239
Registered: March 2008
Location: Delhi
Senior Member
Hi,

There is no entry for TNS in environment variables.


CLASSPATH=.:/u01/app/oracle/product/11.2.0/dbhome_1/JRE:/u01/app/oracle/product/11.2.0/dbhome_1/jlib:/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib:/u01/app/oracle/product/11.2.0/dbhome_1/jdbc/lib/classes12.jar
LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/dbhome_1/lib:/lib:/usr/lib
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
ORACLE_SID=oradb
ORACLE_TERM=xterm
ORACLE_UNQNAME=oradb
PATH=/u01/app/oracle/product/11.2.0/dbhome_1/bin:/home/jdk1.7.0_21/bin/bin:/u01/app/oracle/product/11.2.0/dbhome_1/bin:/usr/sbin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin



Thanks & Regards
Manoj
Re: Issue while install and configure EM. [message #631936 is a reply to message #631935] Thu, 22 January 2015 01:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And the second command?

Re: Issue while install and configure EM. [message #631944 is a reply to message #631936] Thu, 22 January 2015 03:11 Go to previous messageGo to next message
Manoj.Gupta.91
Messages: 239
Registered: March 2008
Location: Delhi
Senior Member
Hi,

sqlplus / as sysdba

doesn't work as os level authentication is disabled. We need to enter sys password for login.

sqlplus sys as sysdba

then password.

Regards
Manoj
Re: Issue while install and configure EM. [message #631951 is a reply to message #631944] Thu, 22 January 2015 04:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It's been a long time since I used it but I think emca can't either, you need to provide SYS_PWD parameter.
I always provided the complete set of parameters to be sure of what I am doing:
-DB_UNIQUE_NAME
-PORT
-EM_HOME
-LISTENER
-SERVICE_NAME
-SYS_PWD
-SID
-ORACLE_HOME
-DBSNMP_PWD
-HOST
-LISTENER_OH
-LOG_FILE
-SYSMAN_PWD
Re: Issue while install and configure EM. [message #631958 is a reply to message #631951] Thu, 22 January 2015 05:58 Go to previous messageGo to next message
Manoj.Gupta.91
Messages: 239
Registered: March 2008
Location: Delhi
Senior Member
Hi,

I added below environment variables in .bash_profile and I can see values using echo $ENV_NAME

But issue is still same.

HOST_USER=oracle
HOST_USER_PWD="abc@123"
HOST=ABC-DB
PWD=/u01/app/oracle/product/11.2.0/dbhome_1/dbs
EMHOME=/u01/app/oracle/product/11.2.0/dbhome_1/em_home
EM_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/em_home
DB_UNIQUE_NAME=oradb
PORT=5001
LISTENER=LISTEN_ABC
SERVICE_NAME=oradb
SID=oradb
AGENT_PORT=5500
LISTENER_OH=/u01/app/oracle/product/11.2.0/dbhome_1/network/admin
SYSMAN_PWD="v52%47;dO"
DBSNMP_PWD="v52%47;dO"
SYS_PWD="v52%47;dO"


Regards
Manoj
Re: Issue while install and configure EM. [message #631959 is a reply to message #631958] Thu, 22 January 2015 05:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I meant as parameters on the command line, I don't know if emca reads and uses these environment variables.

Re: Issue while install and configure EM. [message #631960 is a reply to message #631959] Thu, 22 January 2015 06:17 Go to previous messageGo to next message
Manoj.Gupta.91
Messages: 239
Registered: March 2008
Location: Delhi
Senior Member
I used export command to set values for these environment variables.

Still problem is same.
Re: Issue while install and configure EM. [message #631965 is a reply to message #631960] Thu, 22 January 2015 07:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Michel Cadot wrote on Thu, 22 January 2015 12:59

I meant as parameters on the command line, I don't know if emca reads and uses these environment variables.

Re: Issue while install and configure EM. [message #632353 is a reply to message #631965] Thu, 29 January 2015 05:41 Go to previous message
Manoj.Gupta.91
Messages: 239
Registered: March 2008
Location: Delhi
Senior Member
Hi,

I couldn't install EM from command line even after trying so many things.

I was able to successfully install EM using DBCA. It's working perfectly fine now.

Thanks for your help and support.

Regards
Manoj
Previous Topic: OEM - target database is not existed
Next Topic: Amending user ie: adding a role in OEM causing a "alter user XXXX identified by 'xxxxxxx';" statemen
Goto Forum:
  


Current Time: Thu Mar 28 06:33:12 CDT 2024