hoctinhoc

Hướng dẫn kiểm tra start Oracle trên Windows

1. Truy cập vào Oracle DB

Vào CMD gõ lệnh: sqlplus / as sysdba

Nếu lỗi thì kiểm tra Oracle đã start chưa?


lsnrctl status

lsnrctl start


2. List Database

SQL> SELECT INSTANCE_NAME, STATUS, DATABASE_STATUS FROM V$INSTANCE;

INSTANCE_NAME STATUS DATABASE_STATUS
---------------- ------------ -----------------
yenlap OPEN ACTIVE


3. Kiểm tra start, muont db

SQL> shutdown immediate;

ORACLE instance shut down.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area 4.3084E+10 bytes
Fixed Size 7775552 bytes
Variable Size 1.6106E+10 bytes
Database Buffers 2.6844E+10 bytes
Redo Buffers 126439424 bytes

SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.