problems with 10g R2 install on Linux

[deesto]

I've installed 10g Database R2 (and de/re-installed it) on my RHEL4 Linux system several times now, and I have the same errors come up each time that I had with a fresh install. For example, when I try to start the EM console:
$ $ORACLE_HOME/bin/emctl start dbconsole
OC4J Configuration issue. /usr/local/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_[hostnme]_[sid] not found.

When I try to configure the EM agent:
$ $ORACLE_HOME/bin/emctl config agent
EM Configuration issue. /usr/local/oracle/product/10.2.0/db_1/[hostnme]_[sid] not found.

When I try to recreate the EM repository:
$ $ORACLE_HOME/bin/emca -repos recreate
...
Jul 9, 2007 4:02:59 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error dropping the repository
Jul 9, 2007 4:02:59 PM oracle.sysman.emcp.EMReposConfig invoke
...


When I try to configure the dbcontrol web port (or any other port):
$ $ORACLE_HOME/bin/emca -reconfig ports -DBCONTROL_HTTP_PORT 1820
...
Jul 9, 2007 3:57:23 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Database Control is not configured for this database.
...

And another:
$ $ORACLE_HOME/bin/emca -config dbcontrol db -repos recreate

STARTED EMCA at Jul 9, 2007 4:04:23 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: oracledb
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Invalid username/password.

I've found and tried to follow steps to alleviate each of these errors, but nothing works. There seems to be something essential wrong, either with the version (I verified the sum of the archive before installing) or with my system with regard to Oracle.

[pando]

check the logfiles

thanks

[deesto]

check the logfiles

thanks
And thanks to you as well... but what would I check the logfiles for? which log files? The information I've found in the logs so far has not been helpful.

[pando]

Tell us which logs have you checked?

Thanks

[deesto]

All of them! That is: all the logs that are reported by the error messages. install logs, action logs for each utility.

[PAVB]

Could you be more specific?
I'm almost certain Pando was expecting something like a list of filenames including full path.

[deesto]

Of course... I didn't want to dump a bunch of long logs without being asked first. As it turns out, the logs are too long to list here, so I have attached them as a TXT file. I hope this helps. Please let me know if you need more logs:

[PAVB]

Pando asked for a list of log names... not for the actual logs

[deesto]

Some of the logs:
/usr/local/oracle/product/10.2.0/db_1/cfgtoollogs/oui/installActions2007-07-06_02-28-33PM.log
/usr/local/oracle/product/10.2.0/db_1/cfgtoollogs/oui/oraInstall2007-07-06_02-28-33PM.err
/usr/local/oracle/product/10.2.0/db_1/cfgtoollogs/emca/emca_2007-07-09_04-04-23-PM.log
/usr/local/oracle/product/10.2.0/db_1/cfgtoollogs/emca/emca_2007-07-09_04-51-53-PM.log
/usr/local/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/oracledb/emConfig.log

[pando]

havent you see these messages?

CONFIG: SQLEngine connecting with SID: oracledb, oracleHome: /usr/local/oracle/product/10.2.0/db_1, and user: DBSNMP
Jul 9, 2007 4:04:32 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: ORA-01017: invalid username/password; logon denied

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01017: invalid username/password; logon denied

Thanks

[deesto]

Yes, I have seen these messages, and many others. I tried to address the problem with the DBSNMP user with the following SQL code:

ALTER PROFILE MONITORING_PROFILE
LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED
PASSWORD_GRACE_TIME UNLIMITED
PASSWORD_LIFE_TIME UNLIMITED
PASSWORD_LOCK_TIME UNLIMITED
PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_VERIFY_FUNCTION NULL;

This completes successfully, but it does not seem to have an effect on the account/password issue. Can you tell me how this can be fixed?

[PAVB]

Are you expecting to solve an account password issue by altering a profile?

[deesto]

I have tried every solution I can find, and when I posted this particular error message on another forum, I was told that the fix was to run the above "ALTER PROFILE" command. If that is not appropriate, I would appreciate your thoughts on a proper fix.

I am not a DBA. I have been struggling with this installation for weeks. All I would like is for this installation to work as expected, instead of getting errors with every command on a fresh installation.

Thanks for your help.

[PAVB]

Use correct user/password pair
DBSNMP default password should be DBSNMP

[deesto]

I'd also found and tried that, but "DBSNMP" as the password also returns "Invalid username/password".

[PAVB]

ALTER USER DBSNMP IDENTIFIED BY "dbsnmp"
/

[deesto]

Thank you. That works to fix the password problem. Now I get the following:
emca -config dbcontrol db -repos recreate

STARTED EMCA at Jul 10, 2007 3:30:18 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: oracledb
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /usr/local/oracle/product/10.2.0/db_1

Database hostname ................ [hostname]
Listener port number ................ 1521
Database SID ................ oracledb
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Jul 10, 2007 3:30:48 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /usr/local/oracle/product/10.2.0/db_1/cfgtoollogs/emca/oracledb/emca_2007-07-10_03-30-18-PM.log.
Jul 10, 2007 3:30:50 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Failed to allocate port(s) in the specified range(s) for the following process(es): JMS [5540-5559],RMI [5520-5539],Database Control [5500-5519],EM Agent [3938] | [1830-1849]
Refer to the log file at /usr/local/oracle/product/10.2.0/db_1/cfgtoollogs/emca/oracledb/emca_2007-07-10_03-30-18-PM.log for more details.
Could not complete the configuration. Refer to the log file at /usr/local/oracle/product/10.2.0/db_1/cfgtoollogs/emca/oracledb/emca_2007-07-10_03-30-18-PM.log for more details.


