Admin/admin

udump가 없으니..shutdown이 안되는구나!!

Qhtlr 2008. 7. 1. 11:24

TEST DB가 필요없게 되어 삭제하기로 함,, datafile삭제함.
DBCA를 통해서 DB삭제 시도 -> datafile을 삭제했기에..db접속 못한다고 나옴 -> 강제로 삭제함.
DBCA종료후 보니..Instance가 뜨있다.

Shutdown abort 하니까 아래의 메시지 출력

ORA-07446: sdnfy: bad value '/oracle/app/oracle/product/9.2.0/admin/TEST/udump' for parameter user_dump_dest.

udump 생성후 shutdown 재시도 -> 정상 down됨

[udump 밑의 tracefile 내용]
/oracle/app/oracle/product/9.2.0/admin/TEST/udump/test_ora_1511502.trc
*** 2008-07-01 11:17:45.578
Cannot open alert file "/oracle/app/oracle/product/9.2.0/admin/TEST/bdump/alert_TEST.log"; errno = 2
Cannot open alert file "/oracle/app/oracle/product/9.2.0/admin/TEST/bdump/alert_TEST.log"; errno = 2
Cannot open alert file "/oracle/app/oracle/product/9.2.0/admin/TEST/bdump/alert_TEST.log"; errno = 2