We help IT Professionals succeed at work.

Unable to create 9i database manually

banumyname
banumyname used Ask the Experts™
on
Dear Gurus,

I have an application that needs only 9i. I am trying to create database manually. the database is created but unable to open , Instance getting terminated forcefully throwing error as below,


SQL> startup force mount;
ORACLE instance started.

Total System Global Area 1242650240 bytes
Fixed Size                   456320 bytes
Variable Size             922746880 bytes
Database Buffers          318767104 bytes
Redo Buffers                 679936 bytes
Database mounted.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced



My alert log says,


Errors in file /**/**/admin/udump/pfs_ora_19029.trc:
ORA-01403: no data found
Error 1403 happened during db open, shutting down database
USER: terminating instance due to error 1403
Instance terminated by USER, pid = 19029
ORA-1092 signalled during: alter database open...


this trace files says.



"/**/**/admin/udump/pfs_ora_19029.trc" [Read only] 42 lines, 1513 characters
/**/**/admin/udump/pfs_ora_19029.trc
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
JServer Release 9.2.0.8.0 - Production
ORACLE_HOME = /**/**/orahome
System name:    SunOS
Node name:      ******
Release:        5.10
Version:        Generic_142900-09
Machine:        sun4u
Instance name: pfs
Redo thread mounted by this instance: 1
Oracle process number: 8
Unix process pid: 19029, image: oracle@****(TNS V1-V3)

*** SESSION ID:(7.3) 2012-04-18 09:24:47.825
Thread 1 recovery from rba:0x000001.000056b4.0010 scn:0x0000.00001932
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 149Kb in 0.13s => 0.00 Mb/sec
Longest record: 16Kb, moves: 0/782 (0%)
Change moves: 2/3 (66%), moved: 0Mb
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 99/99 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 1456/2793 = 0.5
----------------------------------------------
*** 2012-04-18 09:24:48.317
KCRA: start recovery claims for 99 data blocks
*** 2012-04-18 09:24:48.326
KCRA: buffers claimed = 99/99, eliminated = 0
*** 2012-04-18 09:24:48.330
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 99/99 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 1540/1554 = 1.0
----------------------------------------------
ORA-01403: no data found


Please help me out gurus..


Thanks...
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
RindbaekSenior Consultant

Commented:
Could you please describe the steps you took to create the database manually?

Including what scripts did you run and how does your pfile look?
Thanks for quick reply,

I just resolved my problem,

I have used a different character set before AL16UTF16 to create the database, Now I changed this to UFT8 and it went fine.

Thanks a lot Rindbaek
RindbaekSenior Consultant

Commented:
youre welcome

Author

Commented:
I have identified the error