When i use select instance_name from v$instance - i have the instance name in lower case but i want it change to uppercase.
I have followed the instructions posted in several threads on simillar issue and i still cant succeed. i can see the change when i do show parameter instance name (display's upper case) but no luck when i do check from v$instance.
When I try changing the instance_name to "TEST"(a new name) (to crosscheck if it is really to do with the uppercase/lowercase or it isn't changing at all) and edit the pfile with the instance name as TEST and start the DB, It still shows the instance name as f(oldinstance name) (not changing).
Could somebody help me here?
996520 wrote:You are perhaps editing a pfile, but starting the instance with an spfile. Try this:
Just to inform- Even if i set ORACLE_SID=test or TEST i can login to the database using sqlplus. but when i fire select instance name from v$instance. It displays in lower case. I need it in upper case.
alter system set instance_name=UPPERCASE scope=spfile; startup force;
996520 wrote:Well, I'm sorry my time wasn't worth a "thank you". If you want more advice, I think you had better prove what you describe. These queries would help, after a re-start:
alter system set instance_name = '<uppercase>' scope=spfile;
This was already attempted and the desired result is seen in show parameter instance_name but not in select instance_name from v$instance.
select instance_name from v$instance; select value from v$parameter where name='instance_name'; select value from v$spparameter where name='instance_name'; select value from v$parameter where name='spfile';