Help Please ! Regarding configuring Oracle8i client
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Help Please ! Regarding configuring Oracle8i client

  1. #1
    Join Date
    Oct 2002
    Posts
    21
    Hi all,
    I have installed Oracle8i Client on my machine.I am very new to this field.I have started configuring my oracle client. I opened up the Net 8 Assistant. I got a UI in which i clicked on the Service Name and then from Edit menu I choose create. It then prompted me for Net service Name. I enterred "Client". then I selected the Protocol TCP/IP, entered the host Name of the computer where database is stored. Port 1521.Then I selected the SID and entered APPS. I then tested the connection giving the correct username and password.It said connection test successed.
    But when I open SQL Plus and try to connect with the same username & password and service name "client" it gives the error . Please let me know what the Problem is ...or do I need to configute any other thing..

    thanking you,

  2. #2
    Join Date
    Oct 2002
    Posts
    21
    when I do tnsping jaya I get the error message :

    TNS-03505 :Failed to resolve name

  3. #3
    Join Date
    Sep 2001
    Location
    Jurong East/Singapore
    Posts
    70

    Thumbs up

    hi..
    did u said FINISH at the end of ur client configuration..bcz it makes the data to be stored in $oracle-home/network/admin/tnsnames.ora file in ur oracle home dir.
    do check that file for ur JEYA alias entry...


    peri sekar

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