This content has been marked as final. Show 11 replies
It's not enough to change Instance Name (SID) by simply modifying that parameter. There's a procedure to follow, check metalink doc
How to Determine and Rename/Change DB_NAME or ORACLE_SID/Instance Name
Doc ID: Note:15390.1
It's basically the ORACLE_SID environment variable you use to start database determine the current instance name.
2 You did bounce the instance after the chance?Hi, I understand where you coming from but for the sake of enlightment (btw I couldn t recreate this problem!!!) - when I do that I do become always the actual info (with me, testdb instead of testdb01) so I am guessing that he must have bounced the db;
instance_name is a static parameter.
Also : show parameter will always use your session
parameters. It will not read the pfile.
then again if he did then he shouldn t be having to see the test name on v$instance ?!??!?! whatelse, do you think might have happened ?
(I am just curious, because I couldn t "replay" that error on my testsystem!)
if if show parameter command is not reading pfile from where it gets the session parameters?it reads from the pfile which is a init.ora file but it is not actually reading from the parameter file rather it gives the settings that are set by the init.ora during startup and also the dynamic values ..I am not 100% sure here
But for your issue did you check my earlier posts
stop the DB change the instance in the pfile and start the DB
SQL>show parameter instance_name
you will see the latest one you have changed but when you query from select instance_name from v$instance it is going to show you instance name created during the DB creation
clear or not?
By Tom Kyte
It is compiled into Oracle binary itself during the installation time .It contains set of variables that points to other components of SGA and varibales that contains values for various params
We cannot have any control on this param and is OS dependent
Variable size= shared pool+largepoo+javapool
Message was edited by: