| oracle instance creation using dbca errors out. [message #307708] |
Wed, 19 March 2008 11:04  |
geeklol
Messages: 59
Registered: March 2005
|
Member |
|
|
Hi all,
I am trying to install an oracle instance on a linux redhat box using dbca and about 55% into the creation of the instance it dies. giving errors,
ORA-01092:oracle instance terminated disconnection forced.
The end of my alert log says,
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=13872
"alert_rcatg.log" 572L, 24114C 1,1 Top
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Wed Mar 19 07:53:58 2008
Errors in file /usr/local/oracle/admin/rcatg/udump/rcatg_ora_14111.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/db01/oradata/rcat/data/rcatg/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Wed Mar 19 07:54:00 2008
Setting recovery target incarnation to 2
Wed Mar 19 07:54:00 2008
Assigning activation ID 3099819857 (0xb8c37f51)
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: /db01/oradata/rcat/data/rcatg/redo03.log
Successful open of redo thread 1
Wed Mar 19 07:54:00 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Mar 19 07:54:00 2008
SMON: enabling cache recovery
Wed Mar 19 07:54:00 2008
Successfully onlined Undo Tablespace 1.
Dictionary check beginning
Tablespace 'TEMP' #3 found in data dictionary,
but not in the controlfile. Adding to controlfile.
Dictionary check complete
Wed Mar 19 07:54:00 2008
SMON: enabling tx recovery
Wed Mar 19 07:54:00 2008
*********************************************************************
WARNING: The following temporary tablespaces contain no files.
This condition can occur when a backup controlfile has
been restored. It may be necessary to add files to these
tablespaces. That can be done using the SQL statement:
ALTER TABLESPACE <tablespace_name> ADD TEMPFILE
Alternatively, if these temporary tablespaces are no longer
needed, then they can be dropped.
Empty temporary tablespace: TEMP
*********************************************************************
Wed Mar 19 07:54:00 2008
Errors in file /usr/local/oracle/admin/rcatg/udump/rcatg_ora_14111.trc:
ORA-12701: CREATE DATABASE character set is not known
Error 12701 happened during db open, shutting down database
USER: terminating instance due to error 12701
Instance terminated by USER, pid = 14111
ORA-1092 signalled during: alter database "rcatg" open resetlogs...
Please help.
|
|
|
|
|
|
| Re: oracle instance creation using dbca errors out. [message #307886 is a reply to message #307708] |
Thu, 20 March 2008 04:30  |
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
|
Senior Member |
 
|
|
|
ORA-12701: CREATE DATABASE character set is not known
Cause: The character set specified in the CREATE DATABASE command does not exist on the system.
Action: Refer to your Oracle operating system-specific documentation for more information about character sets on the system. Use a valid character set in the CREATE DATABASE command.
[Updated on: Thu, 20 March 2008 04:31] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
