-
I could not dind alert file in bdump folder
Hello
I could not dind alert file in bdump folder
SQL> startup nomount pfile=C:\oracle\admin\arundb\pfile\initarundb.ora
ORACLE instance started.
Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 83886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
SQL> SHOW PARAMETER DUMP
NAME TYPE VALUE
------------------------------------ ----------- -----------------------------
background_core_dump string partial
background_dump_dest string C:\oracle\admin\arundb\bdump
core_dump_dest string C:\oracle\admin\arundb\cdump
max_dump_file_size string UNLIMITED
shadow_core_dump string partial
user_dump_dest string C:\oracle\admin\arundb\udump
SQL> alter database mount;
database mounted
----------------------
now when i try to run alter database open i find error
ORA-01092: ORACLE instance terminated. Disconnection forced
i could not locate alert file to trouble shoot
Please help
-
go to C:\oracle\admin\arundb\bdump
alert log should be there alert_{ORACLE_SID}.log
you need to look alert log file.Because the detailed information is there.
This error can make you drop and recreate the database in the worst case.
So alert log file is important.According to details in alert log file,there are different solutions..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|