Is there a default sysman_pwd value

Posted on 2010-04-06
Medium Priority
Last Modified: 2013-12-18

When I create a database I get a warning that Enterprise manager configuration succeeded with the following warning -

Errorsecuring Database Control, Database Control has been brought up in non-secure mode. To secure the Database Control execute the following command (s):
1)Set the environment variable ORACLE_SID
2) C:\oracle\product\10.2.0\db_1\bin\emctl.bat stop dbconsole
3) C:\oracle\product\10.2.0\db_1\bin\emctl.bat config emkey -repos -sysman_pwd <PASSWORD for sysman user>

I complete steps 1 & 2 with no problem. But every time I try #3 I get the following error message:

Oracle Enterprise Manager 10g Database Control Release
Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved.

Invalid Password
caught Exception java.sql.SQLException: Io exception: Invalid Packet Lenght

I didn't know the sysman password so I logged into the database and changed it. I tested logging in as sysman with the new password. However, every time i enter the password in the above command I keep getting the same error message. I can log into other databases on other servers. However, I can't log into my own database. Could someone help me to trouble shoot and resolve this issue?
Question by:sikyala
  • 7
  • 5
LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 2000 total points
ID: 30013297
Had to resort to Google.  Check the listener?


It also looks like you can't just change the SYSMAN password from a SQL prompt once OEM has been configured:

LVL 68

Expert Comment

ID: 30015980
Did you obey OEM's password policy?
Passwords are required to be at least 5 characters long, with at least one number.  
Passwords must start with an alphabet character.
You may not  use any special characters in your password other than "-" (hyphen), "_" (underscore), and "$" (dollar).

Author Comment

ID: 30029706
When I check the listener I found it was not started. When I try to start it I get the following message:

The OracleOraDb10g_home1TNSListener service on local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service.

When I try to test my listener file I get the following message:

Connecting...ORA-12569: TNS:packet checksum failure
The test did not succeed.
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 30032437
Try starting it manually from a command prompt:  lsnrctl start

Post back the errors you receive.

Author Comment

ID: 30032611
C:\>lsnrctl start

LSNRCTL for 32-bit Windows: Version - Production on 07-APR-2010 12:05

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

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version - Production
System parameter file is C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.or
Log messages written to C:\oracle\product\10.2.0\db_1\network\log\listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<mydbserver>)(PORT=1521)))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
32-bit Windows Error: 48: Unknown error

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

Expert Comment

by:slightwv (䄆 Netminder)
ID: 30033467
Do you have multiple ORACLE_HOMEs on this machine?  It's possible there is another listener running.

Check the status:  lsnrctl status

Author Comment

ID: 30033610
I only have 1 ORACLE_HOME. But there has to be another listener somewhere. I can't find it. I say this because although I can't connect to my local database I can connect to a database on another server.

Author Comment

ID: 30033904
when I type lsnrclt status I get the following:

TNS-12569: TNS:packet checksum failure
LVL 78

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 2000 total points
ID: 30034286
>>I say this because although I can't connect to my local database I can connect to a database on another server.

The listener in a service running on the database server.  You don't need to worry about the remote ones, just the local one.

>>when I type lsnrclt status I get the following

check your local listener.ora file.  try using the loopback adapter: in the HOST section.

you might also have a conflict with some other application using TCP port 1521.  You can do a 'netstat -a' to see if something is listeneing on 1521.

For grins you could go ahead and change the port in the listener.ora file and see if you can start the listener.

Author Comment

ID: 30034597
hmmm I do have other database servers running on this system (H2, SQL Server, Mysql). I know I had a conflict with the H2 database using port 1521

Author Comment

ID: 30035068
I found the database service that was using port 1521 and stopped it. Then I was able to start the listener
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 30035243
Cool but if you need that service, just change the Oracle listener port in the listener.ora file.  This is recommended in Production systems since everyone knows the default.

Just make one up and use it.  Maybe the year you were born or your home phone...  It won't hurt a thing.

Author Closing Comment

ID: 31711606
It turns out the problem wasn't the password it was the listener. Thanks!

Featured Post

7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question