I am trying to start the dbconsole on Oracle 10g installed on Solaris . I type /export/ORACLE_HOME/bin/emctl start dbconsole
I get the response "ORACLE_SID not defined" I have defined it in my home .profile file as follows:
ORACLE_SID=Jacob export $ORACLE_SID
Is my syntax correct?
Also I was advised to define it in the .bashrc file. I cannot find any .bashrc file, so I created one and entered the following:
ORACLE_HOME = /export/ORACLE_HOME export $ORACLE_HOME
ORACLE_SID =Jacob export $ORACLE_SID
Hey thanks for the followup. I removed the .bashrc file and cleaned up the .profile syntax as you suggested. However, I am still getting the error the same as before. Still says that the ORACLE_SID is not defined and that I need to define it. It is too vague an error message and shoule inform someone like me just where the heck I should define it!@#$%^& Other than in the .profile file, what about the oratab file? When I orifinally looked at it yesterday there was no definitions written to it, so I manually entered the following:
Any other suggestions?
I ran the oraenv shell script . What I get when I attempt to start the dbconsole is an error msg stating: No message file for product=network, facility = TNS and this is repeated for all three: TNS-12560, TNS-00515 and TNS-12545.
I found some previous postings on this forum and how it was dealt with => reconfiguring the LISTENER was one idea that worked for someone.
My attempts at fixing anything wrong with the listener.ora file have not gained me anything. I've referenced Oracle's doc for 10g R2 for guidance.
Also, attempting to start dbconsole, this is what I get:
jacob# ../bin/emctl start dbconsole
OC4J Configuration issue. /export/ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_jacob_Jac
ob not found.
I'll take any advice, hunches, explanations. Thanks. Bill
OK Thanks. I ran . oraenv The response I got was something along the lines of ORACLE_SID....[root] ?
I then entered the ORACLE_SID I want to assign. After that I looked at my environment settings and noticed that the ORACLE_SID is now displaying what I want it to. I then attempted to start the dbconsole and it looks like now I'm dealing with a config issue with enterprise manager.