Oracle Database Discussions

Dear All,

On my RAC Database 11gR2 on Linux.

When i query:

select * from global_name; returns
RACDB.REGRESS.RDBMS.DEV.US.ORACLE.COM

I run the following queries to change this global name to simple RACDB

update global_name set global_name ='RACDB';
ALTER DATABASE RENAME GLOBAL_NAME TO RACDB;

Now when i query
select * from global_name; returns
RACDB

When i start my listener it says:
Service "racdb.REGRESS.RDBMS.DEV.US.ORACLE.COM" has 1 instance(s).

And when i connect my database using tools like SQL DEVELOPER I have to provide complete RACDB.REGRESS.RDBMS.DEV.US.ORACLE.COM in the service name parameter.

While i need to connect only using RACDB

I have configure REGRESS.RDBMS.DEV.US.ORACLE.COM in any of my network file on both nodes like tnsnames.ora sqlnet.ora or lietener.ora

Kindly help to resolve this problem.

Regards, Imran