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

Thread: connecting problem, URGENT

  1. #1
    Join Date
    Oct 2000
    Posts
    211
    Hi guys,
    I just reloaded my machine with Windows NT, and created the tnsnames.ora file. When I try to login using the username/password@service_name, the sql-plus does not respond and i need to use the task manager to 'end task'.
    However, when i use username/password@host_name, it connects just fine to one of the databases which is on that server(may be termed as a default service).
    What is wrong and what is needed to be done to correct this?
    Thanks
    manjunath

  2. #2
    Join Date
    Oct 2000
    Posts
    211
    Sorry,
    there was some problem with Net* Configuration.
    The problem was solved after I reconfigured the same.
    manjunath

  3. #3
    Join Date
    Sep 2000
    Posts
    56
    Did u add all the database names in TNSNAMES.ora file.if not add that
    databasename.world.com =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = databasename)
    )
    )
    databasename2.world.com =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = databasename2)
    )
    )
    Also chek ur path.Go to dos prompt & type path & see what is the path set to



  4. #4
    Join Date
    Oct 2000
    Posts
    33
    Can u tnsping the database ?

  5. #5
    Join Date
    Sep 2000
    Posts
    17
    Hi manjunathk,

    What is the version of Oracle u r using? If it is 8i what is the global database name? Place the globaldatabase name as service name. (ex: orcl.domain). It should work now.


    nag

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