Re: error creating database from template ( NT/9.0.1 to linux/9.2.0.1.0)

h00_at_hotmail.com (hemal) wrote in message news:<16c83c3f.0304012042.56d3cd6d_at_posting.google.com>...
> I am not a DBA and have only very basic understanding of Oracle so I
> apologize in advance for any stupid questions.
>
> I am trying to create a database on Linux (my home machine), Oracle
> server version 9.2.0.1.0 (as reported by bdump/alert_<dbname>.log)
> from a template created at work server (NT machine), oracle server
> version 9.0.1 (as reported by the <template-name>.dbc) file.
>
> I figured out that the backslashes in the dbc file have to be
> converted to frontslahes for linux paths and I have already done that.
>
> I am using dbca to create the database. I copy the dbc and dfj files
> in assistants/dbca/templates directory and choose the dbc filename as
> the template name.
>
> The errors I get in bdump/alert are as follows:
> ORA-1503 signalled during: Create controlfile reuse set database ORA9C
> MAXINS...
>
> File create/cloneDBCreation.log has some more errors, which are also
> reported by the dbca UI:
> Create controlfile reuse set database ORA9C
> *
> ERROR at line 1:
> ORA-01503: CREATE CONTROLFILE failed
> ORA-01565: error in identifying file
> '/home/oracle/OraHome1/oradata/ORA9C/DATA1.ORA'
> ORA-27047: unable to read the header block of file
> Linux Error: 92: Protocol not available
>
> Is this a version mismatch issue? OS mismatch issue? Appreciate any
> help.
>
> The command that triggers this seems to be the following (in the alert
> file):
>
> Create controlfile reuse set database ORA9C
> MAXINSTANCES 1
> MAXLOGHISTORY 1
> MAXLOGFILES 50
> MAXLOGMEMBERS 5
> MAXDATAFILES 100
> Datafile
> '/home/oracle/OraHome1/oradata/ORA9C/DATA1.ORA' ,
> '/home/oracle/OraHome1/oradata/ORA9C/INDX1.ORA' ,
> '/home/oracle/OraHome1/oradata/ORA9C/QCONTENT1.ORA' ,
> '/home/oracle/OraHome1/oradata/ORA9C/QUANTIMCONTENT.DBF' ,
> '/home/oracle/OraHome1/oradata/ORA9C/SYSTEM01.DBF' ,
> '/home/oracle/OraHome1/oradata/ORA9C/TOOLS01.DBF' ,
> '/home/oracle/OraHome1/oradata/ORA9C/UNDOTBS01.DBF' ,
> '/home/oracle/OraHome1/oradata/ORA9C/USERS01.DBF'
> LOGFILE GROUP 1 ('/home/oracle/OraHome1/oradata/ORA9C/REDO01.LOG')
> SIZE 102400K,GROUP 2
> ('/home/oracle/OraHome1/oradata/ORA9C/REDO02.LOG') SIZE 102400K,
> GROUP 3 ('/home/oracle/OraHome1/oradata/ORA9C/REDO03.LOG') SIZE
> 102400K RESETLOGS
>
>
> PS: Please reply to the newsgroup only, the e-mail address does not
> accept incoming mails.

As you are using 'reuse' the controlfile should be there. It isn't, so please remove the reuse clause.

Hth

Sybrand Bakker
Senior Oracle DBA Received on Wed Apr 02 2003 - 05:10:44 CST