Home » RDBMS Server » Server Administration » Create DB in Linux server using a Window's DB template
Create DB in Linux server using a Window's DB template [message #245123] Fri, 15 June 2007 04:17 Go to next message
reixanther
Messages: 3
Registered: June 2007
Junior Member
When I tried to create a db in linux using a window-based DB template, I encoutered the ff. errors:
ORA-01078: failure in processing system parameters.

When I looked into the log file generated, I found out that it looks for adminDBNAMEpfileinit.ora instead of admin/DBNAME/pfile/init.ora.

Is there a possibility to use a window's db template in creating DB in linux server? If so, how?
Re: Create DB in Linux server using a Window's DB template [message #245126 is a reply to message #245123] Fri, 15 June 2007 04:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why don't you use a Linux template?

Regards
Michel
Re: Create DB in Linux server using a Window's DB template [message #245132 is a reply to message #245123] Fri, 15 June 2007 04:45 Go to previous messageGo to next message
reixanther
Messages: 3
Registered: June 2007
Junior Member

We only have a database in windows. It already contains lots of data. We need to clone this database in a Linux machine. So we created a template from that database in windows and try to use it in Linux.

Only Oracle DBCA predefined Linux templates are present in our Linux server.

Is it possible?
Re: Create DB in Linux server using a Window's DB template [message #245142 is a reply to message #245132] Fri, 15 June 2007 05:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at cloning/duplicate functions in RMAN.
Have a look at export/import utilities.

Regards
Michel
Re: Create DB in Linux server using a Window's DB template [message #245149 is a reply to message #245123] Fri, 15 June 2007 05:38 Go to previous message
reixanther
Messages: 3
Registered: June 2007
Junior Member
Okay. Thanks.
Previous Topic: Error - PL/SQL: ORA-00984
Next Topic: how to drop datafile i've allready droped the tablespace in which my datafile reside
Goto Forum:
  


Current Time: Thu Sep 19 21:32:53 CDT 2024