DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: net 8 assitant

Hybrid View

  1. #1
    Join Date
    Jun 2000
    Location
    dumfries,va,usa
    Posts
    227
    Hi,
    I'm trying to connect to an oracle8 database using oracle 8i net 8 assitant but I get an error message saying that the service name mentioned in the connect descriptor is invalid. Can you help me resolve this problem.

    Thanks.
    leonard905
    leonard905@yahoo.com

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    cut and paste the error message you are getting with your tnsnames.ora
    Reddy,Sam

  3. #3
    Join Date
    Jun 2000
    Location
    dumfries,va,usa
    Posts
    227
    This is it. Thanks.
    ++++++++++++++++++++++++++++++++++++++++
    Attempting to connect using userid: system
    The test did not succeed.
    ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

    There may be an error in the fields entered,
    or the server may not be ready for a connection.
    leonard905
    leonard905@yahoo.com

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    I meant say what you have typed at SQLPLUS prompt with error message. I have got error message but, I dunno what you have typed in at the prompt.

    I wanna have a look at the tnsnames.ora contents. could you post that please. Probebly with this information I would help you to resolve your problem.


    Reddy,Sam

  5. #5
    Join Date
    Jun 2000
    Location
    dumfries,va,usa
    Posts
    227
    I'm using Net 8 not line command. Here is this Tnsnames.ora file
    ++++++++++++++++++++++++++++++++++++++++


    # TNSNAMES.ORA Network Configuration File: C:\orant8i\NETWORK\ADMIN\tnsnames.ora
    # Generated by Oracle configuration tools.

    BRDSLT =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.0.71)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = brdslt)
    )
    )

    LCOKER =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = lcoker)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = leo)
    )
    )

    BRDNEW =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.0.71)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = ff201)
    )
    )
    leonard905
    leonard905@yahoo.com

  6. #6
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Take Programs --> Net8 Configuration Assistant --> add --> local net8 service name configuration --> name of the service(say xyz.world) --> port #(1521,default) --> test --> finish

    Thats will reflect in your tnsnames.ora

    You can use that service name(xyz) which you hjave created thru net8 configuration assistant as connect_string for database connection.

    Example: sqlplus system/manager@xyz

    I don't know what you are trying to do, this is what you supposed to do to create a service name.
    Reddy,Sam

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