| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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)
Morning,
it sounds like you are actually trying to clone a database not create one from a template- but I could be wrong !
If you have copied the datafiles over from the NT server then forget it - it will not work. You cannot use NT datafiles on any other system except NT.
If you are running the 'create controlfile' command, then the datafiles listed *must* already exist on your Linux box, in the locations given. If you are trying to create a new database and the files don't exist, then you are going about it all the wrong way I'm afraid.
Do this :
Create a [few] directory [ies] for the datafiles, controlfiles etc to
live in.
Make sure that the Oracle user (where the software was installed into)
owns the directories. (CHOWN)
Make sure the dba group (which the Oracle user should be in) owns the
directories. (CHGRP)
Now create a database using the dbca utility. You will be given some
templates to work from - I'd start with the general purpose one for now.
Make sure that the 'environment' variables used in dbca are set to point
at the appropriate directories you created. (There's a button called
'file locations' - or similar - I'm not near a Linux box at the moment)
and that the files being created are using your 'environment' variables
and not the default ones.
Make sure you tick the box to 'save this as a new template' so that you
can use it again.
Enjoy.
Regards,
Norman.
Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.com
-------------------------------------
-----Original Message-----
From: h00_at_hotmail.com (hemal) [mailto:h00_at_hotmail.com]
Posted At: Wednesday, April 02, 2003 5:42 AM
Posted To: server
Conversation: error creating database from template ( NT/9.0.1 to
linux/9.2.0.1.0)
Subject: 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.
<SNIP> Received on Wed Apr 02 2003 - 02:14:22 CST
 |
 |