SORRY, I forgot to tell you that if you export and
import the registry, you cannot change the name of the
instance because of the services. If don't you do it
this way, you'll need to install the software and
create the database and the services as well.
Regards.
- Rangachari Sundar <sundar_at_focusite.com> wrote:
> Hi,
>
> I have given that in Init.ora and also have tried
> DBMS_SESSIOM.set_nls both not
> working...
>
> can anybody know the solution.
>
> Regards
> Sundar
>
> Greg Solomon wrote:
>
> > My boss tells me that two major projects have come
> out of Berkeley in the
> > last 50 years. One was BSD; the other was LSD ...
> go figure.
> >
> > -----Original Message-----
> > Sent: Tuesday, 10 July 2001 19:46
> > To: Multiple recipients of list ORACLE-L
> >
> > Registry, services?
> >
> > OH wait must be an NT thing, sorry, i was having
> an acid flashback that unix
> >
> > was going down the tubes.
> >
> > Sorry, joe
> >
> > Coed-naked Database Administration
> > Find 'em fragmented, leave 'em coalesced.
> >
> > >>>lhoska_at_calibresys.com 07/10/01 01:26PM >>>
> > Hello,
> > I need to recreate a database, basically make a
> complete copy of one of the
> > existing databases on a new server. My networking
> people already copied all
> > datafiles, control file, log files, init file, etc
> to the target server.
> > They also reproduced operating system directory
> structure.
> > What I need to do is to make the second part of
> the task work, create the
> > database, services, etc and make it run.
> > I have not done it before and if I was doing it I
> would probably do
> > export/import type of thing but the higher ups
> would like to have it done
> > this way.
> > One of the people has an idea suggesting just
> recreating the registry
> > setting by exporting it from the existing machine
> to the new one.
> > The other option is to reinstall Oracle but I am
> not sure how to make it to
> > accept existing physical components(datafiles,
> control file, etc).
> > If someone has a suggestion I would greatly
> appreciate it.
> > Thank you in advance.
> >
> > Lyuda Hoska
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author:
> > INET: lhoska_at_calibresys.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).
> >
> >
>
> > Get your FREE download of MSN Explorer at
> http://explorer.msn.com
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Joseph Testa
> > INET: teci_dba1_at_hotmail.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)...
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Greg Solomon
> > INET: greg.solomon_at_betfair.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).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Rangachari Sundar
> INET: sundar_at_focusite.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).
Eng. Christian Trassens
Senior DBA
Systems Engineer
ctrassens_at_yahoo.com
ctrassens_at_hotmail.com
Phone : 541149816062
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christian Trassens
INET: ctrassens_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 Wed Jul 11 2001 - 09:44:39 CDT
