J maruti, July 14, 2001 - 10:37 am UTC
I liked the way article was written and also enjoyed reading and following the instructions. They are very clear.
renaming a database and sid in NT
Shajan Joseph, August 08, 2001 - 11:15 pm UTC
The step by step instructions is very useful
renaming a database and sid in NT
Sunny, August 27, 2001 - 3:31 pm UTC
This article helped me out big-time . This also applies to cloning your database. THanks Tom
renaming a database - followup
Ranajit, January 16, 2002 - 11:59 am UTC
I want to create the control file using sql script on the fly and hence want to know where to look for MAXDATAFILES, MAXINSTANCES in the database ?
January 16, 2002 - 3:14 pm UTC
just use
alter database backup controlfile to trace;
we create the create controlfile statement on the fly for you. Look in your user_dump_destination after running that for the statement.
Error ORA-1161
Vladimir, January 17, 2002 - 12:01 pm UTC
Very clear outline however I got the above error. It states that data file headers stil contain old SID. Could you elaborate how to rectify this. P.S. I renamed them to SYS1new_name.ora and etc... It is my fist time post and I would like to join many people showing my appreciation of the work you do! Thanks.
January 17, 2002 - 12:11 pm UTC
> oerr ora 1161
01161, 00000, "database name %s in file header does not match given name of %s"
// *Cause: The database name given at the command line does not match the
// database name found in the file header.
// *Action: Chance are good that the database name specified at the command
// line is incorrect. Resolve the descepency, and resubmit the command.
// If you are attempting to change the database name, be sure to
// use the SET DATABASE option.
I believe you skipped step 7d
Excellent !
Magnus Herrstrom, January 18, 2002 - 2:55 am UTC
In most manuals and books they say that this can't be done or recommend not to do it. But once in a while you need to do it to save a lot of time and work.
A reader, January 18, 2002 - 2:11 pm UTC
Sir,
In step No. 13 you have mentioned
"See <Note:62004.1> Removing an Oracle Instance and Database from Windows NT"
How could I find this article ?
January 19, 2002 - 10:00 am UTC
Using </code>
http://metalink.oracle.com/ <code>-- the Oracle Support web site (whence this note originated)
What do I use in place of "Svrmgrl" in 9i ?
Ravi, January 29, 2002 - 2:13 pm UTC
Oracle 9i does not have Svrmgrl ? What can I use in its place ?
Thanks!
January 30, 2002 - 7:09 am UTC
sqlplus replaces svrmgrl in 9i.
RE: What do I use in place of "Svrmgrl" in 9i
A reader, January 30, 2002 - 9:21 am UTC
What do you do in place of reading the Release Notes and documentation? This is only one of the most publicised changes in 9i...
RE: RE: What do I use in place of "Svrmgrl" in 9i
Mark A. Williams, January 30, 2002 - 9:25 am UTC
Re: What do you do in place of reading the Release Notes...
Not only that, but simply putting "svrmgrl 9i" into the AskTom search engine would have easily answered the question as well.
The AskTom search engine must be one of the most under-utilized tools around...
Sorry folks, just getting my feet wet in 9i
Ravi, January 30, 2002 - 9:50 am UTC
.... I will wake up early and work hard now on :)
How can I change the default from ORCL for SQL*Plus
Ravi Kumar, June 22, 2002 - 2:07 pm UTC
Hi,
I installed 9i on my Win2000 machine. Created a database with sid HOME. When I use SQL*Plus to connect database, without the connect string(scott/tiger), it connects. I created one more database OEMREP for Enterprise Manager. After that, when I just give scott/tiger, it is connecting to the new database OEMREP. And I am able to connect to both the databases successfully using @HOME or @OEMREP.
I deleted this new database and when I try to connect with scott/tiger, I am getting "TNS:Protocol error". I checked sqlnet.ora, it is trying to connect to sid ORCL.
====
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\oracle\ora92\bin\sqlplusw.exe)(HOST=MYHOME)(USER=Administrator))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
Time: 22-JUN-2002 13:05:20
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12560
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 2
nt OS err code: 0
===
where is it being set for SQL*Plus executable and how can I change that?
Thanks,
Ravi.
Cloning is Diff for Oracle Applications
Sikandar Hayat Awan, December 09, 2002 - 12:12 pm UTC
The thread is very useful but this procedure is not useful for Oracle Applications.
I want to ask Mr. Tom that is there any site like askTom covering Oracle Applications(OF) other than Metalink?
December 09, 2002 - 1:01 pm UTC
Not that I am aware of, no.
v9i
Anton, December 28, 2002 - 1:40 am UTC
Hi Tom,
Is this applicable to v9iR2??
Tnx
December 28, 2002 - 9:36 am UTC
more or less -- the names of oradim are different (just oradim), you might be using an spfile instead of a pfile but in general, the steps are the same.
goes without saying of course if you do this without a full, tested backup -- you are on your own.
SID and db_name
Steve, March 31, 2003 - 8:51 am UTC
Is it possible to have 2 instances on one server with the same db name but different sid's?
I know it's probably asking for trouble but I'd like to know if it's possible all the same!
March 31, 2003 - 9:25 am UTC
well, an instance does not have a dbname -- a database does -- but I understand..
sure it is.
You can even have 2 instances with the same SID on the same machine that mount two separate databases that have the same dbname's.
DBMS_JOB AND CLONING
Sachin, June 13, 2003 - 10:52 am UTC
8.1.7.4
is there a way to make database "not" to run any of the jobs..while cloning databases...using RMAN backups to clone.
Thanks
June 13, 2003 - 11:09 am UTC
it would not be a "clone" then.
you would have to set job_queue_processes=0 in the init.ora of the cloned database (alter system can do that on the fly)
this is wonderful!!!
anurag, June 14, 2003 - 5:54 am UTC
What a wonderful explanation. Tom, what's a secret of yours answering each question with so much of patience. Is it UR idea to start with asktom.... Can we know its history...
MAXDATAFILES
Abdul Wahab, July 02, 2003 - 9:29 am UTC
Dear Dear Tom,
I need to change the MAXDATAFILE parameter. The database is 7.3.4 and it has hit the maximum and we need to increase that parameter. I need to hcange ONLY this parameter and nothing else. h o w ?
Should i follow the above method for changing the control file? if yes what about that 'reuse' command in control file.
Please reply soon as i am going to work on this database to which 150 users are connected.Can't tolerate down time.
Thanks
July 02, 2003 - 10:39 am UTC
you need to rebuild your controlfiles (sort of oxymoronic -- "i cannot have down time, yet I run unsupported software")
0) BACKUP. make sure you have a backup. make sure you can restore this backup. then....
1)
SVRMGR> connect internal
Connected.
SVRMGR> alter database backup controlfile to trace;
Statement processed.
SVRMGR>
2) cd to your user dump destination directory. find the newest trace file, edit it
3) remove the trace file header, change maxdatafiles, save as "test.sql" or something.
4) shutdown
5) move your old controlfiles elsewhere
6) use test.sql to startup the database, the controlfiles will be recreated for you.
if you skip step 0, you are on your own....
i forgot to mention
A reader, July 02, 2003 - 10:07 am UTC
the operating system is unix tru64
i forgot to mention
abdul wahab, July 02, 2003 - 10:07 am UTC
the operating system is unix tru64
OS server migration
Saradha Bavanandam, July 02, 2003 - 2:32 pm UTC
Tom,
We are planning to replace the existing HP server
(HP V2500) with the new HP superdome server.
To minimize the impact on the production, we are planning
to take the DASD from the old server and plug it into the
new server. I am not an unix admin but this is what the
UNIX admins are planning to do.
There are 10 oracle9i instances running On the old server
and there is a procedural gateway for 4 oracle instances
to communicate with the mainframe CICS transactions.
This is using SNAPlus2 network architecture.
The new server will have a different HOST NAME and
different IP address. My assumption is that, since they
are switching the DASD, the oracle instances will not be
re-created in the new server and they are just brought over
to the new server with all the data.
If I am clear in what I am trying to tell you, what will
be the impact of this new HOST NAME and new IP address
on these Oracle instances and as well as on the
Procedural Gateway in the new server.
The TNSNAMES.ORA and LISTENER.ORA files will be modified on
the new server to reflect theses but other than that what
else is to consider.
Please give your thoughts...
Thanks
Saradha
July 02, 2003 - 2:38 pm UTC
well, they better TEST THIS stuff eh?
they are changing OS's -- at the very least, they will have to relink Oracle.
10 instances on a single server? thats 9 too many.
For the database, the tnsnames/listener files pretty much cover it, as long as the mount points are the same.
It's done
Abdul Wahab, July 05, 2003 - 8:29 am UTC
Dear Tom,
I have done it.I changed the MAXDATAFILE parameter.
Thanks to your documentation and followup which was
very very very (..infinite) helpful for me.
Thanks a lot for being there. (and sorry for oxymoronic remark ;-)
take care
server migration
Saradha Bavanandam, July 08, 2003 - 11:17 am UTC
"well, they better TEST THIS stuff eh?
they are changing OS's -- at the very least, they will have to relink Oracle.10 instances on a single server? thats 9 too many.
For the database, the tnsnames/listener files pretty much cover it, as long as the mount points are the same."
Tom,
We have received our new HP Server and the DASD
migration is going to happen only in September.
What kind of testing that you can suggest before hand
on the new server as far as oracle is concerned, so that
there are no surpises on the migration day.
Other question is:
There are DB LINKS created to these instances from other
external databases and do they need to re-create their DB
LINKS after the migration because the HOST name and IP address are going to be changed now.
Thanks
Saradha
July 08, 2003 - 1:07 pm UTC
you should test your applications functionality and scalabilty. automated testing tools like LoadRunner can be very handy for that.
You can update the tnsnames.ora file to repoint to new ip/hostnames.
ORA-12560 Error when running svrmgrl on WIN NT
A reader, August 30, 2003 - 10:05 am UTC
I have installed Oracle 8i on Windows 2000 without the default database. I want to create database through database configuration assistant or through sqlplus. When I run svrmgrl it gives the error ORA-12560. Is it due to listener.ora, tnsnames.ora problem or any other thing. A good troubleshooting guide is required for this error.
Getting clone of database running on another machine after crash
Jon Waterhouse, August 31, 2003 - 10:07 pm UTC
Hi Tom,
I just had a crash of the NT machine that my test Oracle database was on: unfortunately have a lot of stuff there I don't want to lose. NT is restored on that machine enough to get at all the files, but something damaged is preventing Oracle running (the agent service fails, SQLplus cannot connect (just hangs). Was running in noarchivelog mode.
NT (and presumably the database) shut down fine, just NT failed on the next boot. I have tried copying all of the files in oradata (includes the control files and all of the data files) to another machine with Oracle (9i) installed (same disk and directory). If I follow the script above (with create control files) then I cannot open the database (ORA-01194: file 1 needs more recovery to be consistent).
a "recover using backup controlfile" says there is a change needed for file 1 that it suggests might be in a particular archive file (which of course does not exist).
If I try just a straight startup I get:
ORA-01991: invalid password file
Do either or these approaches have any chance of sucess if I persevere? Would copying the password file (and any other files) bring me joy, or am I doomed?
Thanks,
Jon
September 01, 2003 - 8:12 am UTC
the database did not shutdown clean, else the file would not need recovery
have you tried "recover database"
you can use orapwd to create a new password file.
Changing IP Address of the 9i DB server
Irfan, January 08, 2004 - 4:12 pm UTC
Hi Tom,
I have to change the IP address of one of my 9i db server. Is it straight forward or do I have to follow some careful steps??
January 08, 2004 - 8:17 pm UTC
you should just be able to "do it" unless you've used IP addresses in any configuration files.
Unless you put in fixed IP's, they'll have hostnames and you are not changing that so you should be AOK.
tnsnames.ora (clients and servers)
listener.ora (server)
init$ORACLE_SID.ora (for service registration) (or the spfile)
are the places to look
great article
Vijay, February 09, 2005 - 5:27 am UTC
Hi Tom,
good day to you, I would like some help on your comment "You can even have 2 instances with the same SID on the same machine that mount two separate databases that have the same dbname's." this may sound weird but is it possible in this case to have both the database up and running, how would the memory allocation be done in case it is possible.
Thanks as always for all your help.
February 09, 2005 - 2:18 pm UTC
they would have different oracle homes
the oracle_home+oracle_sid is used to generate a key to the shared memory segment, so they would point to different SGA's just fine.
thanks a lot for your reply
Vijay, February 10, 2005 - 12:50 am UTC
Hi Tom,
good day to you, thanks a lot for your reply, if I get it correctly does this means that one can't have databases with same name and sid under one oracle_home, I should test this but presently I don't have a pc with me so just asking you.
Best Regards,
Vijay
February 10, 2005 - 1:14 am UTC
correct, same sid under same oracle home would not work at the same time (they would want to use the same shared memory segment)
problem in 9i
reader, May 27, 2005 - 11:15 am UTC
Hi Tom,
I followed your instructions but I am stuck at at step 10, 9i onwards svrmgrl is not supported how do I connect to the database I know sqlplus has replaced svrmgrl but how should i get connected to execute the chname.sql, please help.
Kind regards,
your fan.
May 27, 2005 - 12:35 pm UTC
sqlplus
thanks but still need help
your fan, May 27, 2005 - 1:10 pm UTC
Hi Tom,
I tried getting connected with sqlplus using options as
sqlplus /@test (i.e. db name)
sqlplus sys/password of old database@test as sysdba
but nothing worked how can I get connected to the database using sqlplus I am using Oracle 9i release 2, on Windows 2000 and not able to go ahead of step 10 as mentioned in your article, please help and sorry if I was not being clear enough in first place.
May 27, 2005 - 1:18 pm UTC
sqlplus "/ as sysdba"
alt, July 25, 2005 - 9:51 am UTC
While creating database in oracle 9i using WINDOWS NT , After creating parameter file connecting to the idle instance(CONN SYS/AS SYSDBA) we are getting the following error
ORA-12560: TNS:protocol adapter error
How to Resolve this
July 25, 2005 - 11:09 am UTC
sounds like the service is not running. you did run oradim to create a service and then started it (part of windows requirements here)
A reader, July 25, 2005 - 10:50 am UTC
Hi Tom,
I have a question about renaming SIDs. Our situation is like this: We have a database server with two separate RAID arrays. Our primary database is hosted on one of these arrays of disks. We have the other array as a backup. We also have a backup database running on a separate server. Now for the second RAID array, I want to know what will be the best way to utilize it and I want to know if the following is possible. Consider database with sid=DB1 on RAID1 and sid=DB2 on RAID2. If there is a problem with RAID1 and if DB2 and DB1 are in sync using some procedure which runs every 2 hrs or so, is it possible that I can stop OracleServiceDB1 and rename DB2 to DB1 and continue operations on the database without having to do a complete restore?
Thanks.
July 25, 2005 - 11:17 am UTC
I'm not sure what raid levels have to do with anything at all? raid is totally transparent to us sitting on top of a file system.
But why would you need to rename a sid? You just need to have database 2 register itself as the same named service. clients don't use sids (they can, but don't have and shuold not)
A reader, July 25, 2005 - 11:22 am UTC
Hi Tom,
Can you explain me how to register database 2 as same named service?
Thanks.
July 25, 2005 - 12:08 pm UTC
you don't want to do that simultaneously -- that would load balance between them and you want to do this as a failover.
when you start up db2, have it register dynamically as that service.
A reader, July 25, 2005 - 1:14 pm UTC
From my understanding I have listed the steps to be followed below. Can you review and comment on it please? Thanks a lot for your time.
1. Have database 1 running as always. Database 1 will be setup with datafiles on RAID1. SID=TEST
2. The same set of datafiles will be copied over to RAID2.
3. When there is a failure in RAID1, then dynamically register db2 as the same service SID=TEST (ie., using oradim, is that right?) and start using database 2 with same sid as database 1.
I have another question for you. How do I keep db2 in sync with db1 so that I can start using db2 in a failover scenario without any issues.
Thanks.
July 25, 2005 - 1:35 pm UTC
raid levels, smaid levels, it is just disk... they are just disks to us.
are you looking for a disaster recovery solution??? I'm not 100% sure where you are going.
If you want disaster recovery, see:
</code>
http://docs.oracle.com/docs/cd/B10501_01/server.920/a96653/toc.htm <code>
(no, oradim would not come into the picture, I was talking about dynamic registration of the DATABASE to a listener with a service name, but if you need disaster recovery, you want to read about data guard)
A reader, July 25, 2005 - 1:46 pm UTC
I need your help to understand what you mean by dynamically registering a database to a listener with a service name.
Thanks.
July 25, 2005 - 2:25 pm UTC
Great job, shouldn't be necessary
Andy, December 17, 2005 - 4:49 pm UTC
Great instructions on how to move a database!
However, you would think that there would be a button that one could press while in an admin tool that would do all of this for you and create a single file that one could move to another machine and press another button to restore it. (Allowing you to move the database to a different drive or directory if you choose).
It is the fact that clear, well written thirteen step instructions like these are considered acceptable that has allow Microsoft with inferior products, with easier interfaces, to conquer the world.
Please, get a clue and automate this process, if only for databases less then 4GB in size!
Andy.
December 18, 2005 - 10:09 am UTC
there is, this is how to do it "yourself"
moving to a different drive/disk - I would never do all of this, that is just move the files, alter database rename the files.
and if you wanted an "easy way" to move the database, the rman duplicate command might be of interest.
this is how to "rename" a database, a questionable thing to even want to do - but people get hung up on it - really wanting to rename something that isn't really exposed to anyone else.
Changing SID of database
Rahul, June 01, 2006 - 3:38 pm UTC
Tom,
What alterations will be in the process of SID renaming when you use 10G and use spfile.
If you could detail that or direct somewhere, would be great.
June 01, 2006 - 4:10 pm UTC
pretty much the same.
rename the spfile instead of the init.ora file.
you might have issues if you put the sid name in the spfile itself. (parameters can be
sid.parameter = value
*.parameter = value
if you have sid.parameter, you'll need to reset them)
Oracle Not available
Swaminathan, July 19, 2006 - 2:49 am UTC
when i am trying to login to DB (Oracle 9.2.0.5) on windows NT server, i am getting the following error message:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist:
Its been a long time since i have logged into this db and this is a test db
I would like to know, what are all the possible solution for the above scenario.
July 19, 2006 - 9:06 am UTC
well, it sure looks like the database isn't started. start it.
Oracle not available
Swaminathan, July 20, 2006 - 2:03 am UTC
Well, i can recognise that the DB is not started, but the problem here is that i am not able to login to sql promt neither server manager.....when i do so i am getting the message 'oracle not avialable'
Now i need to know what are the required steps to be taken to start the DB???
July 22, 2006 - 4:33 pm UTC
make sure the service is started (the oracle services)
and if the database wasn't installed to "autostart", you would have to:
sqlplus "/ as sysdba"
startup
to start it.
Different banaviour between binary and traced control file backup
A reader, October 25, 2006 - 4:02 am UTC
HI, Tom,
I am confused by the following two DB recovery tests:
In both tests, I prepare the db as:
SQL> alter database backup controlfile to trace as 'c:\tt.sql' reuse;
Database altered.
SQL> alter database backup controlfile to 'c:\cf.bak' reuse;
Database altered.
SQL> alter tablespace my_ts add datafile 'C:\ORACLE\ORADATA\MYDB\MYTS2.DBF' size 128k;
Tablespace altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
Delete all the control files and the newly added datafile MYTS2.DBF.
Test 1: Recover DB using binary control file backup "cf.bak"
I copy cf.bak to the original control file location and rename as indicated in init.ora.
and run the following:
SQL> startup pfile='C:\oracle\admin\MYDB\pfile\init.ora' mount
ORACLE instance started.
Total System Global Area 135339940 bytes
Fixed Size 454564 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
SQL> recover database using backup controlfile
ORA-00279: change 1092287 generated at 10/25/2006 10:19:16 needed for thread 1
ORA-00289: suggestion : C:\TEMP\MYDB_5.DBF
ORA-00280: change 1092287 for thread 1 is in sequence #5
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
C:\oracle\oradata\MYDB\redo02.log
ORA-00283: recovery session canceled due to errors
ORA-01244: unnamed datafile(s) added to controlfile by media recovery
ORA-01110: data file 6: 'C:\ORACLE\ORADATA\MYDB\MYTS2.DBF'
ORA-01112: media recovery not started
SQL> alter database create datafile 6 as 'C:\ORACLE\ORADATA\MYDB\MYTS2.DBF';
Database altered.
SQL> recover database using backup controlfile
ORA-00279: change 1092393 generated at 10/25/2006 14:49:42 needed for thread 1
ORA-00289: suggestion : C:\TEMP\MYDB_5.DBF
ORA-00280: change 1092393 for thread 1 is in sequence #5
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
C:\oracle\oradata\MYDB\redo02.log
Log applied.
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
Please note that I have also restored the newly added datafile during the recovery process.
Test 2: Recover DB using traced output to re-create control file:
SQL> startup pfile='C:\oracle\admin\MYDB\pfile\init.ora' nomount
ORACLE instance started.
Total System Global Area 135339940 bytes
Fixed Size 454564 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
SQL> CREATE CONTROLFILE REUSE DATABASE "MYDB" NORESETLOGS ARCHIVELOG
2 MAXLOGFILES 32
3 MAXLOGMEMBERS 2
4 MAXDATAFILES 100
5 MAXINSTANCES 16
6 MAXLOGHISTORY 1815
7 LOGFILE
8 GROUP 1 'C:\ORACLE\ORADATA\MYDB\REDO01.LOG' SIZE 10M,
9 GROUP 2 'C:\ORACLE\ORADATA\MYDB\REDO02.LOG' SIZE 10M,
10 GROUP 3 'C:\ORACLE\ORADATA\MYDB\REDO03.LOG' SIZE 10M
11 DATAFILE
12 'C:\ORACLE\ORADATA\MYDB\SYSTEM01.DBF',
13 'C:\ORACLE\ORADATA\MYDB\UNDOTBS01.DBF',
14 'C:\ORACLE\ORADATA\MYDB\USERS_01.DBF',
15 'C:\ORACLE\ORADATA\MYDB\MYTS.DBF',
16 'C:\ORACLE\ORADATA\MYDB\TEST.DBF'
17 CHARACTER SET US7ASCII;
Control file created.
SQL> recover database using backup controlfile
ORA-00279: change 1092488 generated at 10/25/2006 15:19:49 needed for thread 1
ORA-00289: suggestion : C:\TEMP\MYDB_5.DBF
ORA-00280: change 1092488 for thread 1 is in sequence #5
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
C:\oracle\oradata\MYDB\redo02.log
Log applied.
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
Please note that my newly added datafile is gone.
My question is, why the second test omits the new datafile? Is there any way for the second test to perform correctly to recover the newly added datafile?
Thank you
error while creating database manually in 9i
priyanka, May 14, 2007 - 1:45 am UTC
hi tom,
i m creating a database manually in 9i and after creating password file i executed oradim to start services,fairly i did it successfully but still after being connected to an idle instance i m unable to start database in nomount state.i performed the following:
SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup nomount
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'D:\ORACLE\ORA92\DATABASE\INITDB6.ORA'
SQL>
tell me what i m missing.
regards
priyanka
May 14, 2007 - 2:02 pm UTC
you seem to be missing the file initdb6.ora?
change database name
mohammad, August 07, 2007 - 3:06 am UTC
How can i change the database name ?
Also for Oracle 10.x or 11.x (SID CHange?)
Stefan, July 16, 2009 - 9:30 am UTC
Hi Tom,
following long time now your answers. Can I use this "CHANGE SID" guide also for DB 10 and 11?
July 16, 2009 - 11:32 am UTC
what platform?