OUI incorrectly reports DHCP is used, installation is incomplete

Installation and support for Oracle DB on CentOS.
bgravatt
Posts: 9
Joined: 2006/08/23 15:07:34
Location: North Liberty, IA USA
Contact:

OUI incorrectly reports DHCP is used, installation is incomp

Post by bgravatt » 2006/09/12 20:37:40

Hello Everyone,

I have been trying to install Oracle 10g R2 on a Dell 2800 currently running CentOS 4.4 for several days. All preinstallation chores have been completed. The OUI complains that the server is using DHCP to get it's ip address. This is simply not correct. The server has a fixed ip address. ... this is confirmed in /etc/sysconfig/network-scripts/ifcfg-eth0, a copy is attached ...

The OUI also complains that it cannot start a listener and suggests that the listener may already be started. This is NOT the case.

After completing the installation (basically taking all defaults) there are no services running. If I manually start a service for the Enterprise Manager and then connect to it, EM cannot start the database instance (orcl) and EM cannot start the listner.

I can start the instance using sqlplus, however I simply cannot start the listner. If I manually start the listner with "lsnrctl -start", I get inconsistent results, sometimes a permissions error is reported, other times the listener appears to be started. However, if I manually start both and then connect with EM, EM continues to report that the instance and listener are not running, and it cannot start either one.

I have several reference books, but all assume that the installation will go as expected. I can't find anything that will allow me to diagnose and correct this problem.

Any help would be appreciated. Thank you.

mariano
Posts: 37
Joined: 2006/02/14 19:45:02
Location: Cordoba, Argentina
Contact:

Re: OUI incorrectly reports DHCP is used, installation is incomplete

Post by mariano » 2006/09/13 00:51:16

Hi. Can you post the errors you get on every startup process (either manually or automatic)?

bgravatt
Posts: 9
Joined: 2006/08/23 15:07:34
Location: North Liberty, IA USA
Contact:

Re: OUI incorrectly reports DHCP is used, installation is incomplete

Post by bgravatt » 2006/09/13 16:58:32

Thank you for responding.

After installation, and after reboot nothing is running. I can successfully start the database with:

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 13 11:23:05 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1258291200 bytes
Fixed Size 1219160 bytes
Variable Size 318768552 bytes
Database Buffers 922746880 bytes
Redo Buffers 15556608 bytes
Database mounted.
Database opened.

I cannot start the listner:
[oracle@ciscorh bin]$ lsnrctl -start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 13-SEP-2006 11:23:59

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> start
Starting /app/oracle/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /app/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /app/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted

Listener failed to start. See the error message(s) above...

The fact that there appears to be a permissions error related to the protocol adapter causes me to suspect this is the heart of the issue. I believe this could easily be related to the fact that the OUI incorrectly reports that the protocol adapter is using DHCP.

Nor can I start EM:
[oracle@ciscorh bin]$ ./emctl status dbconsole
TZ set to US/Central
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://ciscorh.internal:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is not running.
------------------------------------------------------------------
Logs are generated in directory /app/oracle/oracle/product/10.2.0/db_1/ciscorh.internal_orcl/sysman/log
[oracle@ciscorh bin]$ cd /app/oracle/oracle/product/10.2.0/db_1/ciscorh.internal_orcl/sysman/log
[oracle@ciscorh log]$ tail -2 emdctl.trc 2006-09-12 16:16:22 Thread-3086911712 WARN http: snmehl_connect: connect failed to (ciscorh.internal:3938): Connection refused (error = 111)
2006-09-12 16:16:25 Thread-3086911712 WARN http: snmehl_connect: connect failed to (ciscorh.internal:3938): Connection refused (error = 111)
2006-09-12 16:16:28 Thread-3086911712 WARN http: snmehl_connect: connect failed to (ciscorh.internal:3938): Connection refused (error = 111)

And now I am becoming more confused than ever. The error message refers to http. Does this mean that a web server must also be running? I can find no reference to a web server in the prerequisites.

BTW, neither the firewall, nor SE Linux is enabled. See the attached jpg for screen shots.

mariano
Posts: 37
Joined: 2006/02/14 19:45:02
Location: Cordoba, Argentina
Contact:

Re: OUI incorrectly reports DHCP is used, installation is incomplete

Post by mariano » 2006/09/13 17:25:51

Hi.
I assume that the oracle user has proper execution permissions on the soft directories (if you have follow the guidelines to install).

