1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Installing Both Oracle 11g R2 Server(64bit) and Oracle 11g Client(32bit) on a server

Discussion in 'Installation - Windows' started by Jaan_Lin, Dec 10, 2013.

  1. Jaan_Lin

    Jaan_Lin Active Member

    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    Hangzhou,China
    Hi all,

    I have installed both Oracle 11g R2 server(64bit) and Oracle 11g client(32bit) on a Win 2008 R2 server(64bit) for Cognos training.

    Now the issue is that the Oracle cannot working in a normal status since the server had been restarted. The listener cannot be started successfully.

    I have copied all the details rearding TNS, Listener and sqlnet for both server and client. Very appreciate if any of you can give me some advices.

    I am not sure what has been changed once the pc has been restarted.

    Thanks in advance.

    Regards,
    Lin



    Server

    -- TNS

    # tnsnames.ora Network Configuration File: D:\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
    # Generated by Oracle configuration tools.

    ORACLR_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
    (SID = CLRExtProc)
    (PRESENTATION = RO)
    )
    )

    ORCL =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = orcl)
    )
    )

    -- sqlnet.ora

    # sqlnet.ora Network Configuration File: D:\Oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
    # Generated by Oracle configuration tools.

    # This file is actually generated by netca. But if customers choose to
    # install "Software Only", this file wont exist and without the native
    # authentication, they will not be able to connect to the database on NT.

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

    --Listener

    # listener.ora Network Configuration File: D:\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
    # Generated by Oracle configuration tools.

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = CLRExtProc)
    (ORACLE_HOME = D:\Oracle\product\11.2.0\dbhome_1)
    (PROGRAM = extproc)
    (ENVS = "EXTPROC_DLLS=ONLY:D:\Oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
    (SID_DESC =
    (GLOBAL_DBNAME = orcl)
    (ORACLE_HOME = D:\Oracle\product\11.2.0\dbhome_1)
    (SID_NAME = orcl)
    )
    )

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
    )
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    )

    ADR_BASE_LISTENER = D:\Oracle


    Client

    -- tns
    # tnsnames.ora Network Configuration File: D:\Oracle11g_client\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    ORACLR_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
    (SID = CLRExtProc)
    (PRESENTATION = RO)
    )
    )

    ORCL =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = orcl)
    )
    )

    --sqlnet.ora

    # sqlnet.ora Network Configuration File: D:\oracle11g_client\product\11.2.0\client_1\network\admin\sqlnet.ora
    # Generated by Oracle configuration tools.

    # This file is actually generated by netca. But if customers choose to
    # install "Software Only", this file wont exist and without the native
    # authentication, they will not be able to connect to the database on NT.

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Re: Installing Both Oracle 11g R2 Server(64bit) and Oracle 11g Client(32bit) on a ser

    Why did you install a 32-bit client when Oracle database software was already installed? The database server software includes the client. My GUESS is you installed the Oracle database software first, then installed the client which puts the CLIENT path in front of the DATABASE path and may make it impossible to start the listener. You do not need the client installed when Oracle database software is installed and running so I would delete the client installation.
     
  3. Jaan_Lin

    Jaan_Lin Active Member

    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    Hangzhou,China
    Re: Installing Both Oracle 11g R2 Server(64bit) and Oracle 11g Client(32bit) on a ser

    Hi Zargon, thanks for your prompt reply. I installed client because of Cognos application. I know in real production environment we can install Oracle server and client in separated servers. But it is a training server, and all what i can do is to install all files on one server.
    My guess is that there should be something wrong with Oracle path, and also something need to be changed in environment Variables.
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Re: Installing Both Oracle 11g R2 Server(64bit) and Oracle 11g Client(32bit) on a ser

    You install a separate client when you DO have separate servers; it is unnecessary to do so on the same server where the database software is installed and, as you now know, doing so can cause pieces of the database installation to not work.