Oracle 11g: dbconsole ... giving tough time

Changing the name of the instance is bad idea.
But go to environment variables of the Oracle user and check if you have changed ORACLE_SID
environment variable properly.

yes all good, can connect and work, everything looks good as far as I can see, why you are saying, its not a good idea, to change the name?

and now when trying to even recreate/drop repository, giving errors.


Giving or not giving errors? What is true? What kind of errors?

its confusing ... the question is that dbconsole can not be configured, where as the db is working fine and no issues at all, I was asking ... why you said this:
"Changing the name of the instance is bad idea."

this is was my q, why it is bad to changd db/instance name? where as the db (db perspective) is working fine, dbconsole is a different baby right ... which is giving us hard time to get configured.

I think, now its clear ... correct?

dbconsole depends on instance name so when you change this you'll need to 'inform' dbconsole (I haven't done this) or you'll need to recreate repos.

You said you are havong problems creating even new dbconsole for new instances. You need to tell us what errors you're receiving. My guess is that it may be port related since dbconsole and agent are dependent on certain ports being available.

R.

Changing the DB nam or the host name or IP "distroys" the DB console.
In this case the DBA has to recreate the repository.

ok gurus ... here is an interesting situation, I'm trying to create dbconsole for a brand new db, but manually created.

have tried it earlier and it was failed, and now I'm trying to create ... it is again giving error:

CREATE PUBLIC SYNONYM EMD_MNTR FOR EMD_MNTR
                      *
ERROR at line 1:
ORA-00955: name is already used by an existing object

is there any way to do a complete cleanup of this dbconsole repo

because it is not even letting me drop it using:

emca -deconfig dbcontrol db -repos drop

please suggest, how I can create dbconsole on this newly manually created db?

What errors did you get when trying to drop the repos?

Check this link for ideas on how to complete this task.

http://forums.oracle.com/forums/thread.jspa?threadID=531118&tstart=0

R.

error ... couldn't connect to SYS

[23-04-2010 08:58:02] Enter SYS user's password :
[23-04-2010 08:58:02]
[23-04-2010 08:58:02] Getting temporary tablespace from database...
[23-04-2010 08:58:02] Could not connect to SYS/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=vmpawpaw)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PROD))): ORA-01031: insufficient privileges (DBD ERROR: OCISessionBegin)


please assist?

Thanks.

and now almost trying to drop, completely manual, yes, drop by using the drop command, and now it is stopping one by one on different synonyms ... dropping them one by one ... individually, is there any other way ... better way to accomplish this?

Thanks.

If you cannot connect to SYS then you have another problem. You must be able to connect to SYS.

Are you working directly on the server?
Are you on Windows or Unix?
Are you logged in as the administrator?

If you can resolve your connection to SYS problem then you should be able to accomplish your EM tasks easily.

R.

linux ... connected on the box, using sys ... and no issues at all

means connection to sys is no problem via sqlplus

oracle@vmoracle:scripts$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on Fri Apr 23 10:07:34 2010

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show user
USER is "SYS"
SQL>

you wont believe this ... but till now have already deleted/dropped 65 synonyms ... one by one ... :-(

please advice/suggest, if there is any other way to achieve this?

a lot of thanks.

just to inform, that there are other dbs using dbconsle on the same box and they are working fine, because configured at the time of db creation, done by dbca and this one is manual.

Please advice, is there any way to fix this problem?

this is kind of critical :-(

Creating dbconsole at instance creation is the best but it can just as easily be created afterwards.

What you need to do is find out what the SYS password is. If you don't know it, you can change/set it.

R.

no I know the pwd and connected too:

oracle@vmoracle:oracle$ export ORACLE_SID=prod
oracle@vmoracle:oracle$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on Fri Apr 23 11:09:25 2010

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> conn sys as sysdba
Enter password:
Connected.
SQL>

'as sysdba' is a special flag to sql*plus.  As soon as Oracle sees that, you connect as sys.  you can verify this sith some non-existent user:  sqlplus fred/flintstone as sysdba

in the example above:
SQL> conn sys as sysdba
Enter password:

When prompted type in: slightwv  and see what happens.

emca still needs the official SYS password.  This is not blank.  You need to know what is is set to.

ok just an update to all those participated, I was able to get this message:

oracle@vmoracle:scripts$ emca -config dbcontrol db -repos create -respFile emca_config.txt

STARTED EMCA at Apr 23, 2010 11:42:02 AM
EM Configuration Assistant, Version 11.1.0.7.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
Apr 23, 2010 11:42:04 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /dbms/app/oracle/cfgtoollogs/emca/PROD/emca_2010_04_23_11_42_02.log.
Apr 23, 2010 11:42:05 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Apr 23, 2010 11:44:53 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Apr 23, 2010 11:44:55 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Listener is not up. Start the Listener and run EM Configuration Assistant again .
Refer to the log file at /dbms/app/oracle/cfgtoollogs/emca/PROD/emca_2010_04_23_11_42_02.log for more details.
Could not complete the configuration. Refer to the log file at /dbms/app/oracle/cfgtoollogs/emca/PROD/emca_2010_04_23_11_42_02.log for more details.
oracle@vmoracle:scripts$

where as listener is running ... see this

oracle@vmoracle:scripts$ lsnrctl status

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 23-APR-2010 11:50:10

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vmpawpaw)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.1.0.7.0 - Production
Start Date                23-APR-2010 07:31:20
Uptime                    0 days 4 hr. 18 min. 50 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /dbms/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File         /dbms/app/oracle/diag/tnslsnr/vmoracle/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=198.10.20.78)(PORT=1521)))
Services Summary...
Service "hyper" has 1 instance(s).
  Instance "hyper", status UNKNOWN, has 1 handler(s) for this service...
