| after run CREATE DATABASE statement, where can I find the log file? [message #320775] |
Fri, 16 May 2008 04:01  |
crazyzhou
Messages: 18
Registered: March 2008
Location: china |
Junior 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]
|
|
|
| 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  |
Michel Cadot
Messages: 16994
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
| 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 |
crazyzhou
Messages: 18
Registered: March 2008
Location: china |
Junior 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 |
Michel Cadot
Messages: 16994
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
| 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 |
crazyzhou
Messages: 18
Registered: March 2008
Location: china |
Junior 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]
|
|
|
]
Members
Search
Help
Register
Login
Home
