Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2010
    Posts
    2

    Unanswered: TNS-12560: TNS:protocol adapter error

    I’m installing SAP ERP 6.0 on a Windows server 2008 with Oracle 10.2.0.4.0.
    I’m using the Sapinst tool. At the step “Configure Oracle server Network” I get the an error. In the lsnrctl.log file I can read:
    TNS-12560: TNSrotocol adapter error
    TNS-00530: Protocol adapter error

    These are my .ora files in the path <oracle-home>\NETWORK\ADMIN::

    1 )LISTENER.ORA

    ADMIN_RESTRICTIONS_LISTENER = on
    LISTENER =
    (ADDRESS_LIST =
    (ADDRESS =
    (PROTOCOL = IPC)
    (KEY = DEV.WORLD)
    )
    (ADDRESS=
    (PROTOCOL = IPC)
    (KEY = DEV)
    )
    (ADDRESS =
    (COMMUNITY = SAP.WORLD)
    (PROTOCOL = TCP)
    (HOST = SAP-BTdemo)
    (PORT = 1527)
    )
    )
    STARTUP_WAIT_TIME_LISTENER = 0
    CONNECT_TIMEOUT_LISTENER = 10
    TRACE_LEVEL_LISTENER = OFF
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = DEV)
    (ORACLE_HOME = F:\oracle\DEV\102)
    )
    )

    2) SQLnet.ora:

    AUTOMATIC_IPC = ON
    TRACE_LEVEL_CLIENT = OFF
    NAMES.DEFAULT_DOMAIN = WORLD
    # 05.01.06 unsorported parameter now
    #NAME.DEFAULT_ZONE = WORLD
    # 05.01.06 set the default to 10
    SQLNET.EXPIRE_TIME = 10
    SQLNET.AUTHENTICATION_SERVICES = (NTS)
    # 05.01.06 set to default
    #TCP.NODELAY=YES
    # 05.01.06 set to 32768
    DEFAULT_SDU_SIZE=32768

    3) tnsname.ora:

    DEV.WORLD=
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (COMMUNITY = SAP.WORLD)
    (PROTOCOL = TCP)
    (HOST = SAP-BTdemo)
    (PORT = 1527)
    )
    )
    (CONNECT_DATA =
    (SID = DEV)
    (GLOBAL_NAME = DEV.WORLD)
    )
    )

    I have set the following Environment Variables:
    • ORACLE_HOME = F:\oracle\DEV\102
    • ORACLE _SID= DEV
    • TNS_ADMIN= F:\oracle\DEV\102\NETWORK\ADMIN

    I have installed Oracle by Universal Installer and, in the Server Manager, I got only the following Oracle Service:

    OracleDEV102iSQL*Plus

    If I use the command lsnrctl start from Windows prompt I get the same error.

    Can anyone help me?
    Last edited by Andrelor82; 10-26-10 at 17:56.

  2. #2
    Join Date
    Mar 2010
    Location
    Vienna, Austria
    Posts
    149
    Andrelor82,

    if the only service you find is "OracleDEV102iSQL*Plus", you don't have a database installed.
    You should see at least the following Sevices (assuming it's a default installation, and your SID is "DEV"):

    - OracleServiceDEV
    - OracleOraDb10g_home1TNSListener
    - OracleJobSchedulerDEV

    Are you sure, you didn't just install the software ?
    "There is always an easy solution to every problem - neat, plausible, and wrong."
    -- H.L. Mencken

  3. #3
    Join Date
    Oct 2010
    Posts
    2
    My workmates told me that the Sapinst tool create the database. This is my first installation but I think that up to know I have only created the LSNRCTL. The problem is that without the listener it can't work. If I digit lsnrctl start it says "no listener". The listener seem to be necessary to the Sapinst to continue it's installation.

    Should all of those services be active after installation by means of Oracle Universal Installer? I tried to create them manually but this doesn't work.

    any idea?

    What do you mean by "only software". What's the next step?
    Last edited by Andrelor82; 10-26-10 at 17:54.

  4. #4
    Join Date
    Mar 2010
    Location
    Vienna, Austria
    Posts
    149
    Andrelor82,

    I've never worked with SAP, so I don't know anything about this installation tool.

    One of the Oracle Installer options is, to only install the Oracle SW, but not creating a database (That's what I meant by "only software")

    The easiest way to create a database is with a tool called "dbca" (database creation assistant)

    Usually the Universal Installer - session is used to install the software AND a starter database (in this case, dbua is called by the installer).

    The same goes for the listener:
    When a database is created during a universal installer - session, another tool, the network configuation assistant (netca) is called to configure the listener.
    If you create (the first) database with dbca you have to run netca afterwards.

    Check for the database and listener services (as mentioned in my last posting). If they are not there, run dbua & netca.
    "There is always an easy solution to every problem - neat, plausible, and wrong."
    -- H.L. Mencken

Posting Permissions

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