Home » RDBMS Server » Server Administration » after run CREATE DATABASE statement, where can I find the log file? (oracle10g 10.2.0 RHEL5)
after run CREATE DATABASE statement, where can I find the log file? [message #320775] Fri, 16 May 2008 04:01 Go to next message
crazyzhou
Messages: 38
Registered: March 2008
Location: china
Member
I create the database with CREATE DATABASE statement, but something is wrong, the datafiles have created, but there is a error, and the database can not be startup with mount:
ORA-01079 ORACLE database was not properly created, operation aborted. 

in the responceFile, I have set the ORACLE_HOME_NAME, but didnot set some parameter for ORACLE_BASE, so I don't know where the alert file alert.log is.
can you tell me what wrong with my creation or where the alert.log is?
thank you.

[Updated on: Fri, 16 May 2008 04:03]

Report message to a moderator

Re: after run CREATE DATABASE statement, where can I find the log file? [message #320784 is a reply to message #320775] Fri, 16 May 2008 04:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I have set the ORACLE_HOME_NAME

This is wrong, the parameter is ORACLE_HOME.

Quote:
so I don't know where the alert file alert.log is.

find / -name 'alert*ora' -print

Regards
Michel
Re: after run CREATE DATABASE statement, where can I find the log file? [message #320793 is a reply to message #320784] Fri, 16 May 2008 04:48 Go to previous messageGo to next message
crazyzhou
Messages: 38
Registered: March 2008
Location: china
Member
thanks michel.
ORACLE_HOME_NAME is for the name of oracle_home, I confuse them.
Now I find the alert.log, in the alert.log, I find something like this:
Completed: CREATE TEMPORARY TABLESPACE TEMPTS1 TEMPFILE  '/u01/oracle/oradata_silence/temp01.dbf'
      SIZE 20M REUSE

Fri May 16 17:29:18 2008
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTS1
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTS1
Fri May 16 17:29:18 2008
Errors in file /u01/oracle/product/silence_test/rdbms/log/silence_ora_23749.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Fri May 16 17:29:18 2008
Errors in file /u01/oracle/product/silence_test/rdbms/log/silence_ora_23749.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 6262
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Instance terminated by USER, pid = 23749
ORA-1092 signalled during: CREATE DATABASE silence


and in the trace file silence_ora_23749.trc, i get this:
login as: oracle
oracle@130.55.128.17's password:
Last login: Fri May 16 09:12:46 2008 from 130.55.136.5
[oracle@localhost ~]$ cd /u01/oracle/product/silence_test/rdbms/log/
[oracle@localhost log]$ ls
alert_silence.log       silence_ora_22686.trc  silence_ora_23529.trc
silence_lgwr_22734.trc  silence_ora_22707.trc  silence_ora_23550.trc
silence_lgwr_23200.trc  silence_ora_22724.trc  silence_ora_23652.trc
silence_lgwr_23738.trc  silence_ora_22745.trc  silence_ora_23728.trc
silence_ora_22590.trc   silence_ora_23188.trc  silence_ora_23749.trc
silence_ora_22682.trc   silence_ora_23211.trc
[oracle@localhost log]$ vi alert_silence.log
[oracle@localhost log]$ vi silence_ora_23749.trc
Release:        2.6.18-8.el5
Version:        #1 SMP Fri Jan 26 14:15:21 EST 2007
Machine:        i686
Instance name: silence
Redo thread mounted by this instance: 0 <none>
Oracle process number: 12
Unix process pid: 23749, image: oracle@localhost.localdomain (TNS V1-V3)

*** SERVICE NAME:() 2008-05-16 17:27:08.510
*** SESSION ID:(50.1) 2008-05-16 17:27:08.510
kccsga_update_ckpt: num_1 = 1, num_2 = 0, num_3 = 0, lbn_2 = 0, lbn_3 = 0
*** 2008-05-16 17:28:27.756
kccsga_update_ckpt: num_1 = 1, num_2 = 0, num_3 = 0, lbn_2 = 0, lbn_3 = 0
Control file created with size 416 blocks
*** 2008-05-16 17:29:18.735
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Offending statement at line 6262
CREATE  TABLESPACE TBS_1 DATAFILE  SEGMENT SPACE MANAGEMENT MANUAL
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 6262
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name



it say the invalid file name, but which file?
Re: after run CREATE DATABASE statement, where can I find the log file? [message #320796 is a reply to message #320793] Fri, 16 May 2008 04:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
it say the invalid file name, but which file?

One of the file you declare in CREATE DATABASE statement.
Search line 6262 of ?/rdbms/admin/sql.bsq', I think could be related to "CREATE TABLESPACE TBS_1 DATAFILE SEGMENT SPACE MANAGEMENT MANUAL". Maybe the default tablespace. Post your CREATE DATABASE statement.

Regards
Michel
Re: after run CREATE DATABASE statement, where can I find the log file? [message #320966 is a reply to message #320796] Sat, 17 May 2008 01:26 Go to previous message
crazyzhou
Messages: 38
Registered: March 2008
Location: china
Member
I copy the CREATE STATEMENT from the Oracle's Document, so I just edit the db_name and the tablespace name, and did not check the others statement. in their document, the statement DEFAULT TABLESAPCE ... is following the statement DATAFILE...
it's so obvious. now I created the database successfully.
thank you, Michel, you're so kinkly.

[Updated on: Sat, 17 May 2008 01:35]

Report message to a moderator

Previous Topic: temporary tablespace usage
Next Topic: compiling invalid objects
Goto Forum:
  


Current Time: Sat Dec 10 22:15:05 CST 2016

Total time taken to generate the page: 0.07472 seconds