connect to sqlplus from non default ora home
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: connect to sqlplus from non default ora home

  1. #1
    Join Date
    Nov 2000
    Posts
    416

    Question

    I have two Oracle home in my PC, 8.0.5 and 8.1.7 , connection to Databases from 8.0.5 sqlplus is fine.
    I have copied the TNSNAMES.ORA from 8.0.5 network folder to 8.1.7 network\admin folder but still when I am trying to connect to Database by sqlplus version 8.1.7 it returns erro : Could not resolve servica name. I try change Oracle home with home selector also. Didn't help.

    Can you elaborate how can I resolve this issue?

    Thanks
    An ounce of prevention is worth a pound of cure

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    What I understand is there is two versions of networking and some conflicts with networking. Make sure you have only one version of networking enabled. Stop all the listener services and start only 817 listener. That should take care of your proble. If its unix make sure you TNS_ADMIN variable set to /817O_H/network/admin.

    Reddy,Sam

  3. #3
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    1.
    check sqlnet.ora files and made the the same

    NAMES.DEFAULT_DOMAIN = ......
    NAMES.DIRECTORY_PATH= (TNSNAMES)
    or
    remove NAMES.DEFAULT_DOMAIN from both files

    (8.0.5 and 8.1.7 has difference in using oracle domain names)

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