problems with 10g R2 install on Linux

Printable View

07-09-2007, 04:10 PM
deesto

problems with 10g R2 install on Linux

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:

Code:

$ $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:

Code:

$ $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:

Code:

$ $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):

Code:

$ $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:

Code:

$ $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.
07-09-2007, 05:36 PM
pando

check the logfiles

thanks
07-09-2007, 05:52 PM
deesto

Quote:

Originally Posted by pando

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.
07-10-2007, 02:33 AM
pando

Tell us which logs have you checked?

Thanks
07-10-2007, 08:30 AM
deesto

All of them! That is: all the logs that are reported by the error messages. install logs, action logs for each utility.
07-10-2007, 10:07 AM
PAVB

Could you be more specific?
I'm almost certain Pando was expecting something like a list of filenames including full path.
07-10-2007, 11:36 AM
deesto

1 Attachment(s)

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:
07-10-2007, 11:51 AM
PAVB

Pando asked for a list of log names... not for the actual logs
07-10-2007, 12:09 PM
deesto

Some of the logs:

Code:

/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
07-10-2007, 02:32 PM
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
07-10-2007, 02:40 PM
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:

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?
07-10-2007, 02:46 PM
PAVB

Are you expecting to solve an account password issue by altering a profile?
07-10-2007, 02:52 PM
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.
07-10-2007, 02:59 PM
PAVB

Use correct user/password pair
DBSNMP default password should be DBSNMP
07-10-2007, 03:07 PM
deesto

I'd also found and tried that, but "DBSNMP" as the password also returns "Invalid username/password".
07-10-2007, 03:12 PM
PAVB

ALTER USER DBSNMP IDENTIFIED BY "dbsnmp"
/
07-10-2007, 03:40 PM
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.
07-10-2007, 03:58 PM
PAVB

http://download-uk.oracle.com/docs/h...5/app_port.htm
07-10-2007, 04:32 PM
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:

Quote:

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:

Code:

/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:

Code:

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?
07-10-2007, 04:41 PM
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?
07-10-2007, 04:53 PM
deesto

Quote:

Originally Posted by PAVB

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.

Quote:

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.
07-11-2007, 08:45 AM
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
07-11-2007, 10:15 AM
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.
07-11-2007, 04:20 PM
craigdba

ports

You could try usign telnet to connect to the port, is there a firewall involved?
07-11-2007, 04:47 PM
PAVB

Quote:

Originally Posted by craigdba

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?
07-11-2007, 05:36 PM
craigdba

elaborate on what in particular
07-11-2007, 05:38 PM
deesto

Quote:

Originally Posted by PAVB

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?).
07-16-2007, 02:11 PM
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:

Code:

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?
07-17-2007, 03:57 AM
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.
07-17-2007, 09:27 AM
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?
09-26-2008, 06:19 AM
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.