참고글 및 문제해결/문제해결

EM사용중 에러 : connection to host as user oracle failed error nmo not setuid-root (unix-only)

에몽이ㅋ 2012. 3. 26. 01:59
참고사이트 :  http://arjudba.blogspot.com/2008/09/in-em-connection-fails-with-error-nmo.html  

원인 : Enterprise Manager binary file에 대한 some permission error
해결방법 : 
1. EM 완전정지
2. /home/oracle/product/10g/root.sh 실행
3. EM 다시 시작 후 테스트




1. EM 완전정지 
[oracle@server15 ~]$ emctl stop dbconsole
TZ set to ROK
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
http://server15:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
 ...  Stopped.
 
[oracle@server15 ~]$ emctl stop agent
TZ set to ROK
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
Agent is not running.

2. /home/oracle/product/10g/root.sh 실행 
[oracle@server15 ~]$ su -
Password:
[root@server15 ~]# cd /home/oracle/product/10g
[root@server15 10g]# ./root.sh
Running Oracle10 root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /home/oracle/product/10g

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.


3. EM 다시 시작 후 테스트 
[oracle@server15 ~]$ emctl start dbconsole
TZ set to ROK
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
http://server15:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ................................ started.
------------------------------------------------------------------
Logs are generated in directory /home/oracle/product/10g/server15_testdb/sysman/log
 
[oracle@server15 ~]$ emctl start agent
TZ set to ROK
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
Agent is already running

이후 해당 작업 다시 실행