Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> error creating database from template ( NT/9.0.1 to linux/9.2.0.1.0)
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.
Received on Tue Apr 01 2003 - 22:42:19 CST
![]() |
![]() |