OraFAQ Forum: Enterprise Manager » ERROR: SQLException null Resultset

Home » RDBMS Server » Enterprise Manager » ERROR: SQLException null Resultset (Oracle Grid Control 11g R1, Windows2003)

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

ERROR: SQLException null Resultset [message #508063]

Thu, 19 May 2011 04:39

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

Report message to a moderator

Re: ERROR: SQLException null Resultset [message #508075 is a reply to message #508063]

Thu, 19 May 2011 05:47

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So?

Regards
Michel

Report message to a moderator

Re: ERROR: SQLException null Resultset [message #508225 is a reply to message #508075]

Fri, 20 May 2011 00:57

perdesen
Messages: 2
Registered: May 2011
Location: Indonesia

Junior Member

You can help me for this problem

Regards
Decent

Report message to a moderator

Re: ERROR: SQLException null Resultset [message #508228 is a reply to message #508225]

Fri, 20 May 2011 01:03

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Did you investigate the "Possible reasons"?

Regards
Michel

Report message to a moderator

ERROR: SQLException null Resultset [message #508553 is a reply to message #508063]

Mon, 23 May 2011 02:20

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-

Report message to a moderator

Re: ERROR: SQLException null Resultset [message #508555 is a reply to message #508063]

Mon, 23 May 2011 02:31

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..

Report message to a moderator

Re: ERROR: SQLException null Resultset [message #508556 is a reply to message #508555]

Mon, 23 May 2011 02:37

ramoradba
Messages: 2457
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

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

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?

Report message to a moderator

Re: ERROR: SQLException null Resultset [message #508562 is a reply to message #508560]

Mon, 23 May 2011 03:33

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?

Report message to a moderator

Re: ERROR: SQLException null Resultset [message #508563 is a reply to message #508562]

Mon, 23 May 2011 03:48

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Investigate these reasons, did you do it?

Regards
Michel

Report message to a moderator

Re: ERROR: SQLException null Resultset [message #508569 is a reply to message #508563]

Mon, 23 May 2011 04:08

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:

Attachment: Oracle problem.png
(Size: 16.25KB, Downloaded 1716 times)

Report message to a moderator

Re: ERROR: SQLException null Resultset [message #508574 is a reply to message #508569]

Mon, 23 May 2011 04:35

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I can't download files.
Post inline what you did to address the 3 points.

Regards
Michel

Report message to a moderator

Re: ERROR: SQLException null Resultset [message #508575 is a reply to message #508569]

Mon, 23 May 2011 04:38

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

Confused

Report message to a moderator

Re: ERROR: SQLException null Resultset [message #508581 is a reply to message #508575]

Mon, 23 May 2011 05:02

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: ERROR: SQLException null Resultset [message #508584 is a reply to message #508581]

Mon, 23 May 2011 05:05

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..

Report message to a moderator

Re: ERROR: SQLException null Resultset [message #508590 is a reply to message #508584]

Mon, 23 May 2011 05:28

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: ERROR: SQLException null Resultset [message #519390 is a reply to message #508063]

Thu, 11 August 2011 11:46

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 .

Report message to a moderator

Previous Topic:	please tell me
Next Topic:	Grid Control Installation - 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 16:29:13 CST 2024