| error for create temp table space in oracle 9 [message #424410] |
Fri, 02 October 2009 04:15  |
chuikingman
Messages: 90
Registered: August 2009
|
Member |
|
|
Hi,
I use below command to create database in oracle 9
CREATE DATABASE rman1
USER SYS IDENTIFIED BY rman1
USER SYSTEM IDENTIFIED BY rman1
LOGFILE GROUP 1 ('/database/oradata_rman1/rman1/redo01.log') SIZE 100M,
GROUP 2 ('/database/oradata_rman1/rman1/redo02.log') SIZE 100M,
GROUP 3 ('database/oradata_rman1/rman1/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/database/oradata_rman1/rman1/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE tempts1
DATAFILE '/database/oradata_rman1/rman1/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE 'database/oradata_rman1/rman1/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
But I get error
ERROR at line 17:
ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE
What is wrong ???
|
|
|
|
| Re: error for create temp table space in oracle 9 [message #424411 is a reply to message #424410] |
Fri, 02 October 2009 04:21  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:What is wrong ???
There is no CREATE TEMPORARY TABLESPACE in your post.
Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version with 4 decimals.
Regards
Michel
[Updated on: Fri, 02 October 2009 04:21] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: error for create temp table space in oracle 9 [message #424514 is a reply to message #424412] |
Fri, 02 October 2009 21:47 |
chuikingman
Messages: 90
Registered: August 2009
|
Member |
|
|
Hi,
I edit the comand and use below
I still get error ?? why ?? please advice ???
CREATE DATABASE rman1
USER SYS IDENTIFIED BY rman1
USER SYSTEM IDENTIFIED BY rman1
LOGFILE GROUP 1 ('/database/oradata_rman1/rman1/redo01.log') SIZE 100M,
GROUP 2 ('/database/oradata_rman1/rman1/redo02.log') SIZE 100M,
GROUP 3 ('/database/oradata_rman1/rman1/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/database/oradata_rman1/rman1/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/database/oradata_rman1/rman1/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/database/oradata_rman1/rman1/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> startup;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
|
|
|
|
|
|
| Re: error for create temp table space in oracle 9 [message #424517 is a reply to message #424515] |
Fri, 02 October 2009 22:27 |
chuikingman
Messages: 90
Registered: August 2009
|
Member |
|
|
Hi,
I create new database rman1 and get below error
please advice how to fix ??/
SQL> CREATE DATABASE rman1
2 LOGFILE GROUP 1 ('/database/oradata_rman1/rman1/redo01.log') SIZE 100M,
GROUP 2 ('/database/oradata_rman1/rman1/redo02.log') SIZE 100M,
GROUP 3 ('/database/oradata_rman1/rman1/redo03.log') SIZE 100M
3 4 5 MAXLOGFILES 5
6 MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
7 8 9 MAXINSTANCES 1
10 CHARACTER SET US7ASCII
11 NATIONAL CHARACTER SET AL16UTF16
12 DATAFILE '/database/oradata_rman1/rman1/system01.dbf' SIZE 325M REUSE
13 EXTENT MANAGEMENT LOCAL
14 DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/database/oradata_rman1/rman1/temp01.dbf'
15 16 SIZE 20M REUSE
UNDO TABLESPACE undotbs
17 18 DATAFILE '/database/oradata_rman1/rman1/undotbs01.dbf'
19 SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
CREATE DATABASE rman1
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
|
|
|
|
|
|
| Re: error for create temp table space in oracle 9 [message #424519 is a reply to message #424518] |
Fri, 02 October 2009 22:40 |
chuikingman
Messages: 90
Registered: August 2009
|
Member |
|
|
BlackSwan wrote on Sat, 03 October 2009 11:34>ORA-01092: ORACLE instance terminated. Disconnection forced
alert_SID.log file contains additional clues.
more than likely a trace file (*trc) is created & contain clues.
Hi,
I get below in alert_rman1.log
So, any advice and why there is error ???
[ora920]/opt/oracle/9.2.0/rdbms/log>ls -lt
total 8
-rw-rw-r-- 1 ora920 dba 56 Oct 3 10:40 alert_rman1.log
[ora920]/opt/oracle/9.2.0/rdbms/log>cat *.*
Sat Oct 3 10:40:57 2009
Shutting down instance (abort)
[ora920]/opt/oracle/9.2.0/rdbms/log>
|
|
|
|
|
|
| Re: error for create temp table space in oracle 9 [message #424803 is a reply to message #424517] |
Tue, 06 October 2009 01:43 |
sivakumarocp
Messages: 6
Registered: October 2009
|
Junior Member |
|
|
chuikingman wrote on Fri, 02 October 2009 22:27Hi,
I create new database rman1 and get below error
please advice how to fix ??/
SQL> CREATE DATABASE rman1
2 LOGFILE GROUP 1 ('/database/oradata_rman1/rman1/redo01.log') SIZE 100M,
GROUP 2 ('/database/oradata_rman1/rman1/redo02.log') SIZE 100M,
GROUP 3 ('/database/oradata_rman1/rman1/redo03.log') SIZE 100M
3 4 5 MAXLOGFILES 5
6 MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
7 8 9 MAXINSTANCES 1
10 CHARACTER SET US7ASCII
11 NATIONAL CHARACTER SET AL16UTF16
12 DATAFILE '/database/oradata_rman1/rman1/system01.dbf' SIZE 325M REUSE
13 EXTENT MANAGEMENT LOCAL
14 DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/database/oradata_rman1/rman1/temp01.dbf'
15 16 SIZE 20M REUSE
UNDO TABLESPACE undotbs
17 18 DATAFILE '/database/oradata_rman1/rman1/undotbs01.dbf'
19 SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
CREATE DATABASE rman1
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
check the UNDO_TABLESPACE parameter value in INIT.ORA and make sure that the name which u provided in UNDO_TABLESPACE in INIT.ORA file must match with UNDO TABLESPACE name in CREATE DATABASE script. if not instance gets terminated during database creation...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
