Home » RDBMS Server » Server Administration » oracle instance creation using dbca errors out. (ORACLE 10g; Linux redhat)
oracle instance creation using dbca errors out. [message #307708] Wed, 19 March 2008 11:04 Go to next message
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 #307710 is a reply to message #307708] Wed, 19 March 2008 11:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
ORA-12701: CREATE DATABASE character set is not known
Cause: The character set specified when creating the database is unknown.
Action: none


Regards
Michel
Re: oracle instance creation using dbca errors out. [message #307886 is a reply to message #307708] Thu, 20 March 2008 04:30 Go to previous message
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

Previous Topic: possible to change required Oracle10g Memory?
Next Topic: Detecting unused schema
Goto Forum:
  


Current Time: Mon Dec 05 06:53:16 CST 2016

Total time taken to generate the page: 0.08504 seconds