AUTHENTICATION THROUGH OS

AUTHENTICATION THROUGH OS password defined by EXTERNALLY
---------------------------------------------------------------------------

step # 1

parameter must be like bellow

os_authent_prefix string OPS$

step # 2

know OS user name
SQL> select sys_context('USERENV','OS_USER') from dual;
SYS_CONTEXT('USERENV','OS_USER')
----------------------------------------------------------------------------
IBCSEBS07\Administrator

step # 3 user creation ( user name must be upper case)

SQL> create user "OPS$IBCSEBS07\ADMINISTRATOR" identified by externally;

User created.

SQL> grant connect,resource to "OPS$IBCSEBS07\ADMINISTRATOR";

Grant succeeded.

Recovery of Control file from trace

suppose all CONTROL is lost and every thing is ok. No RMAN backup is available.But control file backup as TRACE is exist.

Solution : We will up our database by TRACE control file backup.

Database : Now instance is down

step # 1

c:\> sqlplus /nologsql> conn /as sysdba
sql> startup nomount

step # 2
Copy : create controlfile script which is NORESETLOGS into command screen from trace file backup. as following

sql> CREATE CONTROLFILE REUSE DATABASE "DB1" NORESETLOGS ARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 'C:\ORACLE9I\ORADATA\DB1\REDO01.LOG' SIZE 100M,
GROUP 2 'C:\ORACLE9I\ORADATA\DB1\REDO02.LOG' SIZE 100M,
GROUP 3 'C:\ORACLE9I\ORADATA\DB1\REDO03.LOG' SIZE 100M

-- STANDBY LOGFILE
DATAFILE 'C:\ORACLE9I\ORADATA\DB1\SYSTEM01.DBF', 'C:\ORACLE9I\ORADATA\DB1\UNDOTBS01.DBF',
'C:\ORACLE9I\ORADATA\DB1\CWMLITE01.DBF',
'C:\ORACLE9I\ORADATA\DB1\DRSYS01.DBF',
'C:\ORACLE9I\ORADATA\DB1\EXAMPLE01.DBF',
'C:\ORACLE9I\ORADATA\DB1\INDX01.DBF',
'C:\ORACLE9I\ORADATA\DB1\ODM01.DBF',
'C:\ORACLE9I\ORADATA\DB1\TOOLS01.DBF',
'C:\ORACLE9I\ORADATA\DB1\XDB01.DBF',
'C:\ORACLE9I\ORADATA\DB1\RMAN_TS1.DBF',
'C:\ORACLE9I\ORADATA\DB1\TEST_TS1.DBF',
'C:\ORACLE9I\ORADATA\DB1\TEST_USERS1.DBF',
'C:\ORACLE9I\ORADATA\DB1\TEST_USERS2.DBF'
CHARACTER SET WE8MSWIN1252;

Control file created.

SQL> select status from v$instance;

STATUS
------------
MOUNTED

SQL> alter database open;
Database altered.