A question while I search a little bit my conf to see if I can provide additional info:

1- Did you try to start the whole process using the script "dbstart" located on the oracle /bin directory?
As far as I can tell the process first start up the listener and then the database. You have to check there that the ORACLE_HOME, ORACLE_HOME_LISTNER, etc are properly updated and then try to execute it to see if that starts up all correctly. Search for it and take a look inside. You should try it, maybe a meaninful error message can arose from there.

Nevermind about the services right now, you will add them in the init.d as soon as you can manually start the db with no issues.

Let me know how it goes and I will try to help in whatever I can.

bgravatt
Posts: 9
Joined: 2006/08/23 15:07:34
Location: North Liberty, IA USA
Contact:

Re: OUI incorrectly reports DHCP is used, installation is incomplete

Post by bgravatt » 2006/09/13 17:53:28

Hi,

Using dbstart, the listner.log contains the following:
./dbstart: Starting Oracle Net Listener

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 13-SEP-2006 12:47:45

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /app/oracle/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /app/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /app/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted

Listener failed to start. See the error message(s) above...

Thanx

mariano
Posts: 37
Joined: 2006/02/14 19:45:02
Location: Cordoba, Argentina
Contact:

Re: OUI incorrectly reports DHCP is used, installation is incomplete

Post by mariano » 2006/09/13 18:32:49

It seems that it's a privilege issue.

# oerr tns 00525
00525, 00000, "Insufficient privilege for operation"
// *Cause: Operating system failed to complete operation because user
// lacked sufficient privileges.
// *Action: Check your platform-specific privileges.

It fails on the agent for external procedures, EXTPROC_CONNECTION_DATA.

1- Just to see how it goes, can you execute the dbstart with the root user instead of oracle?
2- Can you check the SID_LIST_LISTENER and the LISTENER located in the listener.ora file? The first one has a parameter ORACLE_HOME and verify if the oracle user has proper permissions in that directory?

mariano
Posts: 37
Joined: 2006/02/14 19:45:02
Location: Cordoba, Argentina
Contact:

Re: OUI incorrectly reports DHCP is used, installation is incomplete

Post by mariano » 2006/09/13 18:35:14

For example if I check the same directory in my installation that I've got in the listener.ora I see:
# ls -l
total 8
drwxr-x--- 59 oracle oinstall 4096 sep 13 14:14 db_1

What's yours?

bgravatt
Posts: 9
Joined: 2006/08/23 15:07:34
Location: North Liberty, IA USA
Contact:

Re: OUI incorrectly reports DHCP is used, installation is incomplete

Post by bgravatt » 2006/09/13 21:29:49

Hi,

Permissions are correct on all oracle directories. I tried running as root after executing /usr/local/bin/oraenv. Unfortunately the results are the same. listener log still reports the permissions error.

BTW, I finally determined that the OUI is checking /etc/sysconfig/network-scripts/ifcfg-lo. Why it does so is beyond my comprehension, since this script is for loopbacks. Anyway, I cheated, copied ifcfg-eth0 to ifcfg-lo for the installation process. OUI did not complain about DHCP and in fact reported no errors. But, the net result is the same, can't start the listener due to "permissions".

mariano
Posts: 37
Joined: 2006/02/14 19:45:02
Location: Cordoba, Argentina
Contact:

Re: OUI incorrectly reports DHCP is used, installation is incomplete

Post by mariano » 2006/09/14 03:31:37

I'm searching for a solution without luck yet. On the oracle official forums are several mentions (specially on the XE forum) but I'm not sure they are suitable for your case. I'll keep looking and I see what I can find.
I hope this can be fix asap.

bgravatt
Posts: 9
Joined: 2006/08/23 15:07:34
Location: North Liberty, IA USA
Contact:

Re: OUI incorrectly reports DHCP is used, installation is incomplete

Post by bgravatt » 2006/09/18 21:06:59

Thanks to all who repiled.

This is has been solved, more or less, with assistance from oracle. It seems that CentOS created a default entry in /etc/hosts that included the machine name and domain name in the loopback entry. After editing those out, I installed oracle. All appeared to go well, however there was still a permissions issue. By runing netca to reconfigure the listener I was able to start a listener after this utility generated a new listener.ora. I still have to manually restart everything after reboot, but it appears that I have a functional oracle database.

Post Reply

Return to “CentOS 4 - Oracle Installation and Support”