Home » RDBMS Server » Enterprise Manager » Status Pending
Status Pending [message #253792] Tue, 24 July 2007 17:46 Go to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Hello,

can anyone please help me, I have an Orcale 10g installed on windows XP. Actually I can access my DB via SQL Plus but I cant acces it through the EM.

It always gives me the page
Status: Status Pending
Status Pending Since: Unavailable
Last Know State.

Please what could be wrong?

Thanks in good anticipation.

Cherish
Re: Status Pending [message #253797 is a reply to message #253792] Tue, 24 July 2007 18:11 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Check the services for DBCONSOLE.
Restart service and then try it.
Re: Status Pending [message #253972 is a reply to message #253797] Wed, 25 July 2007 07:13 Go to previous messageGo to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Thanks. I did tried that but it's still the same thing.
And when I clicked on Startup/Shutdown ... then start it
it tells me the database is open but I cannot go to the
home page ... it refers me back to the signing in page.

Any more advice please?

Infact, I'm uploading my alert log perhaps you can tell from
there.

Regards,

Cherish
  • Attachment: AlertLOG.htm
    (Size: 85.79KB, Downloaded 13132 times)
Re: Status Pending [message #254042 is a reply to message #253972] Wed, 25 July 2007 10:45 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
post the result of this from command prompt

emctl status
emctl stop dbconsole
emctl start dbconsole
Re: Status Pending [message #254058 is a reply to message #253972] Wed, 25 July 2007 11:59 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check Metalink. It address several issues regarding your problem.
Re: Status Pending [message #254121 is a reply to message #254042] Wed, 25 July 2007 15:57 Go to previous messageGo to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Here is it.

Thanks for your time.

regards,

Cherish
  • Attachment: emctl.txt
    (Size: 1.22KB, Downloaded 2950 times)
Re: Status Pending [message #254124 is a reply to message #254058] Wed, 25 July 2007 16:01 Go to previous messageGo to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Actually, i dont have an access to MetaLink as i am not
working yet.

And i tried to create one today ... it was asking me some
stuffs i dont even know ... relating to company's stuffs.

Or can i still create one? please let me know.

Thanks and regards,

Cherish
Re: Status Pending [message #254125 is a reply to message #254124] Wed, 25 July 2007 16:13 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
CherishMe wrote on Wed, 25 July 2007 15:01
Actually, i dont have an access to MetaLink as i am not
working yet.

And i tried to create one today ... it was asking me some
stuffs i dont even know ... relating to company's stuffs.

Or can i still create one? please let me know.

Thanks and regards,

Cherish


No They charge you yearly for SUPPORT.Its not FREE.

[Updated on: Wed, 25 July 2007 16:13]

Report message to a moderator

Re: Status Pending [message #254769 is a reply to message #254125] Sat, 28 July 2007 01:16 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
For above error there is couple of reason...
http://dbataj.blogspot.com/search/label/EMCA

just go through above link for related and many frequent error of enterprise manager.

Regards
Taj
Re: Status Pending [message #256426 is a reply to message #254769] Sat, 04 August 2007 12:47 Go to previous messageGo to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Thanks Taj.

But I'm still not able to solve this problem. I cant access the EM home page.

Regards,

Cherish
Re: Status Pending [message #256448 is a reply to message #256426] Sat, 04 August 2007 16:36 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Whats your system RAM?
Re: Status Pending [message #256465 is a reply to message #256426] Sat, 04 August 2007 23:39 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Can you post last few lines from emoms.trc or emagent.trc files.

located : $ORACLE_HOME/db_1/hostname_sid/sysman/log

Regards
Taj
Re: Status Pending [message #256802 is a reply to message #256465] Mon, 06 August 2007 13:39 Go to previous messageGo to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
I have attached it.

Regards,

Cherish
Re: Status Pending [message #256803 is a reply to message #256448] Mon, 06 August 2007 13:39 Go to previous messageGo to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
My system RAM is 1G.
Re: Status Pending [message #256804 is a reply to message #256465] Mon, 06 August 2007 13:40 Go to previous messageGo to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Here is the other one.


Cherish
  • Attachment: emoms.trc.txt
    (Size: 11.68KB, Downloaded 2350 times)
Re: Status Pending [message #256878 is a reply to message #256804] Mon, 06 August 2007 23:58 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

According you emagent.trc,emoms.trc file you should check all packages in SYSMAN schema is valid status if not then first COMPILE all invalid objects in SYSMAN schema.

You can use
---> Create manually Compilation scripts.
---> dbms_utility.compile_schema('SCHEMA_NAME');


Regards
Taj
Re: Status Pending [message #257247 is a reply to message #256878] Tue, 07 August 2007 21:05 Go to previous messageGo to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Dear Taj,

Thanks for all your effort, I do appreciate a lot.

Actually when I checked through the EM manager, I discovered that these package bodies were INVALID and I tried to run the
PL/SQL utility to compile them through the SQL*Plus ... it all say procedure successful but nothing changed, I mean the status is still INVALID.

These 9 package bodies were INVALID:
EMD_BCN_ADMIN, EMD_NOTIFICATION, EMD_SCHEMA, GMT_BLACKOUT_ENGINE, MGMT_CREDENTIAL, MGMT_GLOBAL, MGMT_JOB_ENGINE, MGMT_TARGET, MGMT_VIEW_PRIV

I also tried to compile it through the EM manager it brings some compilation errors and most of the errors I named below:

-- Line # = 509 Column # = 22 Error Text = PLS-00201: identifier 'DBMS_OBFUSCATION_TOOLKIT' must be declared
-- Line # = 509 Column # = 5 Error Text = PL/SQL: Statement ignored.

From what I saw on the page there is an Edit Package button, how do i edit this and recompile it?


Regards,

Cherish
Re: Status Pending [message #257251 is a reply to message #253792] Tue, 07 August 2007 21:26 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I tried to run the PL/SQL utility to compile them through the SQL*Plus ...
>it all say procedure successful but nothing changed, I mean the status is still INVALID.

Please use CUT & PASTE to show us when you did.
I use (/ as sysdba) "ultrp" to recompile INVALID packages.
Re: Status Pending [message #257278 is a reply to message #257251] Tue, 07 August 2007 23:49 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
-- Line # = 509 Column # = 22 Error Text = PLS-00201: identifier 'DBMS_OBFUSCATION_TOOLKIT' must be declared

Under which database user you run compile script ?

As "Ana" said you have to use "sys" user for run UTLRP.sql script.

Regards
Taj
Re: Status Pending [message #257624 is a reply to message #257251] Wed, 08 August 2007 16:12 Go to previous messageGo to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Hello,

I logged in to SQL*PLUS /as sysdba and ran it like this

dbms_utility.compile_schema('EMD_BCN_ADMIN');

it outputs: Procedure succesfully completed


But today i still run the ultrp.sql and later check and still found out that those INVALID objects are still INVALID.


Please where do i go from here. The same thing happens to the new database i just created.

Regards,

Cherish
Re: Status Pending [message #257625 is a reply to message #257278] Wed, 08 August 2007 16:14 Go to previous messageGo to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Hello Taj,

I logged in to SQL*PLUS /as sysdba and ran it like this

dbms_utility.compile_schema('EMD_BCN_ADMIN');

it outputs: Procedure succesfully completed


But today i still run the ultrp.sql and later check and still found out that those INVALID objects are still INVALID.


Please where do i go from here. The same thing happens to the new database i just created.

Regards,

Cherish

[Edit: Name]

[Updated on: Thu, 09 August 2007 00:26] by Moderator

Report message to a moderator

Re: Status Pending [message #257629 is a reply to message #257625] Wed, 08 August 2007 16:34 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Post the result of this querry.
Did you moved or droped tables?
SQL> 1  select OBJECT_NAME,STATUS
           2  from dba_objects
           3  where status='INVALID'
SQL> /

OBJECT_NAME    STATUS
Re: Status Pending [message #257662 is a reply to message #257629] Wed, 08 August 2007 23:31 Go to previous messageGo to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Here is it. Actually, i did ran that query only on package bodies.

But here's the full one attached.


regards,

Cherish.
  • Attachment: report.txt
    (Size: 2.70KB, Downloaded 2211 times)
Re: Status Pending [message #257682 is a reply to message #257662] Thu, 09 August 2007 00:25 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Try to recreate EM repository again.
And your using "OLAP" feature ?
Regards
Taj

[Updated on: Thu, 09 August 2007 00:27]

Report message to a moderator

Re: Status Pending [message #257818 is a reply to message #257682] Thu, 09 August 2007 04:47 Go to previous messageGo to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Please you will teach me how to do that.

I dont know.

Cherish
Re: Status Pending [message #257871 is a reply to message #257818] Thu, 09 August 2007 07:05 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
go through below link and fellow step by step ...

http://dbataj.blogspot.com/2007/01/oc4j-configuration-issue.html


Regards
Taj
Re: Status Pending [message #257889 is a reply to message #257871] Thu, 09 August 2007 07:38 Go to previous messageGo to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Thanks Taj.

I'll let you know how it went.

Stay blessed.

Cherish
Re: Status Pending [message #257926 is a reply to message #257871] Thu, 09 August 2007 11:10 Go to previous messageGo to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Dear Tag,

Please don't mind me. I'm a learner in this world, actually I did go through your blog but I still can't drop and re-create the repository.

Will you please write me the code to drop the repository or how to go about it?

Thanks.

Cherish
Re: Status Pending [message #257990 is a reply to message #257926] Thu, 09 August 2007 14:14 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
Dropping and Recreating the Management Repository


http://download-west.oracle.com/docs/pdf/B12013_01.pdf
Re: Status Pending [message #509067 is a reply to message #257990] Wed, 25 May 2011 15:54 Go to previous message
ryanpj
Messages: 3
Registered: May 2011
Junior Member
At the odd chance you folks are still active ...

I have the same issue as above whereby my database seems to be up and running (ie. I can connect to it via sqlplus, etc.) but when viewing the database page, in OEM, it tells me "Status Pending".

I did, as someone mentioned above, check for invalid objects in the sys schema and, indeed, there are invalid objects there. Is it ok to recompile these objects to make everything valid?

Not sure if that will bring my status back for the DB home page or not. Any new insights on this one?
Previous Topic: Backup Reports Link Missing
Next Topic: EM not showing LISTENER detail
Goto Forum:
  


Current Time: Thu Mar 28 17:48:41 CDT 2024