Home » RDBMS Server » Server Administration » Help me with this error when DBCA ORA-02236: invalid file name (Solaris spark64 5.9 Oralce Enterprise Server 10.2.0.3)
Help me with this error when DBCA ORA-02236: invalid file name [message #359380] Sat, 15 November 2008 09:48 Go to next message
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 #359396 is a reply to message #359380] Sat, 15 November 2008 12:18 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
02236, 00000, "invalid file name"
// *Cause:  A character string literal was not used in the filename list
//          of a LOGFILE, DATAFILE, or RENAME clause.
// *Action: Use correct syntax.


Try to specify a SYSAUX DATAFILE name.
Re: Help me with this error when DBCA ORA-02236: invalid file name [message #359425 is a reply to message #359396] Sat, 15 November 2008 19:08 Go to previous messageGo to next message
crazypeter2005
Messages: 29
Registered: September 2008
Location: Peking China
Junior Member
Thanks!
It solved!
I used the 9i template in DBCA.
When I change to 10g template, it passed.
I compared them, the SYSAUX tablespace is one difference.
icon14.gif  Re: Help me with this error when DBCA ORA-02236: invalid file name [message #435167 is a reply to message #359425] Mon, 14 December 2009 18:55 Go to previous messageGo to next message
gabriela_leal
Messages: 6
Registered: January 2006
Location: Houston
Junior Member
Thank you very much
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 Go to previous messageGo to next message
mirali
Messages: 3
Registered: January 2011
Location: hyderabad
Junior Member
gabriela_leal wrote on Tue, 15 December 2009 03:55
Thank 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 #492415 is a reply to message #492410] Mon, 31 January 2011 01:10 Go to previous messageGo to next message
Michel Cadot
Messages: 63802
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Question What will you do with this very old control file creation statement?
And what is your purpose to register to answer this very old topic without a single word of explaination?

Regards
Michel
Re: Help me with this error when DBCA ORA-02236: invalid file name [message #492417 is a reply to message #492415] Mon, 31 January 2011 01:27 Go to previous messageGo to next message
mirali
Messages: 3
Registered: January 2011
Location: hyderabad
Junior Member
I am doing a clonning in oracle 10g when i am creating a control file it give invalid file name error i check everything.
please help me in this regard
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 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 63802
Registered: March 2007
Location: Nanterre, France, http://...
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

Previous Topic: Single big tablespace versus multiple tablespace
Next Topic: How to know DB size increase per day?
Goto Forum:
  


Current Time: Sun Sep 25 14:32:12 CDT 2016

Total time taken to generate the page: 0.09365 seconds