Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> error creating database from template ( NT/9.0.1 to linux/9.2.0.1.0)

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

From: hemal <h00_at_hotmail.com>
Date: 1 Apr 2003 20:42:19 -0800
Message-ID: <16c83c3f.0304012042.56d3cd6d@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. Received on Tue Apr 01 2003 - 22:42:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US