after run CREATE DATABASE statement, where can I find the log file? [message #320775] |
Fri, 16 May 2008 04:01 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #320793 is a reply to message #320784] |
Fri, 16 May 2008 04:48 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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?
|
|
|
|
|