The error in that log file:
SEVERE: Failed to allocate port(s) in the specified range(s) for the following process(es): JMS [5540-5559],RMI [5520-5539],Database Control [5500-5519],EM Agent [3938] | [1830-1849]
Refer to the log file at /usr/local/oracle/product/10.2.0/db_1/cfgtoollogs/emca/oracledb/emca_2007-07-10_03-30-18-PM.log for more details.
Jul 10, 2007 3:30:50 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Failed to allocate port(s) in the specified range(s) for the following process(es): JMS [5540-5559],RMI [5520-5539],Database Control [5500-5519],EM Agent [3938] | [1830-1849]
at oracle.sysman.emcp.EMDBPreConfig.checkPorts(EMDBPreConfig.java:2266)
at oracle.sysman.emcp.EMDBPreConfig.performConfiguration(EMDBPreConfig.java:670)
at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:233)
at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:160)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:141)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:479)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1123)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:463)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)


The port error again. If I try to set the dbcontrol port with "emca -reconfig ports -DBCONTROL_HTTP_PORT 1820", I get:
SEVERE: Database Control is not configured for this database.

I can't seem to get any of the emca commands to work.

[PAVB]

http://download-uk.oracle.com/docs/html/B10811_05/app_port.htm

[deesto]

I've read that document; I was told I could alter the ports via emca commands, but that doesn't seem to work.

On that page:
To change the HTTP port, edit the following files:
*$ORACLE_HOME/host_sid/sysman/config/emoms.properties
On my system, this file path does not exist. The closest to that file name is:
/usr/local/oracle/product/10.2.0/db_1/sysman/config/emoms.properties


In that file, the console server ports are set to variable values:

oracle.sysman.emSDK.svlt.ConsoleServerPort=%EM_UPLOAD_PORT%
oracle.sysman.emSDK.svlt.ConsoleServerHTTPSPort=%EM_UPLOAD_HTTPS_PORT%

Most of the other parameters are also set to variables. Should I manually change all of the values to hard-coded values instead of variables, throughout the properties file?

[PAVB]

ORACLE_HOME = /usr/local/oracle/product/10.2.0/db_1

Could you please share with us -one more time- the reason why you are trying to install Ora10g while not being a DBA?

[deesto]

ORACLE_HOME = /usr/local/oracle/product/10.2.0/db_1
That's correct. However, the path called out in that document, $ORACLE_HOME/host_sid/, does not exist.
Could you please share with us -one more time- the reason why you are trying to install Ora10g while not being a DBA?
I don't think I have shared this with you before, as it hasn't been asked: I'd like to learn as much as I can about Oracle. But does that truly matter?

I have installed Database 10g on Windows systems multiple times, and I've never had this trouble before doing an install on Linux.

[Bore]

Seems you have all the ports in the specified range occupied by other apps or I am wrong? So when u try to config the em, it tries to allocate a port in this range but fails. U cannot change the port, since it is not set at all. The successfull emca will create the directory u miss.
So to summarize, emca tries to set dbconsole on some port in the specified ranges, but can't find one free. Maybe OS prevents it somehow, maybe they are just occupied. The easiest is to get a clean machine, reinstall the OS and start from scrach

[deesto]

Thanks Bore. According to netstat, my system doesn't have anything running on any of the ports specified by Oracle. I supposed that doesn't necessarily mean that the ports aren't somehow reserved, but I'm not sure how to investigate that. In any case, it's highly unlikely that all of the necessary ports are already being used by something else. If possible, please let me know of a way to verify what ports are "reserved" by the system. I'm trying to install on my Linux workstation, so I'd rather not wipe out the machine and reinstall the OS unless absolutely necessary.

Thank you.

[craigdba]

You could try usign telnet to connect to the port, is there a firewall involved?

[PAVB]

You could try usign telnet to connect to the port, is there a firewall involved?

I'll love to see more of this... could you please elaborate?

[craigdba]

elaborate on what in particular

[deesto]

I'll love to see more of this... could you please elaborate?
My guess is that craigdba means for me to try to telnet to one of the ports that Oracle is complaining about ... if the connection is refused, to port is not being listened to.
$ telnet localhost 1521
Trying 127.0.0.1...
telnet: connect to address 127.0.0.1: Connection refused
telnet: Unable to connect to remote host: Connection refused


I am behind a firewall here, but since I'm trying to install on my own system, I don't believe the firewall is a factor (or is it?).

[deesto]

I still haven't been able to figure this out.

I noticed in the $ORACLE_HOME/install/ directory a file called portlist.ini, which contains the following:
iSQL*Plus HTTP port number =5560
Are we supposed to edit this file before installation (even though the directory doesn't yet exist) and enter values for all necessary ports?

[Bore]

See,
That turns more to Linux question than Oracle one. There are some linux staff such as SELINUX, also some ports are resevred and can be allocated only by processes owned by root, but that comes out of my Linux knowledge and I would not comment on that.

[deesto]

Right: there's SELinux (disabled on my system) and /etc/services (none of the Oracle ports are listed in my /etc/services), which are part of Linux. But this $ORACLE_HOME/install/portlist.ini comes from Oracle and must be created either during installation. I found this in one of the Oracle docs:
The portlist.ini file lists the port numbers assigned during the [application server] installation.

So, in my case, only the iSQL*Plus port number was assigned? Why not the others?

[ahad]

Hello,
has it been solved this issue? I have exactly the same problem under AIX 5.2
I had on the server a previous Oracle installation. I suppose that the old one conflicts with my current installation, and this is why I cannot get (neither reconfigure) the ports.
thanks.