OraFAQ Forum: Enterprise Manager » Status Pending

Home » RDBMS Server » Enterprise Manager » Status Pending

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Status Pending [message #253792]

Tue, 24 July 2007 17:46

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

Report message to a moderator

Re: Status Pending [message #253797 is a reply to message #253792]

Tue, 24 July 2007 18:11

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Check the services for DBCONSOLE.
Restart service and then try it.

Report message to a moderator

Re: Status Pending [message #253972 is a reply to message #253797]

Wed, 25 July 2007 07:13

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 13671 times)

Report message to a moderator

Re: Status Pending [message #254042 is a reply to message #253972]

Wed, 25 July 2007 10:45

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

Report message to a moderator

Re: Status Pending [message #254058 is a reply to message #253972]

Wed, 25 July 2007 11:59

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Check Metalink. It address several issues regarding your problem.

Report message to a moderator

Re: Status Pending [message #254121 is a reply to message #254042]

Wed, 25 July 2007 15:57

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 3474 times)

Report message to a moderator

Re: Status Pending [message #254124 is a reply to message #254058]

Wed, 25 July 2007 16:01

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

Report message to a moderator

Re: Status Pending [message #254125 is a reply to message #254124]

Wed, 25 July 2007 16:13

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

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

Report message to a moderator

Re: Status Pending [message #256426 is a reply to message #254769]

Sat, 04 August 2007 12:47

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

Report message to a moderator

Re: Status Pending [message #256448 is a reply to message #256426]

Sat, 04 August 2007 16:36

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Whats your system RAM?

Report message to a moderator

Re: Status Pending [message #256465 is a reply to message #256426]

Sat, 04 August 2007 23:39

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

Report message to a moderator

Re: Status Pending [message #256802 is a reply to message #256465]

Mon, 06 August 2007 13:39

Creems
Messages: 70
Registered: July 2007
Location: Johannesburg

Member

I have attached it.

Regards,

Cherish

Attachment: emagent.trc.txt
(Size: 48.18KB, Downloaded 3792 times)

Report message to a moderator

Re: Status Pending [message #256803 is a reply to message #256448]

Mon, 06 August 2007 13:39

Creems
Messages: 70
Registered: July 2007
Location: Johannesburg

Member

My system RAM is 1G.

Report message to a moderator

Re: Status Pending [message #256804 is a reply to message #256465]

Mon, 06 August 2007 13:40

Creems
Messages: 70
Registered: July 2007
Location: Johannesburg

Member

Here is the other one.

Cherish

Attachment: emoms.trc.txt
(Size: 11.68KB, Downloaded 2888 times)

Report message to a moderator

Re: Status Pending [message #256878 is a reply to message #256804]

Mon, 06 August 2007 23:58

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

Report message to a moderator

Re: Status Pending [message #257247 is a reply to message #256878]

Tue, 07 August 2007 21:05

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

Report message to a moderator

Re: Status Pending [message #257251 is a reply to message #253792]

Tue, 07 August 2007 21:26

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.

Report message to a moderator

Re: Status Pending [message #257278 is a reply to message #257251]

Tue, 07 August 2007 23:49

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

Report message to a moderator

Re: Status Pending [message #257624 is a reply to message #257251]

Wed, 08 August 2007 16:12

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

Report message to a moderator

Re: Status Pending [message #257625 is a reply to message #257278]

Wed, 08 August 2007 16:14

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

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

Report message to a moderator

Re: Status Pending [message #257662 is a reply to message #257629]

Wed, 08 August 2007 23:31

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 2743 times)

Report message to a moderator

Re: Status Pending [message #257682 is a reply to message #257662]

Thu, 09 August 2007 00:25

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

Creems
Messages: 70
Registered: July 2007
Location: Johannesburg

Member

Please you will teach me how to do that.

I dont know.

Cherish

Report message to a moderator

Re: Status Pending [message #257871 is a reply to message #257818]

Thu, 09 August 2007 07:05

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

Report message to a moderator

Re: Status Pending [message #257889 is a reply to message #257871]

Thu, 09 August 2007 07:38

Creems
Messages: 70
Registered: July 2007
Location: Johannesburg

Member

Thanks Taj.

I'll let you know how it went.

Stay blessed.

Cherish

Report message to a moderator

Re: Status Pending [message #257926 is a reply to message #257871]

Thu, 09 August 2007 11:10

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

Report message to a moderator

Re: Status Pending [message #257990 is a reply to message #257926]

Thu, 09 August 2007 14:14

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

Report message to a moderator

Re: Status Pending [message #509067 is a reply to message #257990]

Wed, 25 May 2011 15:54

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?

Report message to a moderator

Previous Topic:	Backup Reports Link Missing
Next Topic:	EM not showing LISTENER detail

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 00:37:33 CST 2025