Oracle ORA-01017 tips

Oracle Tips by Burleson Consulting

출처: http://www.dba-oracle.com/t_ora_01017.htm

Question: I get the error "ORA-01017: invalid username/password; logon denied " when attempting to connect using a database link. How to I resolve the ORA-01017 error?

Answer: The docs note that the ORA-01017 can have a variety of causes most relating to permissions (grant), tnsnames.ora, sqlnet.ora configuration, or improper connect string syntax.

Also, see my notes on diagnosing Oracle network connection issues:

ORA-01017: invalid username/password; logon denied

Cause: An invalid username or password was entered in an attempt to log on to Oracle. The username and password must be the same as was specified in a GRANT CONNECT statement. If the username and password are entered together, the format is: username/password.

Action: Enter a valid username and password combination in the correct format.

Checklist for ORA-01017 errors:

Check that user ID exists

select * from user_tables
where username = 'fred';

Check grants

grant connect to fred;

Check your environmental parameters ($ORACLE_SID), e.g.:

export ORACLE_SID=TEST
sqlplus "/nolog"

If using external authentication (ops$) verify that os_authent_prefix=ops$ and remote_os_authent=true your initialization/spfile.
Check tnsnames.ora to ensure the the service name points to the correct server and instance name.

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.

You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

출처 Oracle ORA-01017 tips|작성자 형기