Oracle 11g: dbconsole ... giving tough time

Hi,

When db/s created using dbca, all good, dbconsole is working and can check its status too.

But now, we have changed one of our db from hyper9 to hyper, and now when trying to even recreate/drop repository, giving errors.

And also for a newly created db (manually), it creates repository, but not starting or not doing any thing else.

Checking the metalink note: 555218.1

When checked this directory:

<ORACLE_HOME>/oc4j/j2ee/OC4J_DBConsole_<HOSTNAME>_<DBNAME>
<ORACLE_HOME>/<HOSTNAME>_<DBNAME>

There are no directories present for any of these problematic databases, the one which name has been changed is not there too, and none of the newly created db too (created manually).

Can any one assist, what exactly is the problem, the existing DBA here is mentioning some thing related to ORACLE_HOSTNAME parameter, I've tried to set or even unset ... but no help.

Please assist, what I'm missing or what exactly is the problem.

Thanks in advance.
el123Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

schwertnerCommented:
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.
0
el123Author Commented:
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?

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


Giving or not giving errors? What is true? What kind of errors?
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

el123Author Commented:
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?
0
Richard OlutolaConsultantCommented:
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.
0
schwertnerCommented:
Changing the DB nam or the host name or IP "distroys" the DB console.
In this case the DBA has to recreate the repository.
0
el123Author Commented:
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?
0
Richard OlutolaConsultantCommented:
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.
0
el123Author Commented:
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.
0
el123Author Commented:
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.
0
Richard OlutolaConsultantCommented:
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.
0
el123Author Commented:
linux ... connected on the box, using sys ... and no issues at all
0
el123Author Commented:
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>
0
el123Author Commented:
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.
0
el123Author Commented:
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 :-(
0
Richard OlutolaConsultantCommented:
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.


0
el123Author Commented:
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>
0
slightwv (䄆 Netminder) Commented:
'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.

0
el123Author Commented:
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?
0
el123Author Commented:
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?
0
Richard OlutolaConsultantCommented:
Try and go through this properly to avoid headache in future.

I suggest you successfully drop FIRST. I don't believe you've done that. See the following example:

 
[oracle@kilo ~]$ emca -deconfig dbcontrol db -repos drop  
   
STARTED EMCA at 27-May-2008 00:41:26  
EM Configuration Assistant, Version 10.2.0.1.0 Production  
Copyright (c) 2003, 2005, Oracle.  All rights reserved.  
   
Enter the following information:  
Database SID: mars  [here you must supply SID as shown]
Listener port number: 1521  [here you  must supply listener port as shown]
Password for SYS user:   [here  you  must supply SYS user password]
Password for SYSMAN user:  [here  you   must supply SYSMAN user password]
   
Do you wish to continue? [yes(Y)/no(N)]: Y  
   
27-May-2008 00:44:16 oracle.sysman.emcp.EMConfig perform  
INFO: This operation is being logged at /u01/app/oracle/home/db/cfgtoollogs/emca/emca_2008-05-27_12-41-26-AM.log.  
27-May-2008 00:44:17 oracle.sysman.emcp.EMConfig perform  
SEVERE: Database instance unavailable.  
Refer to the log file at /u01/app/oracle/home/db/cfgtoollogs/emca/emca_2008-05-27_12-41-26-AM.log for more details.  
Could not complete the configuration. Refer to the log file at /u01/app/oracle/home/db/cfgtoollogs/emca/emca_2008-05-27_12-41-26-AM.log for more details.  


See above I got an error 'SEVERE: Database instance unavailable.'
This was because Listener was not up. I started the listener and repeated the process and it succeeded.

Please try dropping first before trying to recreate.

R.
0
schwertnerCommented:
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.
0
el123Author Commented:
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>
0
el123Author Commented:
sorry ... totally my fault ... the simple orapw file ... :-(
0
el123Author Commented:
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 :-(
0
slightwv (䄆 Netminder) Commented:
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.
0
el123Author Commented:
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.
0
slightwv (䄆 Netminder) Commented:
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.
0
el123Author Commented:
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.
0
el123Author Commented:
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.
0
slightwv (䄆 Netminder) Commented:
emca_2010_04_26_10_44_09.log  doesn't have any attempted connect information in it?
0
el123Author Commented:
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
0
slightwv (䄆 Netminder) Commented:
That's all that's in the file?
0
Richard OlutolaConsultantCommented:
Have you restarted the listener? Do that and try again.

R.
0
el123Author Commented:
here is the complete file attached
emca-2010-04-26-10-44-09.log
0
el123Author Commented:
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$
0
el123Author Commented:
with ip address it was not working ... not even tnsping
0
Richard OlutolaConsultantCommented:
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.
0
el123Author Commented:
no its prod
0
slightwv (䄆 Netminder) Commented:
>>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

0
el123Author Commented:
it is already there ...

127.0.0.1       localhost
0
slightwv (䄆 Netminder) Commented:
>>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.
0
el123Author Commented:
oops ... how to do this, can you please ... thanks
0
el123Author Commented:
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!
0
slightwv (䄆 Netminder) Commented:
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.
0
el123Author Commented:
thank you Sir ... will do this and update
0
el123Author Commented:
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

0
el123Author Commented:
now what to try?
what exactly is the problem ... here?
0
slightwv (䄆 Netminder) Commented:
I see two stop attempts, no start attempt:  lsnrctl start
0
el123Author Commented:
listener is running and tnsping is working ... but don't know why at the time of creating repository, it couldn't find listener
0
slightwv (䄆 Netminder) Commented:
>>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.
0
el123Author Commented:
First I would like to thank you ... first, Thank You slightwv and all, more to slightwv:

I'm able to create and start dbconsole

using these simple commands:
emca -deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos create

I tried on a different db and it worked fine, and then to this prod:

oracle@vmoracle:oracle$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.1.0.7.0
Copyright (c) 1996, 2008 Oracle Corporation.  All rights reserved.
https://vmpawpaw:5504/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ..... started.
------------------------------------------------------------------
Logs are generated in directory /dbms/app/oracle/product/11.1.0/db_1/vmpawpaw_prod/sysman/log
oracle@vmoracle:oracle$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.1.0.7.0
Copyright (c) 1996, 2008 Oracle Corporation.  All rights reserved.
https://vmpawpaw:5504/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /dbms/app/oracle/product/11.1.0/db_1/vmpawpaw_prod/sysman/log
oracle@vmoracle:oracle$

but now ... I think this is something else, giving timed out at my browser, and couldn't connect to dbconsole ... what can be the reason ?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
slightwv (䄆 Netminder) Commented:
>>https://vmpawpaw:5504/em/console/aboutApplication

Try the ipaddress from a linux prompt:

https://127.0.0.1:5504/em/console/aboutApplication

Might be a firewall/network config problem.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Linux Distributions

From novice to tech pro — start learning today.