Service "prod" has 1 instance(s).
  Instance "prod", status UNKNOWN, has 1 handler(s) for this service...
Service "rman" has 1 instance(s).
  Instance "rman", status UNKNOWN, has 1 handler(s) for this service...
Service "t11" has 1 instance(s).
  Instance "t11", status UNKNOWN, has 1 handler(s) for this service...
Service "webprod" has 1 instance(s).
  Instance "webprod", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
oracle@vmoracle:scripts$

NOW, what next?

in the next log file, giving these errors:

CONFIG: SQLEngine created successfully and connected
Apr 23, 2010 11:44:55 AM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
CONFIG: ORA-01031: insufficient privileges

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01031: insufficient privileges

...

SEVERE: Listener is not up. Start the Listener and run EM Configuration Assistant again .
Refer to the log file at /dbms/app/oracle/cfgtoollogs/emca/PROD/emca_2010_04_23_11_42_02.log for more details.
Apr 23, 2010 11:44:55 AM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Listener is not up. Start the Listener and run EM Configuration Assistant again .


please advice, how to fix this problem?

An the trick is...... ORACLE_SID!
When you use OEM data base control (not grid control) you can manipulate only one instance.
This is instance is pointed only and solely via its name in the above mentioned parameter.
If you have more then one instance on the machine, you have to change the value in this parameter.

yes you are right, it is not connecting as sys ... why so, I've changed the pwd and then trying to connect from my desktop ... for other db it worked, but not for prod

please assist, what I'm doing wrong here:

C:\Documents and Settings\el123>sqlplus /nolog

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Apr 23 15:43:30 2010

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

SQL> conn sys/<sysPassword>@prod as sysdba
ERROR:
ORA-01031: insufficient privileges


SQL> conn sys/<sysPassword>@webprod as sysdba
Connected.
SQL>

