Database Administration (MOSC)

MOSC Banner

Connect root as sysdba.??

edited Oct 25, 2012 9:18AM in Database Administration (MOSC) 3 commentsAnswered
Hi
I'm running on 10.2.0.4 version on HP-UX supporting a SAP module. As oracle user everything works fine but for business pruposes s necessary to perform some backups as root user.

The problem is when trying to connect with the following line from the OS:

# sqlplus / as sysdba

ORA-01031: insufficient privileges

I have added root to dba and oper groups, removed SQLNET.AUTHENTICATION_SERVICES entry from sqlnet.ora, the parameter remote_login_password_file=exclusive,
orapwd file=$ORACLE_HOME/dbs/orapw<sid> password=<password> force=y nosysdba=n... Also the db has been restarted.


But the issue persists, any idea?<br/>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center