Home » RDBMS Server » Networking and Gateways » Net hanging on redhat 7.2 Installation
Net hanging on redhat 7.2 Installation [message #66396] Thu, 16 May 2002 13:33 Go to next message
webby
Messages: 1
Registered: May 2002
Junior Member
Hi,

Im trying to install 9i on redhat 7.2. I've followed a few web site tips
about what to do about installing java, and creating oracle users, setting
shared memory and so on. Im still having problems when the network
configuration assistant runs up though in the installer. Basically it just
sits there listening. Now my machine is called hotrats (after the great
zappa/beefheart album :) and the /etc/hosts file contains the following

127.0.0.1 localhost localhost
127.0.0.1 hotrats hotrats

everything resolves ok when i use the apache and when I ping. I've set the
SID as database what should I enter as the global database name. I've tried
just database but I get the network problem.

I set the hostname and the ip addresses using network configurator.

So thats it basically the listener just listens. If I kill it and at the end
of the installation run the netca the test shows that the tcp listener seems
to work but the ipc one fails for some reason.

Any idea's ? Oh and does the listener matter anyway on a stand alone machine
? I'm installing oracle so I can learn how to use it by the way.

Here is some more info that may help any oracle/redhat guru, I've added some
details of what is in some files and such like

When thew listener starts in the Oracle Universal Installer the following is
displayed :

Parsing command line arguments:
Parameter "orahome" = /opt/oracle/product/9.0.1
Parameter "instype" = typical
Parameter "inscomp" = client,oraclenet,javavm,server,ano
Parameter "insprtcl" = tcp, tcps
Parameter "cfg" = local
Parameter "authadp" = NO_VALUE
Parameter "nodeinfo" = NO_VALUE
Parameter "responsefile" =
/opt/oracle/product/9.0.1/network/install/netca_typ.rsp
Done parsing command line arguments.Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
/opt/oracle/product/9.0.1/bin/lsnrctl start LISTENER

It then just sits there however the lsnrctl is show as :

oracle 18310 18300 0 18:01 pts/1 00:00:00 [[lsnrctl <defunct>]]

The response file contains :

[[GENERAL]]
RESPONSEFILE_VERSION="8.1.7"
CREATE_TYPE= "TYPICAL"
[[Session]]
TOPLEVEL_COMPONENT={"oracle.net.ca","8.1.7"}
[[oracle.net.ca]]
INSTALLED_COMPONENTS={"server","net8","javavm"}
INSTALL_TYPE=""typical""
LISTENER_NUMBER=1
LISTENER_NAMES={"LISTENER"}
LISTENER_PROTOCOLS={"TCP;1521"}
LISTENER_START=""LISTENER""
NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}
NSN_NUMBER=1
NSN_NAMES={"EXTPROC_CONNECTION_DATA"}
NSN_DBVERSION={"80"}
NSN_SERVICE_OR_SID = {"PLSExtProc"}
NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}

the netca_clt.rsp contains :

[[GENERAL]]
RESPONSEFILE_VERSION="8.1.7"
CREATE_TYPE= "TYPICAL"
[[Session]]
TOPLEVEL_COMPONENT={"oracle.net.ca","8.1.7"}
[[oracle.net.ca]]
INSTALLED_COMPONENTS={"client","net8"}
INSTALL_TYPE=""typical""
NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}
NSN_NUMBER=1
NSN_NAMES={"EXTPROC_CONNECTION_DATA"}
NSN_DBVERSION={"80"}
NSN_SERVICE_OR_SID = {"PLSExtProc"}
NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}

The listener.log contains :

TNSLSNR for Linux: Version 9.0.1.0.0 - Production on 16-MAY-2002 18:01:27

Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.

System parameter file is
/opt/oracle/product/9.0.1/network/admin/listener.ora
Log messages written to /opt/oracle/product/9.0.1/network/log/listener.log
Trace information written to
/opt/oracle/product/9.0.1/network/trace/listener.trc
Trace level is currently 0

Started with pid=18312
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hotrats)(PORT=1521)))

TIMESTAMP * CONNECT DATA [[* PROTOCOL INFO]] * EVENT [[* SID]] * RETURN CODE
16-MAY-2002 18:01:28 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=hotrats)(USER=oracle))(COMMAND=status)(AR
GUMENTS=64)(SERVICE=LISTENER)(VERSION=150999040)) * status * 0
16-MAY-2002 18:09:41 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=hotrats)(USER=oracle))(COMMAND=status)(AR
GUMENTS=64)(SERVICE=LISTENER)(VERSION=150999040)) * status * 0

And the listener.ora contains :

# LISTENER.ORA Network Configuration File:
/opt/oracle/product/9.0.1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/9.0.1)
(PROGRAM = extproc)
)
)

--
Re: Net hanging on redhat 7.2 Installation [message #66398 is a reply to message #66396] Fri, 17 May 2002 11:59 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
you need to add the DB to the SID_LIST_LISTENER in your listener.ora file:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/9.0.1)
(PROGRAM = extproc)
)
(SID_DESC = (GLOBAL_DBNAME = DB_NAME)
(ORACLE_HOME = /opt/oracle/product/9.0.1)
(SID_NAME = DB_NAME)
)
)

Change DB_NAME with your SID

In your tnsname.ora file add:

DB_NAME =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_NAME)(PORT = 1521))
)
(CONNECT_DATA =
(SID = DB_NAME)
)
)
Change DB_NAME with SID.

At this point stop/start the listener

lsnrctl stop
lsnrctl start

If it starts without errors cool. Now do:

tnsping DB_NAME

You should get an OK. Good luck.
Previous Topic: Not possible with server.
Next Topic: Re: oracle 8i on windows2000
Goto Forum:
  


Current Time: Thu Mar 28 20:42:14 CDT 2024