Search This Blog

Sunday, February 11, 2007

Administering a Database on Windows

Starting or Stopping Oracle Database Services
1.Control Panel
start > run > services.msc
2.Command Prompt
c:\>net start/stop OracleSerivce
3.Oracle Administration Assistant for Windows
Start > Programs > Oracle - HOME_NAME > Configuration and Migration Tools > Administration Assistant for Windows

Setting Registry Parameters
To start or stop Oracle Database through Oracle Database Services
ORA_SID_AUTOSTART [TRUE/FALSE]


Viewing and Hiding the Password File
1. Command Prompt
C:\oracle\product\10.1.0\Db_1\database>attrib +H PWDorcl.ora

C:\oracle\product\10.1.0\Db_1\database>attrib +H PWDdb01.ora

C:\oracle\product\10.1.0\Db_1\database>attrib
A C:\oracle\product\10.1.0\Db_1\database\hc_db01.dat
A C:\oracle\product\10.1.0\Db_1\database\hc_orcl.dat
A C:\oracle\product\10.1.0\Db_1\database\INITorcl.ORA
A C:\oracle\product\10.1.0\Db_1\database\oradba.exe
A H C:\oracle\product\10.1.0\Db_1\database\PWDdb01.ora
A H C:\oracle\product\10.1.0\Db_1\database\PWDorcl.ora
A C:\oracle\product\10.1.0\Db_1\database\SPFILEDB01.ORA
A C:\oracle\product\10.1.0\Db_1\database\SPFILEORCL.ORA

2. Windows Explorer

Connecting Remotely to the Database as SYS
With Oracle Database, the password used to verify a remote database connection is automatically encrypted. Whenever a user attempts a remote login,
Set the ORA_ENCRYPT_LOGIN environment variable to TRUE on the client machine.
Set the DBLINK_ENCRYPT_LOGIN server initialization parameter to TRUE


Changing Archive Mode to ARCHIVELOG
shutdown immediate;
startup mount;
archive log list
alter database archivelog;
archive log list
alter database open;

LOG_ARCHIVE_FORMAT
%%ORACLE_SID%%%T.ARC specifies the thread number
%%ORACLE_SID%%%S.ARC specifies the log sequence number
%%ORACLE_SID%%%t.ARC specifies the thread number. The number is not padded
%%ORACLE_SID%%%s.ARC specifies the log sequence number. The number is not padded

No comments: