Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CHANGING DBNAME 10G 1

Status
Not open for further replies.

THEaix

MIS
Jun 7, 2007
30
US
I've been trying to change the DBname all *^*)^(^ morning.
I've shutdown the DB
sqlplus as sysdba
startup mount
nid target=sys/oracle@tmparc DBNAME=ARC02 SETNAME=YES
AND I GET:

DBNEWID: Release 10.2.0.4.0 - Production on Thu Jan 29 11:30:09 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to database TMPARC (DBID=1690874975)
NID-00121: Database should not be open
Change of database name failed during validation - database is intact.
DBNEWID - Completed with validation errors.


What am I missing?
 
FIGured it out. %&$*& kornshell. needed to export SID after setting it.

 
Thanks for %&$*& posting the %&$*& answeer. Have a %&$*& star!

I want to be good, is that not enough?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top