Home » RDBMS Server » Networking and Gateways » TNSNAMES (Oracle 10.2.0.2)
TNSNAMES [message #574872] Wed, 16 January 2013 08:25 Go to next message
pointers
Messages: 451
Registered: May 2008
Senior Member
Hi,

I have observed that I am unable to connect database when I change the TNS names alias name.
I am able to connect to the database if I give the tnsnames alias name as BB_BB_SSL.WORLD, but if I change the alias name to someother name e.g bb I am not able to connect

I would like to know if there is something restricting it.

--working
BB_BB2_SSL.WORLD= 
  (DESCRIPTION= 
    (ADDRESS= 
      (COMMUNITY=TCP.WORLD) 
      (PROTOCOL=TCPS) 
      (HOST=xxxxx) 
      (PORT=xxxxx) 
    ) 
    (CONNECT_DATA= 
      (SERVER=dedicated) 
      (SERVICE_NAME=xxxx) 
      (SID=xxxx) 
    ) 
  ) 



--Not working
BB= 
  (DESCRIPTION= 
    (ADDRESS= 
      (COMMUNITY=TCP.WORLD) 
      (PROTOCOL=TCPS) 
      (HOST=xxxxx) 
      (PORT=xxxxx) 
    ) 
    (CONNECT_DATA= 
      (SERVER=dedicated) 
      (SERVICE_NAME=xxxx) 
      (SID=xxxx) 
    ) 


Thank you very much in advance.

Regards,
Pointers

[Updated on: Wed, 16 January 2013 08:25]

Report message to a moderator

Re: TNSNAMES [message #574875 is a reply to message #574872] Wed, 16 January 2013 08:30 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
show parameter global_names

and then look at the documentation for global_names

[Updated on: Wed, 16 January 2013 08:30]

Report message to a moderator

Re: TNSNAMES [message #574877 is a reply to message #574872] Wed, 16 January 2013 08:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How is this a SQL or PL/SQL question?
With almost 300 posts you still don't know where to correctly post?
I think you should leave the computer world.

Regards
Michel
Re: TNSNAMES [message #574887 is a reply to message #574877] Wed, 16 January 2013 09:15 Go to previous messageGo to next message
pointers
Messages: 451
Registered: May 2008
Senior Member
I checked the global_names parameter its value is false, I checked in the documentation it is to do with db links
Re: TNSNAMES [message #574888 is a reply to message #574887] Wed, 16 January 2013 09:23 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
since you decided to not show us exactly what you are doing (& how Oracle responds),
it is not possible to guess what you are doing wrong.
Re: TNSNAMES [message #574891 is a reply to message #574888] Wed, 16 January 2013 09:41 Go to previous messageGo to next message
pointers
Messages: 451
Registered: May 2008
Senior Member
I have changed the alias name as mentioned above and tried to connect from toad and it shows me the error that
"ora-12154: TNS:could not resolve the connect identifier specified"

Regards,
Pointers
Re: TNSNAMES [message #574892 is a reply to message #574891] Wed, 16 January 2013 09:43 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Problem Exists Between Keyboard And Chair
when you use wrong alias, then error gets thrown.
Re: TNSNAMES [message #574893 is a reply to message #574892] Wed, 16 January 2013 09:51 Go to previous messageGo to next message
pointers
Messages: 451
Registered: May 2008
Senior Member
I think i have provided everthing below.

step1:
changed the tnsnames.ora file to below

BB= 
  (DESCRIPTION= 
    (ADDRESS= 
      (COMMUNITY=TCP.WORLD) 
      (PROTOCOL=TCPS) 
      (HOST=xxxxx) 
      (PORT=xxxxx) 
    ) 
    (CONNECT_DATA= 
      (SERVER=dedicated) 
      (SERVICE_NAME=xxxx) 
      (SID=xxxx) 
    ) 


step2: connected to toad and provided usernmae and password and provided database name as 'BB'
and the output is error i.e. ora-12154: TNS:could not resolve the connect identifier specified


step3: changed the tnsnames alias to BB_BB2_SSL.WORLD from BB
and the output is that it is connected to database

[Updated on: Wed, 16 January 2013 09:57]

Report message to a moderator

Re: TNSNAMES [message #574894 is a reply to message #574893] Wed, 16 January 2013 09:59 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post content of sqlnet.ora file
Re: TNSNAMES [message #574895 is a reply to message #574893] Wed, 16 January 2013 09:59 Go to previous messageGo to next message
pointers
Messages: 451
Registered: May 2008
Senior Member
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\bb>sqlplus external@bb

SQL*Plus: Release 11.2.0.2.0 Production on Wed Jan 16 16:57:40 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Re: TNSNAMES [message #574896 is a reply to message #574894] Wed, 16 January 2013 10:02 Go to previous messageGo to next message
pointers
Messages: 451
Registered: May 2008
Senior Member
I have the below content for sqlnet.ora

# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)
Re: TNSNAMES [message #574897 is a reply to message #574896] Wed, 16 January 2013 10:07 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
how many different ORACLE_HOME directories exist on this system?
Previous Topic: ORA-12535: TNS: operation timed out
Next Topic: ERROR: ORA-12154: TNS:could not resolve the connect identifier specified
Goto Forum:
  


Current Time: Thu Mar 28 06:37:40 CDT 2024