Home » RDBMS Server » Server Administration » error for create temp table space in oracle 9 (oralce 9.0)
error for create temp table space in oracle 9 [message #424410] Fri, 02 October 2009 04:15 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
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 #424412 is a reply to message #424411] Fri, 02 October 2009 04:28 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

Hi Michel

But there's

DEFAULT TEMPORARY TABLESPACE tempts1
DATAFILE '/database/oradata_rman1/rman1/temp01.dbf'

I think user should change the keyword DATAFILE to TEMPFILE for temporary tablespace

http://forums.oracle.com/forums/thread.jspa?messageID=3802015#3802015

http://kamranagayev.wordpress.com/2009/05/31/create-database-manually-step-by-step-instruction/
Re: error for create temp table space in oracle 9 [message #424413 is a reply to message #424412] Fri, 02 October 2009 04:40 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Hi Michel

But there's

I can't read not formated SQL. Wink

Regards
Michel

[Updated on: Fri, 02 October 2009 04:40]

Report message to a moderator

Re: error for create temp table space in oracle 9 [message #424414 is a reply to message #424413] Fri, 02 October 2009 04:42 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

Michel Cadot wrote on Fri, 02 October 2009 14:40

I can't read not formated SQL. Wink

Regards
Michel


Sometimes me to Laughing
Re: error for create temp table space in oracle 9 [message #424514 is a reply to message #424412] Fri, 02 October 2009 21:47 Go to previous messageGo to next message
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 #424515 is a reply to message #424514] Fri, 02 October 2009 21:58 Go to previous messageGo to next message
BlackSwan
Messages: 24907
Registered: January 2009
Senior Member
>ORA-01041: internal error. hostdef extension doesn't exist

This is a FAQ!
use SEARCH or GOOGLE!

Re: error for create temp table space in oracle 9 [message #424517 is a reply to message #424515] Fri, 02 October 2009 22:27 Go to previous messageGo to next message
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 #424518 is a reply to message #424517] Fri, 02 October 2009 22:34 Go to previous messageGo to next message
BlackSwan
Messages: 24907
Registered: January 2009
Senior Member
>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.
Re: error for create temp table space in oracle 9 [message #424519 is a reply to message #424518] Fri, 02 October 2009 22:40 Go to previous messageGo to next message
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 #424520 is a reply to message #424519] Fri, 02 October 2009 22:47 Go to previous messageGo to next message
BlackSwan
Messages: 24907
Registered: January 2009
Senior Member
post results from following commands below

date
find / -name alert\*log -ls
date

I suspect clues are in some other file.
Re: error for create temp table space in oracle 9 [message #424803 is a reply to message #424517] Tue, 06 October 2009 01:43 Go to previous message
sivakumarocp
Messages: 6
Registered: October 2009
Junior Member
chuikingman wrote on Fri, 02 October 2009 22:27
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




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...


Previous Topic: To drop a job
Next Topic: Changes in the Oracle parameters
Goto Forum:
  


Current Time: Tue Sep 27 09:22:11 CDT 2016

Total time taken to generate the page: 0.09865 seconds