my notes...

Operating system authentication setup:

For NT:

• Create NT user-group : ORA_SID_DBA, ORA_SID_OPER specific to an instance SID

• Create NT user-group : ORA_DBA, ORA_OPER not specific to an instance

• Add a NT OS user to that group. Once you access this domain you will automatically be 
  validated as an authorized DBA.

• sqlnet.ora parameter setting : SQLNET.AUTHENTICATION_SERVICES=(NTS)

• init.ora     parameter setting : REMOTE_LOGIN_PASSWORDFILE=NONE

REMOTE_LOGIN_PASSWORDFILE  allowed values:

exclusive

Note : Any object created by anyone logging in as SYSOPER or SYSDBA will be owned by SYS.

Password file authentication setup:

Create a password file through ORAPWD utility:

In NT :

C:\ > orapwd FILE='%ORACLE_HOME%\database\orapwSKDB.pwd' PASSWORD=jason ENTRIES=5

Default location of password file : %ORACLE_HOME%\database

A non default password file location can be specified in the windows registry  with the key 
ORA_SID_PWFILE.

In Unix:

orapwd \FILE='/u01/app/oracle/product/9.0.1/dbs/orapwSKDB.pwd' \PASSWORD=jason
ENTRIES=5
Default location of password file : $ORACLE_HOME\dbs

• Password assigned to the pwd file will automatically set the same for the SYS user to login Oracle.
   The password for this file & user SYS is the same. 

• Entries sets the maximum number of user entries for the password file. To add more later, the
  password will need to be deleted & re-created, which is risky. So exercise due care while deciding.

• init.ora parameter setting : REMOTE_LOGIN_PASSWORDFILE=exclusive

• To view users in the database password file : V$PWFILE_USERS

well past midnight now... In the background of my brains i can almost hear her say these words...

tu hi meri shaab bai... subah hai... tu hi din hai mera... 
tu hi mera raab hai... jahan hai... tu hi meri duniya... tu waqt mere liye, mei hu tera lamha... 
kaisi rahega bhala... tu mujhse jooda..

crazy & maddening... memories overpowering...

[Gangster movie song (translation) : u r my night... morning... day..., u r my God... my world... universe...
You are my time and i am ur moment... how will u live without me?]  

posted by sk @ 12:35 PM