connect to remote database via sqlnet
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: connect to remote database via sqlnet

  1. #1
    Join Date
    Jun 2000
    Location
    dumfries,va,usa
    Posts
    227
    Hi all,

    How can I connect to a remote database using sqlnet.ora. I modify the contents of the sqlnet.ora file and made several attempts to connect via sqlplus but unsuccessful. Got a ora-12154 error message. Is anything wrong with my sqlnet.ora configuration? I also have a local db on my machine. Below is the contents of the sqlnet.ora file:

    AUTOMATIC_IPC = OFF
    SQLNET.EXPIRE_TIME = 2147483647
    trace_level_client = off
    trace_file_client = sqlnet
    log_file_client = sqlnet
    names.default_domain = world
    name.default_zone = world
    NAMES.DIRECTORY_PATH= (ONAMES)
    NAMES.PREFERRED_SERVERS = (ADDRESS_LIST =
    (ADDRESS=(PROTOCOL=TCP)(HOST=server1)(PORT=1575))
    (ADDRESS=(PROTOCOL=TCP)(HOST=server0)(PORT=1575)))


    #NAMES.DEFAULT_DOMAIN = domain.com

    #SQLNET.AUTHENTICATION_SERVICES= (NTS)

    #SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf
    leonard905
    leonard905@yahoo.com

  2. #2
    Join Date
    Sep 2002
    Posts
    5
    It is possible to replay, if you also post tnsnames.ora and listener.ora file.

    Regards,
    Rems, DBA from Latvia

  3. #3
    Join Date
    Jun 2000
    Location
    dumfries,va,usa
    Posts
    227
    tnsnames.ora:

    DEV=
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = p608469)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = dev)
    )
    )

    listener.ora:

    LISTENER =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = P608469)(PORT = 1521))
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = dev)
    (ORACLE_HOME = c:\)
    (SID_NAME = dev)
    )
    )
    leonard905
    leonard905@yahoo.com

  4. #4
    Join Date
    Jun 2000
    Location
    dumfries,va,usa
    Posts
    227
    Any help? I have listed the contents of tnsnames.ora and listener.ora files above.

    any suggestions is helpful
    leonard905
    leonard905@yahoo.com

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by leonard905
    Hi all,

    How can I connect to a remote database using sqlnet.ora.
    It's simple, you can't.

    Until you can use sqlplus to connect to your remote database, your database links will never work (basically). Configure your client. Once your client is configured and you can connect via sqlplus, you will be able to connect through a db link.

    It looks like you are using Oracle Names as your naming method. Make sure your remote db is listed in your names server.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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