sorry ... totally my fault ... the simple orapw file ... :-(

gurus ... still got the same error ... No Listener

where as I'm able to connect from my desktop

and also I was able to cleanly drop the repository ... and when creating again, got this error ...

INFO: Repository successfully created
Apr 23, 2010 4:01:27 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Listener is not up. Start the Listener and run EM Configuration Assistant again .
Refer to the log file at /dbms/app/oracle/cfgtoollogs/emca/PROD/emca_2010_04_23_15_58_36.log for more details.

please suggest, now what is wrong or either my mistake :-(

What does /dbms/app/oracle/cfgtoollogs/emca/PROD/emca_2010_04_23_15_58_36.log  say?

There should be some entries that help point to the problem.

No Listener ... weird

Apr 23, 2010 4:01:27 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
CONFIG: ORA-12541: TNS:no listener

...

Apr 23, 2010 4:01:27 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Listener is not up. Start the Listener and run EM Configuration Assistant again .
Refer to the log file at /dbms/app/oracle/cfgtoollogs/emca/PROD/emca_2010_04_23_15_58_36.log for more details.
Apr 23, 2010 4:01:27 PM oracle.sysman.emcp.EMConfig perform

... :-(
please assist, thanks.

I'm not sure what the Windows sqlplus test was showing since you might not have been connecting to what you thing you were and weren't on the database server.

>>Apr 23, 2010 4:01:27 PM oracle.sysman...

The log didn't have any connect type information about what server/listener it was trying to find?

Also, I thought we changed all the HOST information to use IP Address.  Confirm the tnsnames.ora and listener.ora doesn't have any server names in them.

sorry, it was still the virtual name, not the IP address, just changed it to IP address, dropping the existing one and then will try to recreate the repository.

same error ... :-(

INFO: Repository successfully created
Apr 26, 2010 10:47:08 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Listener is not up. Start the Listener and run EM Configuration Assistant again .
Refer to the log file at /dbms/app/oracle/cfgtoollogs/emca/PROD/emca_2010_04_26_10_44_09.log for more details.
Could not complete the configuration. Refer to the log file at /dbms/app/oracle/cfgtoollogs/emca/PROD/emca_2010_04_26_10_44_09.log for more details.

emca_2010_04_26_10_44_09.log  doesn't have any attempted connect information in it?

same error, from this same file:

CONFIG: SQLEngine created successfully and connectedApr 26, 2010 10:47:08 AM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControlCONFIG: ORA-12541: TNS:no listener

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12541: TNS:no listener

...

Apr 26, 2010 10:47:08 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Listener is not up. Start the Listener and run EM Configuration Assistant again .
Refer to the log file at /dbms/app/oracle/cfgtoollogs/emca/PROD/emca_2010_04_26_10_44_09.log for more details.
Apr 26, 2010 10:47:08 AM oracle.sysman.emcp.EMConfig perform

That's all that's in the file?

Have you restarted the listener? Do that and try again.

R.

here is the complete file attached
emca-2010-04-26-10-44-09.log

same problem ...

INFO: Repository successfully created
Apr 26, 2010 11:53:23 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Listener is not up. Start the Listener and run EM Configuration Assistant again .
Refer to the log file at /dbms/app/oracle/cfgtoollogs/emca/PROD/emca_2010_04_26_11_50_34.log for more details.
Could not complete the configuration. Refer to the log file at /dbms/app/oracle/cfgtoollogs/emca/PROD/emca_2010_04_26_11_50_34.log for more details.
oracle@vmoracle:scripts$ tnsping prod

TNS Ping Utility for Linux: Version 11.1.0.7.0 - Production on 26-APR-2010 11:54:44

Copyright (c) 1997, 2008, Oracle.  All rights reserved.

Used parameter files:
/dbms/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = vmpawpaw)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = prod)))
OK (10 msec)
oracle@vmoracle:scripts$

with ip address it was not working ... not even tnsping

Is there some kind of NAT'ing happening on your network? I think this may be the case if IP address does not work.

Also, your test shows prod instance. I thought you were working on hyper instance?

R.

no its prod

>>with ip address it was not working

That could be a problem.  If the IP address for the linux box is static, and you are logged into the unix box and it still doesn't work, you have some configuration issues.

I'm not sure if we covered this in your other question or not, try the loopback ip address in the Oracle config files: 127.0.0.1

it is already there ...

127.0.0.1       localhost

>>it is already there ...

That looks like the /etc/hosts entry.  I was wanting you to use that ip address in the Oracle config files.  The tnsnames.ora and listener.ora files.

oops ... how to do this, can you please ... thanks

can you please tell, how to do this, I've to fix this dbconsole issue, otherwise have to recreate the db, using dbca again ... need assistance.

thanks a lot!

In your tnsnames.ora and listener.ora file replace all entries for HOST= to use 127.0.0.1

then restart the listener:
lsnrctl stop
lsnrctl start

Post the results of the start and a tnsping of prod.

thank you Sir ... will do this and update

not working, when changed it to 127.0.0.1
can not tnsping, neither listener stop ...

oracle@vmoracle:scripts$ tnsping prod

TNS Ping Utility for Linux: Version 11.1.0.7.0 - Production on 26-APR-2010 14:04:16

Copyright (c) 1997, 2008, Oracle.  All rights reserved.

Used parameter files:
/dbms/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = prod)))
TNS-12541: TNS:no listener
oracle@vmoracle:scripts$ tnsping PROD

oracle@vmoracle:scripts$ lsnrctl stop

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 26-APR-2010 14:05:32

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused

now what to try?
what exactly is the problem ... here?

I see two stop attempts, no start attempt:  lsnrctl start

listener is running and tnsping is working ... but don't know why at the time of creating repository, it couldn't find listener

>>listener is running and tnsping is working
You say that but when you tried to stop it above you got: TNS-00511: No listener

please post the output of the following commands from the Linux server:
lsnrctl status
tnsping prod

If possible also provide the output of a 'set' command from the linux prompt.  Please note this might contain some sensitive data so please make sure it doesn't before you post it.