#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    15
    Rep Power
    0

    Net8 problem !!!


    Hello ... I have Oracle8i Database server ... on a server without Domain Name .. just a host name (Oracle-Server) and intern IP address (192.168.0.102).

    how I can configure the (tnsnames.ora) and (listener.ora) so i can log into the data base from another PC in the same Network ???? IT should be easy ... but it keep saying the there is no listner or adepter error ... !!!!


    My tnsnames.ora is:
    ===========================================
    # C:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:C:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora
    # Generated by Oracle Net8 Assistant

    ORACLEDB =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = Oracle-Server))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = oracledb)
    )
    )
    ============================================
    My listener.ora is:
    ============================================
    # C:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration File:C:\Oracle\Ora81\network\admin\listener.ora
    # Generated by Oracle Net8 Assistant

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = Oracle-Server)(PORT = 1521))
    )
    )
    )

    ORACLEDB =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = Oracle-Server)(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = C:\Oracle\Ora81)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = oracledb)
    (ORACLE_HOME = C:\Oracle\Ora81)
    (SID_NAME = ORACLEDB)
    )
    )

    SID_LIST_ORACLEDB =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = C:\Oracle\Ora81)
    (PROGRAM = extproc)
    )
    )
    ============================================

    Thank you all for your time.

    Sarmad M. Azad
    Førde, Norway
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    2
    Rep Power
    0
    You need to edit the tnsnames.ora file on the client PC that you wish to connect to the Oracle server from. Here is a snippet of a tns file:

    # TNSNAMES.ORA Network Configuration File: C:\oracle\OraSrv\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    TEST = #(name of the databse)
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = %your servername here%)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = TEST) # (name of database)
    )
    )
  4. #3
  5. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Posts
    60
    Rep Power
    11
    You can put the IP in the HOST= defintion in the tnsnames.ora file -- that goes on the client system. Also, in case you don't know... use 'tnsping' command to check your tnsnames.ora setup and oranet configuration.

    -c
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    15
    Rep Power
    0
    Thank you all ... but what about listener.ora ... so I have to delete it ... or what i have to do with it !!!!


    and can I put this (tnsnames.ora) in the sererver ....

    and dose that mean that I don't need a domain name ???


    sorry it's llok like stuped questions ... but I need to clear some thing in my mind :-)


    Thank you alot for your time

IMN logo majestic logo threadwatch logo seochat tools logo