Home » RDBMS Server » Server Administration » Strange Trouble with 10g R2 EM
icon5.gif  Strange Trouble with 10g R2 EM [message #231720] Wed, 18 April 2007 04:26 Go to next message
saifeesl
Messages: 4
Registered: April 2007
Junior Member
Hi group

i have installed Oracle 10g R2 10.2.0.1, with windows 2003 std server sp2,

With EM - its connects using sys user

showing first page with

Database Instace Down - Red Arrow Mark Down
Listener Down - Red Arrow Mark Down
Agent Connection to Instance Down - Red Arrow Mark Down

but when i reconfigure listener from NETCA its allow to configure properly, TNS Name configure properly.

LSNRCTL shows listener started and working,

i am able to connect through sql*plus using

sys/password@sid as sysdba
system/password@sid

showing error at EM
Failed to connect to database instance: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach).

Help appriciated
Re: Strange Trouble with 10g R2 EM [message #232418 is a reply to message #231720] Fri, 20 April 2007 07:53 Go to previous messageGo to next message
kamkan
Messages: 27
Registered: April 2007
Location: Chennai, INDIA
Junior Member
Hi,
Do u have multiple homes in ur box? Also check the TNS_ADMIN entry pointing correct location.
Re: Strange Trouble with 10g R2 EM [message #232540 is a reply to message #232418] Sat, 21 April 2007 01:24 Go to previous messageGo to next message
saifeesl
Messages: 4
Registered: April 2007
Junior Member
hi

yes it was there..but i have removed another home, using DBCA, restarted server and this trouble started...

now another problem is shown by EM is

its displays

Database instace is down
EM shows, there is not listener

but i m able to log in by Sys, System and the users credentials..

i have set the reg entry for proper SID (ORACLE_SID = MYSID)
lsnrctl shows listener working
able to log in using SQL plus
tns entry making connection for users
EM administration panel shows all tablespaces, tables, users etc.. all..

so, what is being shown by EM and the way database allow to work on is contradiction..

still EM shows ORA-12505 error..

please help me get it resovled...

[Updated on: Sat, 21 April 2007 01:25]

Report message to a moderator

Re: Strange Trouble with 10g R2 EM [message #232560 is a reply to message #232540] Sat, 21 April 2007 04:03 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
http://dbataj.blogspot.com/2007/02/ora-12505.html

and if still problem not solve then recreate EM respository.

regards
Taj
Re: Strange Trouble with 10g R2 EM [message #232600 is a reply to message #232560] Sat, 21 April 2007 23:48 Go to previous messageGo to next message
saifeesl
Messages: 4
Registered: April 2007
Junior Member
hi mohd taj

thanks for your reply..
i have checked the parameters, there is no other names for DB or services..

its matching, i m able to connect using system/mypassword@servicename

now i think the only option is left for me to rebuild the repository, just like to ask whether recreating EM repository will not harm the database.

thanks
Re: Strange Trouble with 10g R2 EM [message #232604 is a reply to message #232600] Sun, 22 April 2007 02:05 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
now i think the only option is left for me to rebuild the repository, just like to ask whether recreating EM repository will not harm the database.

NOT AT ALL.

but better if you do that work on off peak hours.

emca -config dbcontrol db -repos recreate




Regards
Taj
Previous Topic: Uninstalling 10gR2
Next Topic: Check view consists of which tables
Goto Forum:
  


Current Time: Wed Dec 07 03:19:43 CST 2016

Total time taken to generate the page: 0.16608 seconds