dcsimg
Results 1 to 3 of 3

Thread: [RESOLVED] ORA-12154 TNS could not resolve name -Very Strange...

  1. #1

    Thread Starter
    Member
    Join Date
    Jan 2005
    Posts
    57

    Resolved [RESOLVED] ORA-12154 TNS could not resolve name -Very Strange...

    Friends,

    I have installed developer 6,oracle 9i database and 10g database in my local pc.
    I have developed an application which will connect our server which is having oracle 9i database.

    first i installed developer 6 in my pc and i run my vb application which is connecting our 9i db...and its working fine.
    the tnsnames.ora for developer 6 is C:\ORANT\NET80\ADMIN\tnsnames.ora

    after that i installed oracle 9i in c:\ora9i.
    the tnsnames.ora for oracle9i is in C:\ora9i\network\admin\tnsnames.ora

    then i tried to run my vb application...i received an ORA-12154 error.

    my question is after installing 9i why my vb application is checking the 9i tnsnames.ora why its not going to c:\orant's tnsnames.ora

    but.....if i insert the orant's tnsnames.ora in 9i's tnsnames.ora then its working fine.......i don't want to insert the orant's entries in 9i tnsnames.ora.....

    so how can i point out my vb applications connection string to orant's tnsnames.ora

    Thanks & Regards
    Sathyguy

  2. #2
    Frenzied Member moinkhan's Avatar
    Join Date
    Jun 2000
    Location
    Karachi, Pakistan
    Posts
    2,011

    Re: ORA-12154 TNS could not resolve name -Very Strange...

    Quote Originally Posted by sathyguy
    Friends,

    I have installed developer 6,oracle 9i database and 10g database in my local pc.
    I have developed an application which will connect our server which is having oracle 9i database.

    first i installed developer 6 in my pc and i run my vb application which is connecting our 9i db...and its working fine.
    the tnsnames.ora for developer 6 is C:\ORANT\NET80\ADMIN\tnsnames.ora

    after that i installed oracle 9i in c:\ora9i.
    the tnsnames.ora for oracle9i is in C:\ora9i\network\admin\tnsnames.ora

    then i tried to run my vb application...i received an ORA-12154 error.

    my question is after installing 9i why my vb application is checking the 9i tnsnames.ora why its not going to c:\orant's tnsnames.ora

    but.....if i insert the orant's tnsnames.ora in 9i's tnsnames.ora then its working fine.......i don't want to insert the orant's entries in 9i tnsnames.ora.....

    so how can i point out my vb applications connection string to orant's tnsnames.ora

    Thanks & Regards
    Sathyguy
    c:\ora9i seems to be your default home... you can change your default home from home selector tool which should be present in your ora9i program group

    or...
    you can define a system level TNS_ADMIN variable with a value c:\orant\net80\admin

    Your problem will be solved

  3. #3

    Thread Starter
    Member
    Join Date
    Jan 2005
    Posts
    57

    Re: ORA-12154 TNS could not resolve name -Very Strange...

    very good.....
    thanks for your help....
    its working fine....

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width