Oracle Illustrated

Feb 21 2010   7:53AM GMT

Migrating from 9i to 11g – Password

Lakshmi Venkatesh Profile: Lakshmi Venkatesh

Password – Case sensitive

From Oracle 11g passwords are case sensitive.

select * from v$parameter where upper(name) = ‘SEC_CASE_SENSITIVE_LOGON’

VALUE
TRUE

SQL> ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;

SQL> conn SYSTEM/mother01
Connected.

SQL> conn system/Mother01
Connected.

SQL> ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = TRUE;

SQL> conn SYSTEM/mother01
ERROR:
ORA-01017: invalid username/password; logon denied

Password – OS Authentication

Its not really straight-forward to use OS authentication in Oracle 11g – this is mainly for security reasons. But, if your application is using it you can still try to do it like this !!

select * from v$parameter where upper(name) = ‘OS_AUTHENT_PREFIX’

VALUE
OPS$

ALTER SYSTEM SET OS_AUTHENT_PREFIX=’$OPS’ SCOPE=spfile

(Note: Cannot make the scope as BOTH)

Check REMOTE_OS_AUTHENT

select * from v$parameter where upper(name) = ‘REMOTE_OS_AUTHENT’

VALUE
FALSE

If the value is FALSE then, OS authentication will not be allowed. The parameter should be set to TRUE.

ALTER SYSTEM SET REMOTE_OS_AUTHENT=TRUE SCOPE=SPFILE

Now, create OS user

SQL> CREATE USER ops$lakshmi identified externally;

User created.

SQL> GRANT CONNECT TO ops$lakshmi;

Grant succeeded.

(from the need – need to check in unix)

[oracle@ludwig ~]$ su – lakshmi
Password:
[unix]$ ORACLE_HOME=/opt/app/oracle/product/11.1.0/db_1
[unix]$ ORACLE_HOME_LISTNER=/opt/app/oracle/product/11.1.0/db_1/network/admin
[unix]$ ORACLE_SID=db11FS
[unix]$ PATH=$ORACLE_HOME/bin:$PATH
[unix]$
[unix]$ export PATH
[unix]$ export ORACLE_HOME
[unix]$ export ORACLE_HOME_LISTNER
[unix]$ export ORACLE_SID
[unix]$ sqlplus /

Password – Verification function

ALTER PROFILE default LIMIT
PASSWORD_LIFE_TIME 60
PASSOWRD_GRACE_TIME 10
PASSWORD_REUSE_TIME 1800
PASSWORD_REUSE_MAX UNLIMITED
FAILED_LOGIN_ATTEMPTS 3
PASSWORD_LOCK_TIME 1/1440
PASSWORD_VERIFYH_FUNCTION verify_function;

Also, strong passwords needs to be set –

Minimum 8 characters
one letter and one digit
not a common password
must differ at least by 3 characters from the previous password

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: