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.

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:

Share this item with your network: