Home » RDBMS Server » Enterprise Manager » Cant Connect to database thru Standalone Oracle Enterprise Manager
Cant Connect to database thru Standalone Oracle Enterprise Manager [message #215630] Tue, 23 January 2007 05:12 Go to next message
kzaf
Messages: 3
Registered: January 2007
Junior Member
Hi,

I am trying to connect to a database thru Oracle Enterprise Manager Standalone with no success. In the database tree i am seeing the available databases , from TNSNAMES, i select the database that i want to connect. Then when i am typing user name and password i press OK button in Database Connect Information with no success. No error nothing !!!

Regards
Re: Cant Connect to database thru Standalone Oracle Enterprise Manager [message #215641 is a reply to message #215630] Tue, 23 January 2007 05:32 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You may want to check for any logs in $ORACLE_HOME/sysman/log and consider Activating Logging and Tracing.
Re: Cant Connect to database thru Standalone Oracle Enterprise Manager [message #215652 is a reply to message #215641] Tue, 23 January 2007 06:08 Go to previous messageGo to next message
kzaf
Messages: 3
Registered: January 2007
Junior Member
thank you for the information regarding the trace
Here is the error that i receive

java.lang.NullPointerException:
at oracle.net.nl.NVPair.setAtom(NVPair.java)
at oracle.net.nl.NVFactory._readNVPair(NVFactory.java)
at oracle.net.nl.NVFactory.createNVPair(NVFactory.java)
at oracle.net.nl.NLParamParser.addNLPListElement(NLParamParser.java)
at oracle.net.nl.NLParamParser.<init>(NLParamParser.java)
at oracle.sysman.vdb.VdbUtil.findInTNSFile(VdbUtil.java:756)
at oracle.sysman.vdb.VdbUtil.findInTNSNAMES(VdbUtil.java:723)
at oracle.sysman.vdb.VdbUtil.buildConnectDescriptor(VdbUtil.java:272)
at oracle.sysman.vdb.VdbSession.buildConnectionInformation(VdbSession.ja
va:4122)
at oracle.sysman.vdb.VdbSession.establishConnection(VdbSession.java:1249
)
at oracle.sysman.vdb.VdbSession.<init>(VdbSession.java:763)
at oracle.sysman.vdb.VdbAutoCommitSession.<init>(VdbAutoCommitSession.ja
va:266)
at oracle.sysman.vdb.VdbSessionFactory.getNewAutoCommitSession(VdbSessio
nFactory.java:1206)
at oracle.sysman.vdb.VdbSessionFactory.getAutoCommitSession(VdbSessionFa
ctory.java:1118)
at oracle.sysman.vbo.VboDBServerFat.getManagedSession(VboDBServerFat.jav
a:417)
at oracle.sysman.vth.VthSessionManager._getSessionFromFactory(VthSession
Manager.java:261)
at oracle.sysman.vth.VthSessionManager.onConnectDialogOk(VthSessionManag
er.java:446)
at oracle.sysman.vtaGallery.dbConnect.VtaDbConnectDialog._actionPerforme
d(VtaDbConnectDialog.java:1505)
at oracle.sysman.vtaGallery.dbConnect.VtaDbConnectDialogExecutor.run(Vta
DbConnectDialog.java:1847)
at oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.ja
va:271)
Re: Cant Connect to database thru Standalone Oracle Enterprise Manager [message #215657 is a reply to message #215652] Tue, 23 January 2007 06:27 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
That error message doesn't help much. Some questions though:

* Can you confirm what version of OEM and what platform you are using?
* Has this ever worked for you?
* Can you connect to the database with SQL*Plus?
* Can you delete/rename the OEM logs and then ensure that there are no OEM java processes running and then post the logs created when you relaunch OEM and try to connect?
Re: Cant Connect to database thru Standalone Oracle Enterprise Manager [message #215659 is a reply to message #215657] Tue, 23 January 2007 06:40 Go to previous messageGo to next message
kzaf
Messages: 3
Registered: January 2007
Junior Member
1.Oracle Enterprise Manager Version 9.2.0.1.0
Client has Windows XP, Server Linux Red Hut
2.No is the first time that we trying to work
3.With SQL Plus, TOAD & PLSQL Developer i connect to database without any problem
4.I clear the logs, check the processes and still there is a problem
Re: Cant Connect to database thru Standalone Oracle Enterprise Manager [message #215664 is a reply to message #215659] Tue, 23 January 2007 07:27 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
I would have expeted to see more detailed errors messages with tracing enabled?
Re: Cant Connect to database thru Standalone Oracle Enterprise Manager [message #223101 is a reply to message #215630] Wed, 07 March 2007 09:42 Go to previous message
maple_shaft
Messages: 1
Registered: March 2007
Location: Pittsburgh
Junior Member
Hi,

I am experiencing the exact same problem.

Any Help?
Previous Topic: shutdown EM 10g - 500 Internal Server Error
Next Topic: 10g EM Grid Control Connectivity with Agent
Goto Forum:
  


Current Time: Thu Dec 05 17:17:10 CST 2024