svrmgrl and root user

[Pascal Rouchon]

Hi,

I have a probleme using svrmgrl under root user. when starting svrmgrl under root i get error:

ORA-12560: TNS:protocol adapter error

My environement for root is the same as oracle user for ORACLE_HOME ORACLE_SID.

[Helen French]

Hi,

Check this document (TKB #A5500557):

http://us-support.external.hp.com/cki/bin/doc.pl/sid=8d22b04c1b9c779606/screen=ckiDisplayDocument?docId=200000039876174

HTH,
Shiju

[Dave Chamberlin]

You should not be running svrmgrl as root. You should only run this as the owner of the oracle software on your system (usually user oracle in group DBA).

[Pascal Rouchon]

I agree with this but the HP-Openview DBSPI for Oracle is running some scripts under root user, this scripts fail because of the error on svrmgrl.

[Anthony deRito]

The oracle message guide says:

$ oerr ora 12560
12560, 00000, "TNS:protocol adapter error"
// *Cause: A generic protocol adapter error occurred.
// *Action: Check addresses used for proper protocol specification. Before
// reporting this error, look at the error stack and check for lower level
// transport errors.For further details, turn on tracing and reexecute the
// operation. Turn off tracing when the operation is complete.

Do you have any other transport issues on your system? Are you able to establish TCP/IP sessions and communicate between sockets OK?
Check this with #netstat -an. You may want to turn on tracing like the recommendation states.

[Pascal Rouchon]

everything is working fine on this servers except svrmgrl for root user

[Bill Hassell]

Currently, the requirement to run some OpenView programs as root is a known problem. A workaround is not available yet. You may have to rewrite the OV scripts to run svrmgrl with an su - oracle to avoid the security problems.

[MANOJ SRIVASTAVA]

Hi Rouchon


You may like to look at this

http://www.cryer.co.uk/brian/oracle/ORA12560.htm



Manoj Srivastava

[John Palmer]

Do you have the environmnent variable TWO_TASK set? If so, unset it.

Oracle8 also requires that SHLIB_PATH is set to ${ORACLE_HOME}/lib

Do you have this problem with sqlplus as well as svrmgrl?

Regards,
John

[Pascal Rouchon]

If i make an sqlplus connection via the listener: sqlplus user@database it's working if i go via ipc sqlplus user it doesn't work