Home » RDBMS Server » Server Administration » Create Database - Error
Create Database - Error [message #204486] Mon, 20 November 2006 23:37 Go to next message
prashanth_gs
Messages: 67
Registered: November 2005
Location: chennai
Member
Hi all,

I am creating new database. While executing the create database script i am getting the error as

CREATE DATABASE gdbuat
2 CHARACTER SET "UTF8"
3 NATIONAL CHARACTER SET "UTF8"
4 Datafile '/gdbuat5/oradata/gdbuat/system01.dbf' Size 300M
5 EXTENT MANAGEMENT LOCAL
6 SYSAUX Datafile '/gdbuat5/oradata/gdbuat/sysaux01.dbf' SIZE 300M
7 Undo Tablespace UNDOTBS1
8 Datafile '/gdbuat2/oradata/gdbuat/undotbs01.dbf' Size 200M
9 DEFAULT TEMPORARY TABLESPACE TEMP1
10 tempfile '/gdbuat2/oradata/gdbuat/temp01.dbf' Size 300M
11 LOGFILE GROUP 1 ('/gdbuat2/oradata/gdbuat/log01a.rdo','/gdbuat3/oradata/gdbuat/log01b.rdo') SIZE 50 M,
12 GROUP 2 ('/gdbuat2/oradata/gdbuat/log02a.rdo','/gdbuat3/oradata/gdbuat/log02b.rdo') SIZE 50 M,
13 GROUP 3 ('/gdbuat2/oradata/gdbuat/log03a.rdo','/gdbuat3/oradata/gdbuat/log03b.rdo') SIZE 50 M
14 ;
CREATE DATABASE gdbuat
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

While looking on the trace file I found error such as

Dump file /gdbuat1/oradata/gdbuat/bdump/gdbuat_lgwr_11032.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /oracle10g/app/oracle/product/10r22
System name: SunOS
Node name: gecfsprd15
Release: 5.8
Version: Generic_117350-36
Machine: sun4u
Instance name: gdbuat
Redo thread mounted by this instance: 1
Oracle process number: 6
Unix process pid: 11032, image: oracle@gecfsprd15 (LGWR)

*** 2006-11-21 05:43:35.981
*** SERVICE NAME:() 2006-11-21 05:43:35.979
*** SESSION ID:(296.1) 2006-11-21 05:43:35.979
Maximum redo generation record size = 156160 bytes
Maximum redo generation change vector size = 150676 bytes
~
How to fix this issue.

Db Version: 10.2.0.1.0
Os Version : Sun Solaris 5.8

Prashanth

Re: Create Database - Error [message #204491 is a reply to message #204486] Tue, 21 November 2006 00:03 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi

Can you plz post here last few lines in Alert.log file.


regards
Taj.
Re: Create Database - Error [message #204495 is a reply to message #204486] Tue, 21 November 2006 00:34 Go to previous messageGo to next message
prashanth_gs
Messages: 67
Registered: November 2005
Location: chennai
Member
Hi Taj,

Thanks for your response.

I found out the reason, Actually UNDO tablespace name mentioned in my script is not similar which i mentioned in the init.ora file. I changed so and it worked.

Database is created successfully.

Thanks

Prashanth
Re: Create Database - Error [message #204496 is a reply to message #204495] Tue, 21 November 2006 00:39 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi ,

Yes i am guessing problem in database creation if "instance termination" error is occured then most possibly error is relate to undo tbs. like missing , miss spell etc.

but i was check in ur create database script and undo tbs is specified then i said to you check alert.log file for what is the mean problem behind this...


Any way
Good.

Regards
Taj.

[Updated on: Tue, 21 November 2006 00:40]

Report message to a moderator

Previous Topic: problem while using export utility
Next Topic: UNIQUE row in SYS.AUD$
Goto Forum:
  


Current Time: Sat Dec 03 01:22:11 CST 2016

Total time taken to generate the page: 0.30818 seconds