Home » RDBMS Server » Enterprise Manager » ERROR: SQLException null Resultset (Oracle Grid Control 11g R1, Windows2003)
icon4.gif  ERROR: SQLException null Resultset [message #508063] Thu, 19 May 2011 04:39 Go to next message
perdesen
Messages: 2
Registered: May 2011
Location: Indonesia
Junior Member

Hi All, Razz

I'm trying to install Enterprise Manager Grid Control 11gR1 - Windows2003 32.

On the "Connect to Oracle Database" step 5 when installing a new Enterprise Manager System,
I get an Error window that states:

"ERROR: SQLException null Resultset

Cause: Verifying whether database is valid for this install, using the given credentials has failed.

Possible Reasons:
1. Credentials provided may be incorrect
2. Listener may be down
3. Database may be down

Thank
Decent
Re: ERROR: SQLException null Resultset [message #508075 is a reply to message #508063] Thu, 19 May 2011 05:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So?

Regards
Michel
icon2.gif  Re: ERROR: SQLException null Resultset [message #508225 is a reply to message #508075] Fri, 20 May 2011 00:57 Go to previous messageGo to next message
perdesen
Messages: 2
Registered: May 2011
Location: Indonesia
Junior Member

You can help me for this problem

Regards
Decent
Re: ERROR: SQLException null Resultset [message #508228 is a reply to message #508225] Fri, 20 May 2011 01:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you investigate the "Possible reasons"?

Regards
Michel
ERROR: SQLException null Resultset [message #508553 is a reply to message #508063] Mon, 23 May 2011 02:20 Go to previous messageGo to next message
jacquet
Messages: 7
Registered: May 2011
Location: Singapore
Junior Member
Hi friends..
I'm about to install Enterprise Manager Grid Control 11gR1 - Windows2003 32.

On the "Connect to Oracle Database" step 5 when installing a new Enterprise Manager System,
I get an Error window that states:

"ERROR: SQLException null Resultset

Cause: Verifying whether database is valid for this install, using the given credentials has failed.

Possible Reasons:
1. Credentials provided may be incorrect
2. Listener may be down
3. Database may be down

What should i do to solve this problem?

Really really need your help.. (S.O.S)

Thanks, warm regard

-Jacquet-
Re: ERROR: SQLException null Resultset [message #508555 is a reply to message #508063] Mon, 23 May 2011 02:31 Go to previous messageGo to next message
jacquet
Messages: 7
Registered: May 2011
Location: Singapore
Junior Member
i have the same problem..
can anyone help me to solve this?
i really dun get the point..
what should i do?
Thanks..
Re: ERROR: SQLException null Resultset [message #508556 is a reply to message #508555] Mon, 23 May 2011 02:37 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
Did you investigate the "Possible reasons"?

Regards
Michel


Its not necessary to create another user/Account to ask the same question with the same IP Wink

[Updated on: Mon, 23 May 2011 02:38]

Report message to a moderator

Re: ERROR: SQLException null Resultset [message #508560 is a reply to message #508556] Mon, 23 May 2011 03:11 Go to previous messageGo to next message
jacquet
Messages: 7
Registered: May 2011
Location: Singapore
Junior Member
But we're not the same person..
and we just have the same problem..
can anyone help me out?
Re: ERROR: SQLException null Resultset [message #508562 is a reply to message #508560] Mon, 23 May 2011 03:33 Go to previous messageGo to next message
jacquet
Messages: 7
Registered: May 2011
Location: Singapore
Junior Member
The Possible reasons might be from
1. Credentials provided may be incorrect
2. Listener may be down
3. Database may be down

that's what the errors said..
what should i do?
Re: ERROR: SQLException null Resultset [message #508563 is a reply to message #508562] Mon, 23 May 2011 03:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Investigate these reasons, did you do it?

Regards
Michel
Re: ERROR: SQLException null Resultset [message #508569 is a reply to message #508563] Mon, 23 May 2011 04:08 Go to previous messageGo to next message
jacquet
Messages: 7
Registered: May 2011
Location: Singapore
Junior Member
In fact , at its localhost, database's already up..
here's the capture as follows:
Re: ERROR: SQLException null Resultset [message #508574 is a reply to message #508569] Mon, 23 May 2011 04:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I can't download files.
Post inline what you did to address the 3 points.

Regards
Michel
Re: ERROR: SQLException null Resultset [message #508575 is a reply to message #508569] Mon, 23 May 2011 04:38 Go to previous messageGo to next message
jacquet
Messages: 7
Registered: May 2011
Location: Singapore
Junior Member
I've investigated that Database and Listener have already started.
But i don't really get the point about the 1st possible reason.
All i think is why Grid can't connect to database? Confused
Re: ERROR: SQLException null Resultset [message #508581 is a reply to message #508575] Mon, 23 May 2011 05:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because:
Quote:
Possible Reasons:
1. Credentials provided may be incorrect
2. Listener may be down
3. Database may be down

Regards
Michel
Re: ERROR: SQLException null Resultset [message #508584 is a reply to message #508581] Mon, 23 May 2011 05:05 Go to previous messageGo to next message
jacquet
Messages: 7
Registered: May 2011
Location: Singapore
Junior Member
So?What should i do next after investigate those possible reasons and still there are no problems in database itself..
Re: ERROR: SQLException null Resultset [message #508590 is a reply to message #508584] Mon, 23 May 2011 05:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As I don't know what you checked and if it is correct and I can't know what you should investigate now.
From my point of view (which is what you posted inline) you are still at the very first step.

Regards
Michel
Re: ERROR: SQLException null Resultset [message #519390 is a reply to message #508063] Thu, 11 August 2011 11:46 Go to previous message
prjaiswa
Messages: 1
Registered: August 2011
Junior Member
I have seen similar issue :

The tool execute "select sysdate from dual " after connnecting to DB.
There was version incompatibility issue b/w installer and DB .
Previous Topic: please tell me
Next Topic: Grid Control Installation - 10g
Goto Forum:
  


Current Time: Thu Mar 28 17:05:01 CDT 2024