| Create Database - Error [message #204486] |
Mon, 20 November 2006 23:37  |
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 #204495 is a reply to message #204486] |
Tue, 21 November 2006 00:34  |
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 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
