init.ora Parameter
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: init.ora Parameter

  1. #1
    Join Date
    Mar 2002
    Posts
    25

    Question

    Hi All

    I am trying to create adatabase link, and the link is create successfully. the problem is when I try to connect to the other database using the link I get a ORA-12154: TNS:could not resolve service name. I know there is a parameter in the init.ora which needs to be set. Which one is is and what is the Value.

    Thanx.

  2. #2
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Hi,
    check if the service name you put in the USING clause exists in tnsnames.ora file on the server you're connected to.

  3. #3
    Join Date
    Jul 2000
    Posts
    37
    As far as init.ora params are concerned, I think you want global_names set to false.

    cheers

    chris.

  4. #4
    Join Date
    Mar 2002
    Posts
    25
    Thanx a 1,000,000 Guys ! :0

    You are 100% right chris . it's the global_names parameter !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width