Database Administration (MOSC)

MOSC Banner

How to connect to a database using OPS$ ?

edited Aug 17, 2011 2:46AM in Database Administration (MOSC) 9 commentsAnswered ✓
hi experts.
How to connect to a database using OPS$ ?

I'am trying to connect as system using the "identified by values" and I can't.

Example of what I'am trying to do inside the unix server where the database resides:

sqlplus /nolog
conn OPS$SYSTEM/4D17C6152B

ERROR:
ORA-01017: invalid username/password; logon denied


Note from the OMS11g - :

Impact of Violation

The OS_AUTHENT_PREFIX parameter specifies a prefix used to authenticate users attempting to connect to the server. When a connection request is attempted, Oracle compares the prefixed user name with user names in the database.

Using a prefix, especially OPS$, tends to result in an insecure configuration because an account can be authenticated either as an operating system user or with the password used in the IDENTIFIED BY clause.

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