Help me with this error when DBCA ORA-02236: invalid file name [message #359380] |
Sat, 15 November 2008 09:48 |
crazypeter2005
Messages: 29 Registered: September 2008 Location: Peking China
|
Junior Member |
|
|
Hi
When I use DBCA to create a DB, soon the DBCA prompt me an error ORA-02236: invalid file name. Please help to check why this happen and how to solve it.
Here is Log
Trace.log of DBCA:
[TaskScheduler timer] [23:24:42:513] [OsUtilsUnix.getKernelParam:955] Kernel Parameter: shmsys:shminfo_shmmax value4294967295
[TaskScheduler timer] [23:24:42:513] [Verifier.validateTemplate:1629] StorageType == 0
[TaskScheduler timer] [23:24:42:515] [Verifier.calculateDatafilePathsAndSizes:2791] canonicalPath=/opt/oracle10g/oradata/svtlsdb/
[TaskScheduler timer] [23:24:42:515] [Verifier.calculateDatafilePathsAndSizes:2791] canonicalPath=/opt/oracle10g/oradata/svtlsdb/
[TaskScheduler timer] [23:24:42:516] [Verifier.calculateDatafilePathsAndSizes:2791] canonicalPath=/opt/oracle10g/oradata/svtlsdb/
[TaskScheduler timer] [23:24:42:516] [Verifier.calculateDatafilePathsAndSizes:2791] canonicalPath=/opt/oracle10g/oradata/svtlsdb/
[TaskScheduler timer] [23:24:42:516] [Verifier.calculateDatafilePathsAndSizes:2791] canonicalPath=/opt/oracle10g/oradata/svtlsdb/
[TaskScheduler timer] [23:24:42:517] [Verifier.calculateDatafilePathsAndSizes:2791] canonicalPath=/opt/oracle10g/oradata/svtlsdb/
[TaskScheduler timer] [23:24:42:517] [Verifier.calculateDatafilePathsAndSizes:2791] canonicalPath=/opt/oracle10g/oradata/svtlsdb/
[TaskScheduler timer] [23:24:42:517] [Verifier.calculateDatafilePathsAndSizes:2791] canonicalPath=/opt/oracle10g/oradata/svtlsdb/
[TaskScheduler timer] [23:24:42:518] [Verifier.calculateDatafilePathsAndSizes:2791] canonicalPath=/opt/oracle10g/oradata/svtlsdb/
[TaskScheduler timer] [23:24:42:518] [Verifier.calculateRedoLogGroupFileSizes:3083] canonicalPath=/opt/oracle10g/oradata/svtlsdb/
[TaskScheduler timer] [23:24:42:519] [Verifier.calculateRedoLogGroupFileSizes:3083] canonicalPath=/opt/oracle10g/oradata/svtlsdb/
[TaskScheduler timer] [23:24:42:519] [Verifier.getControlfFileSizes:3001] No. of Control files:=2
[Thread-20] [23:24:42:576] [UIHost.getHtmlSummary:1030] UIHost:getHtmlSummary: running createTemplateDocument NOT for SHOW_TEMPLATE condition
[Thread-20] [23:24:42:591] [UIHost.getHtmlSummary:1036] UIHost:getHtmlSummary: after running createTemplateDocument NOT for SHOW_TEMPLATE condition
[Thread-20] [23:24:42:684] [UIHost.getHtmlSummary:1075] UIHost->getHtmlSummary: start printing of transformed document
[TaskScheduler timer] [23:24:44:598] [Host.executeSteps:4042] Executing steps....
[TaskScheduler timer] [23:24:44:599] [Host.setUpForOperation:2918] setUpForOperation: Mode = 1
[TaskScheduler timer] [23:24:44:602] [Host.executeSteps:4184] setupForOperation returned: true
[TaskScheduler timer] [23:24:44:602] [Host.createStepSQLInterface:5946] sid =svtlsdb
[TaskScheduler timer] [23:24:44:604] [SQLEngine.getEnvParams:424] NLS_LANG: AMERICAN_AMERICA.UTF8
[TaskScheduler timer] [23:24:44:605] [SQLEngine.initialize:241] Execing SQLPLUS/SVRMGR process...
[TaskScheduler timer] [23:24:44:635] [SQLEngine.initialize:269] m_bReaderStarted: false
[TaskScheduler timer] [23:24:44:636] [SQLEngine.initialize:273] Starting Reader Thread...
[TaskScheduler timer] [23:24:44:637] [SQLEngine.initialize:322] Waiting for m_bReaderStarted to be true
[Thread-23] [23:24:44:715] [StepContext$ModeRunner.run:2458] ---- Progress Needed:=true
[Thread-23] [23:24:44:752] [BasicStep.execute:202] Executing Step : DB_ENTRY
[Thread-23] [23:24:44:753] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01501
[Thread-23] [23:24:44:753] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01092
[Thread-23] [23:24:44:753] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01034
[Thread-23] [23:24:44:754] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-03114
[Thread-23] [23:24:44:754] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-12560
[Thread-23] [23:24:44:754] [BasicStep.configureSettings:304] messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@16b98c3
[Thread-23] [23:24:44:754] [BasicStep.execute:202] Executing Step : INSTANCE_CREATION
[Thread-23] [23:24:44:755] [BasicStep.configureSettings:304] messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@16b98c3
[Thread-23] [23:24:44:756] [InitParamAttributes.sortParams:3525] m_sortOn:4 sortOn:4
[Thread-23] [23:24:44:763] [Host.noEntryinOratab:5113] Check made for oratab arg passed............
[Thread-23] [23:24:44:763] [Oratab.getTempFile:710] Temp oratab: /tmp/oratab
[Thread-23] [23:24:45:117] [BasicStep.configureSettings:304] messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@16b98c3
[Thread-23] [23:24:45:196] [SQLEngine.setSpool:1743] old Spool = null
[Thread-23] [23:24:45:196] [SQLEngine.setSpool:1744] Setting Spool = /opt/oracle10g/cfgtoollogs/dbca/svtlsdb/CreateDB.log
[Thread-23] [23:24:45:196] [SQLEngine.setSpool:1745] Is spool appendable? --> true
[Thread-23] [23:24:45:197] [DBEntryStep.executeImpl:255] undoMgmt=AUTO
[Thread-23] [23:24:45:197] [DBEntryStep.executeImpl:256] undoMgmt=true
[Thread-23] [23:24:45:197] [DBEntryStep.executeImpl:275] undoTBS=UNDOTBS1
[Thread-23] [23:24:46:620] [DBEntryStep.executeImpl:391] undoTBS create SQL=CREATE SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE '{ORACLE_BASE}/oradata/{DB_NAME}/{DB_NAME}_UNDOTBS1_01.dbf' SIZE 50M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
[Thread-23] [23:24:46:620] [DBEntryStep.executeImpl:440] 0th redoLogText = GROUP 1 ('{ORACLE_BASE}/oradata/{DB_NAME}/{DB_NAME}_redo1_1.log') SIZE 51200K REUSE
[Thread-23] [23:24:46:621] [DBEntryStep.executeImpl:440] 1th redoLogText = GROUP 2 ('{ORACLE_BASE}/oradata/{DB_NAME}/{DB_NAME}_redo1_2.log') SIZE 51200K REUSE
[Thread-23] [23:24:46:621] [DBEntryStep.executeImpl:457] CREATEDB without passwords = CREATE DATABASE "svtlsdb"
MAXINSTANCES 32
MAXLOGHISTORY 0
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
DATAFILE '/opt/oracle10g/oradata/svtlsdb/svtlsdb_SYSTEM_01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/opt/oracle10g/oradata/svtlsdb/svtlsdb_TEMP_01.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE '/opt/oracle10g/oradata/svtlsdb/svtlsdb_UNDOTBS1_01.dbf' SIZE 50M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/opt/oracle10g/oradata/svtlsdb/svtlsdb_redo1_1.log') SIZE 51200K REUSE,
GROUP 2 ('/opt/oracle10g/oradata/svtlsdb/svtlsdb_redo1_2.log') SIZE 51200K REUSE
[Thread-21] [23:24:46:625] [BasicStep.handleNonIgnorableError:430] oracle.sysman.assistants.util.UIMessageHandler@16b98c3:messageHandler
[Thread-21] [23:24:46:626] [BasicStep.handleNonIgnorableError:431] ORA-02236: invalid file name
:msg
This Error seems to be with wrong format of SQL.
But which one, please point it out, thanks all.
|
|
|
|
|
|
Re: Help me with this error when DBCA ORA-02236: invalid file name [message #492410 is a reply to message #435167] |
Mon, 31 January 2011 00:51 |
|
mirali
Messages: 3 Registered: January 2011 Location: hyderabad
|
Junior Member |
|
|
gabriela_leal wrote on Tue, 15 December 2009 03:55Thank you very much
startup nomount
create controlfile set database "mydb" resetlogs archivelog
maxlogfiles 16
maxlogmembers 5
maxdatafiles 30
maxinstances 1
maxloghistory 292
logfile
group 1 (
'/disk2/mydb/oradata/redolog1a.redo',
'/disk2/mydb/oradata/redolog1b.redo'
) size 4m,
group 3 (
'/disk2/mydb/oradata/redolog3a.redo',
'/disk2/mydb/oradata/redolog3b.redo'
) size 4m,
DATAFILE
'/disk2/mydb/oradata/system.dbf',
'/disk2/mydb/oradata/undo.dbf',
'/disk2/mydb/oradata/sysaux.dbf',
'/disk2/mydb/oradata/users.dbf',
'/disk2/mydb/oradata/dbats1.dbf',
'/disk2/mydb/oradata/hot1.dbf'
CHARACTER SET US7ASCII
;
|
|
|
|
|
Re: Help me with this error when DBCA ORA-02236: invalid file name [message #492418 is a reply to message #492417] |
Mon, 31 January 2011 01:30 |
|
mirali
Messages: 3 Registered: January 2011 Location: hyderabad
|
Junior Member |
|
|
startup nomount
create controlfile set database "mydb" resetlogs archivelog
maxlogfiles 16
maxlogmembers 5
maxdatafiles 30
maxinstances 1
maxloghistory 292
logfile
group 1 (
'/disk2/mydb/oradata/redolog1a.redo',
'/disk2/mydb/oradata/redolog1b.redo'
) size 4m,
group 3 (
'/disk2/mydb/oradata/redolog3a.redo',
'/disk2/mydb/oradata/redolog3b.redo'
) size 4m,
DATAFILE
'/disk2/mydb/oradata/system.dbf',
'/disk2/mydb/oradata/undo.dbf',
'/disk2/mydb/oradata/sysaux.dbf',
'/disk2/mydb/oradata/users.dbf',
'/disk2/mydb/oradata/dbats1.dbf',
'/disk2/mydb/oradata/hot1.dbf'
CHARACTER SET US7ASCII
;
I am cloning oracle 10g database, when i am creating control file it gives error invalid file name ora-02236 error
|
|
|
Re: Help me with this error when DBCA ORA-02236: invalid file name [message #492420 is a reply to message #492418] |
Mon, 31 January 2011 01:42 |
|
Michel Cadot
Messages: 68728 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
You cannot create a 10g control file with this statement.
Where did you get it?
Use SQL*Plus and copy and paste your session, the WHOLE session.
Before, 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: Mon, 31 January 2011 01:43] Report message to a moderator
|
|
|