problems with 10g R2 install on Linux

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?

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

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.

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

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

ALTER USER DBSNMP IDENTIFIED BY "dbsnmp"
/

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.

http://download-uk.oracle.com/docs/h...5/app_port.htm

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?

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?