Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

v$parameter parameters case sensitivity

DBA092012Aug 3 2017 — edited Aug 3 2017

Hello everybody.

Let's say we want to move from oracle 9.2 residing on windows to oracle 11.2 residing on linux.

Let's examine the output from the query below

select name, value from v$parameter where name like '%name%' and value is not null;

instance_name    Asomp

service_names    Asomp

db_name    Asomp

We see that all provided parameters are not in the one case.

So which value should be put into the database name field during DBCA session maintain the parameter in the right way?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 31 2017
Added on Aug 3 2017
3 comments
433 views