Oracle Admin Islemleri

1. Database`e baglanmadan Sqlplus baslatmak

sqlplus /nolog

2. Database`e dbaadmin olarak baglanmak

sql>connect user/pass as sysdba

3. Instance Start Etmek

sql> startup
sql> startup nomount
sql> startup mount
SQL> startup mount
ORACLE instance started.

Total System Global Area 1912602624 bytes
Fixed Size 2066656 bytes
Variable Size 436209440 bytes
Database Buffers 1459617792 bytes
Redo Buffers 14708736 bytes

4. Mount`suz start etmis database i mount etmek

sql> Alter Database Mount;

5. Close ama mount edilmis database i acmak

sql> Alter Database Open;

6. Database Shutdown etmek

sql>shutdown immediate

7. LSNRCTL ile listener kontrol etmek .
ORA-12541: TNS:no listener gibi hatalar alirsaniz..

LSNRCTL>status
LSNRCTL>services
LSNRCTL>start listener

8. ARCHIVE Sorunlari ile ilgilenmek..

Database open yaparken yada herhangibi anda archive hatasi alinirsa once bir parametreleri kontrol etmek gerekiyor.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-16014: log 2 sequence# 746 not archived, no available destinations
ORA-00312: online log 2 thread 1: ‘C:ORADATANETDBONLINELOGREDO02_1.LOG’
ORA-00312: online log 2 thread 1: ‘D:ORADATANETDBONLINELOGREDO02_2.LOG’

SQL> alter system set log_archive_dest_10 = ‘LOCATION=USE_DB_RECOVERY_FILE_DEST’
;

System altered.

SQL> alter database open;

Database altered.