DBA > Job Interview Questions > Hiring the Best Database Administrator Questions and Answers

ORACLE_HOM - Why do we get error when we run “o

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

ORACLE_HOM - Why do we get error when we run “opmnctl status” from ....

Q: Why do we get error when we run “opmnctl status” from “$INST_TOP/ ora/ 10.1.3/ opmn/ bin” although we get output on running $ADMIN_SCRIPTS_HOME/ adopmnctl.sh

When you run opmnctl status from $INST_TOP/ora/10.1.3/opmn/bin you get error like below

$ ./opmnctl status
Error reading opmn.xml
Message:{$INST_TOP/ora/10.1.2/opmn/conf/opmn.xml (No such file or directory)}
Filename:{$INST_TOP/ora/10.1.2/opmn/conf/opmn.xml}
FileContent:{}



A)
This is because when you run “opmnctl status” from $INST_TOP/ora/10.1.3/opmn/bin, opmnctl executable picks up OPMN config file (opmn.xml) from $ORACLE_CONFIG_HOME/opmn/conf/opmn.xml and $ORACLE_CONFIG_HOME by default is set to 10.1.2 ORACLE_HOME .

It is still possible to display status using $INST_TOP/ora/10.1.3/opmn/bin/status but first set $ORACLE_CONFIG_HOME to 10.1.3 (This can be done by executing 10.1.3 environment file i.e. $INST_TOP/ora/10.1.3/$SID_$hostname.env )

(Continued on next question...)

Other Job Interview Questions