Database Administration (MOSC)

MOSC Banner

confused about database name

edited Mar 14, 2011 10:36AM in Database Administration (MOSC) 2 commentsAnswered ✓
 Hi Everyone,
I am confused about how the following parameters working together in a database:

db_name=oracle_sid
domain_name=domain.org
global_name=false
service_names=sid, sid.domain.org

tnsnames.ora sid=(sid=oracle_sid)...
listener.ora only used oracle_sid
sqlnet.ora  no default_domain set.

When I restart listener, I see oracle_sid is registered statically with the listener, having status=UNKNOWN.
oracle_sid.domainorg is dynamically registered, status=ready.

After I I changed service_names=oracle_sid from the database and bounced the database and restarted listener, I still see oracle_sid.domain.org status ready in instener.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center