If its giving the message " Insufficient Priviledges"
then try copying the init.ora file again from the
source to the server where r u wan't to create a
database. If u wan't to edit the init.ora file to
change some parameters, use edit, never use notepad
to edit the init.ora file. Opening init.ora file in
notepad might corrupt the init.ora.
Arvind
- "Jefferson, Dean" <Dean.Jefferson_at_oci.state.wi.us>
wrote:
> I've done this many times on NT, by shuting down the
> source database,
> copying ALL database files to the new server,
> creating an instance with the
> same SID on the target server and just openning it
> up and running it.
>
> Here is the statement I use to create the instance.
> Note that I set the
> internal password to "manager", I think the default
> is "oracle":
>
> oradim -new -sid TEST -intpwd manager -startmode
> auto -pfile
> E:\Oradata\TESTdb\pfiles\initTEST.ora
>
> The trick is that the directory structure where any
> and all database files
> are stored must be identical on the source and
> target servers. Otherwise you
> must play around with telling Oracle that the
> datafile that used to be here
> is now there...
>
> HTH,
>
> Dean Jefferson
> Database Administrator
> State of Wisconsin
> Office of Commissioner of Insurance
> Dean.Jefferson_at_oci.state.wi.us
>
> > -----Original Message-----
> > From: Yuzie [mailto:tekait11_at_bni.co.id]
> > Sent: Friday, March 23, 2001 3:41 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Transporting Database
> >
> >
> > Dear DBAs,
> >
> > I have 2 NT servers, Oracle8 (8.0.5) Server has
> been
> > installed on each of
> > them. One server has a database and no database on
> another.
> > Is it possible
> > to move or duplicate a database from one servwer
> to another?
> > Based on my
> > conceptual understanding, this will work, but I it
> failed
> > when I tried.
> > Therefore, I need your confirmation.
> >
> > What I have tried is:
> > 1. Copy physical control files and initialization
> parameter file.
> > 2. Run ORADIM and all services are started.
> > Problem: I can not connect internal. Actually, I
> want to try
> > to create an
> > instance, startup nomount, and use the init
> file/control
> > file. But I can not
> > go further because I can not login to the instance
> as internal or sys.
> >
> > Sorry, crossposting.
> > Thnx lots
> > Yuzzie N.
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Yuzie
> > INET: tekait11_at_bni.co.id
> >
> > Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California -- Public Internet
> access / Mailing Lists
> >
>
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from). You may
> > also send the HELP command for other information
> (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Jefferson, Dean
> INET: Dean.Jefferson_at_oci.state.wi.us
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arvind Aggarwal
INET: oradba9_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Sun Mar 25 2001 - 15:09:34 CST