| ORACLE instance terminated [message #533231] |
Tue, 29 November 2011 00:26  |
Bilal Khan
Messages: 128
Registered: April 2010
Location: Pakistan
|
Senior Member |
|
|
Hello EveryBODY.
I am new in oracle administration and waqnt to create database. but it diplay error message i.e
ORA-01092: ORACLE instance terminated. Disconnection forced
First of all i create pfile named initdb02.ora, AND THEN SET THE Oracle_SID IN dos i.e
SET ORACLE_SID = db02
and also create the instance
then i write following in SQL
SQL> startup pfile = 'E:\database2\initdb02.ora';
It generate following result
Total System Global Area 75497472 bytes
Fixed Size 1247300 bytes
Variable Size 58722236 bytes
Database Buffers 8388608 bytes
Redo Buffers 7139328 bytes
ORA-00205: error in identifying control file, check alert log for more info
then i write command to create database i.e
SQL> CREATE DATABASE db02
2 logfile
3 GROUP 1('E:\database2\log_01_db02.rdo') size 15M,
4 GROUP 2 ('E:\database2\log_02_db02.rdo') size 15M,
5 GROUP 3 ('E:\database2\log_03_db02.rdo') size 15M
6 DATAFILE 'E:\database2\SYSTEM_01_db02.DBF' SIZE 100M
7 UNDO TABLESPACE UNDO
8 DATAFILE 'E:\database2\undo_01_db02.DBF' SIZE 40m
9 sysaux datafile 'E:\database2\sysaux01.dbf' SIZE 10M
10 default temporary tablespace temp
11 tempfile 'E:\database2\temp_01_db02.dbf' size 20M
12 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K;
13 /
it display following error message.
CREATE DATABASE db02
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
so please help me that what should i do.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ORACLE instance terminated [message #533469 is a reply to message #533468] |
Wed, 30 November 2011 03:24  |
Bilal Khan
Messages: 128
Registered: April 2010
Location: Pakistan
|
Senior Member |
|
|
thanks Michel. here those line from alert log file. please check them. thanks.
Wed Nov 27 12:43:27 2002
WARNING:Shared I/O Pool created with size=0 set size=0
PMON started with pid=2, OS id=2864
PSP0 started with pid=3, OS id=1428
MMAN started with pid=4, OS id=2700
DBW0 started with pid=5, OS id=2708
LGWR started with pid=6, OS id=2704
CKPT started with pid=7, OS id=2716
SMON started with pid=8, OS id=3600
RECO started with pid=9, OS id=3620
MMON started with pid=10, OS id=2712
MMNL started with pid=11, OS id=3660
Wed Nov 27 12:43:27 2002
ALTER DATABASE MOUNT
Wed Nov 27 12:43:27 2002
ORA-00202: control file: 'E:\DATABASE2\CONTROL01DB02.CTL'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified. |
|
|
|
|
|
| Re: ORACLE instance terminated [message #533473 is a reply to message #533471] |
Wed, 30 November 2011 03:34 |
Bilal Khan
Messages: 128
Registered: April 2010
Location: Pakistan
|
Senior Member |
|
|
ok thanks. its mean i have to create that file
(CONTROL01DB02.CTL) manually (mean open notepad and save file as CONTROL01DB02.CTL on desire location) or some other method to create control file.
|
|
|
|
|
|
| Re: ORACLE instance terminated [message #533482 is a reply to message #533478] |
Wed, 30 November 2011 03:54 |
Bilal Khan
Messages: 128
Registered: April 2010
Location: Pakistan
|
Senior Member |
|
|
Dear, yes that file is avaliable in pfile, here initdb03.ora file is as
db_name = db02
instance_name = db02
control_files = (E:\database2\control01db02.ora,
E:\database2\control02db02.ora)
db_block_size = 4096
db_block_buffers = 500
shared_pool_size = 31457280
undo_tablespace = undtbs
remote_login_passwordfile = 'EXCLUSIVE'
undo_management = auto |
|
|
|
|
|
| Re: ORACLE instance terminated [message #533487 is a reply to message #533484] |
Wed, 30 November 2011 04:03 |
Bilal Khan
Messages: 128
Registered: April 2010
Location: Pakistan
|
Senior Member |
|
|
sir it display following error i.e.
Total System Global Area 75497472 bytes
Fixed Size 1247300 bytes
Variable Size 58722236 bytes
Database Buffers 8388608 bytes
Redo Buffers 7139328 bytes
ORA-00205: error in identifying control file, check alert log for more info
|
|
|
|
|
|
| Re: ORACLE instance terminated [message #534453 is a reply to message #533494] |
Tue, 06 December 2011 04:56 |
abhi_sri
Messages: 20
Registered: September 2010
Location: India
|
Junior Member |
|
|
Bilal,
The error which you are getting i.e. error in identifying control file doesnt mean that you need to creat any file.
You are not able to create a controlfile as its a binary file created by system itself. You just need to specify path in pfile that where you want to create these control files.
Once database is in nomount state, it has done the read of all parameters along with the parameter which shows, where control file will be created.
Now in mount state these control files will be created at already identified location.
Now you are getting error just because the path which you have specified where control files reside is either not correct or not have enough permission to create any file.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
