+ Reply to Thread
Page 2 of 4 FirstFirst 1 2 3 4 LastLast
Results 11 to 20 of 35
  1. 09-26-2001 08:46 AM #11
    mageri
    mageri is offline Junior Member
    Join Date
    Sep 2001
    Location
    SWEDEN
    Posts
    70
    Which version of SQLnet are you using?
    Maybe SERVICE_NAME should be replaced with SID in the CONNECT_DATA string.
    Reply With Quote Reply With Quote
  2. 09-26-2001 08:47 AM #12
    gooftrap
    gooftrap is offline Junior Member
    Join Date
    Aug 2001
    Location
    INDIA
    Posts
    28
    already did that. The same thing's working at the server the same way and the same settings. Just not on the client. Although it has the same settings too

    Mohit.
    It's easy as long as you are on the RIGHT Track of MIND...
    Reply With Quote Reply With Quote
  3. 09-26-2001 08:49 AM #13
    gooftrap
    gooftrap is offline Junior Member
    Join Date
    Aug 2001
    Location
    INDIA
    Posts
    28
    tried that too. The sid without the global name and the global name. Di not give any different result.

    Mohit.
    It's easy as long as you are on the RIGHT Track of MIND...
    Reply With Quote Reply With Quote
  4. 09-26-2001 08:51 AM #14
    truma1
    truma1 is offline Junior Member
    Join Date
    May 2001
    Location
    Cape Town, South Africa
    Posts
    52
    You didnt happen to call your server the same name as your sid or instance??
    Reply With Quote Reply With Quote
  5. 09-26-2001 08:53 AM #15
    gooftrap
    gooftrap is offline Junior Member
    Join Date
    Aug 2001
    Location
    INDIA
    Posts
    28
    nope. The machine name is like server and the sid name is like orcl and the global name is like orcl.domain

    Mohit.
    It's easy as long as you are on the RIGHT Track of MIND...
    Reply With Quote Reply With Quote
  6. 09-26-2001 08:55 AM #16
    mageri
    mageri is offline Junior Member
    Join Date
    Sep 2001
    Location
    SWEDEN
    Posts
    70
    I suppose that you use windows clients. Take a look at the TNS_ADMIN parameter in the registry. Is that the correct path to your TNSNAMES.ORA? Maybe you have more than one ORACLE_HOMES?
    Reply With Quote Reply With Quote
  7. 09-26-2001 08:56 AM #17
    truma1
    truma1 is offline Junior Member
    Join Date
    May 2001
    Location
    Cape Town, South Africa
    Posts
    52
    What do the error logs say ../network/logs/listner.log
    Reply With Quote Reply With Quote
  8. 09-26-2001 08:58 AM #18
    gooftrap
    gooftrap is offline Junior Member
    Join Date
    Aug 2001
    Location
    INDIA
    Posts
    28
    It is the correct path and i only have one oracle home

    Mohit.
    It's easy as long as you are on the RIGHT Track of MIND...
    Reply With Quote Reply With Quote
  9. 09-26-2001 09:02 AM #19
    gooftrap
    gooftrap is offline Junior Member
    Join Date
    Aug 2001
    Location
    INDIA
    Posts
    28
    it gives a description of establish statements with return codes 0 and the name + path of the calling program on the remote machine.

    Mohit.
    It's easy as long as you are on the RIGHT Track of MIND...
    Reply With Quote Reply With Quote
  10. 09-26-2001 09:05 AM #20
    truma1
    truma1 is offline Junior Member
    Join Date
    May 2001
    Location
    Cape Town, South Africa
    Posts
    52
    what is the status of your listner LSNRCTL> status and does your listner support services
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width