Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Oracle JDBC oracle.ons.SubscriptionException:

  
   Database Forums (Home) -> Java RSS
Next:  SQL Server 2005 Partioning Performance  
Author Message
sunkeunlee

External


Since: Apr 09, 2009
Posts: 1



(Msg. 1) Posted: Thu Apr 09, 2009 9:12 am
Post subject: Oracle JDBC oracle.ons.SubscriptionException:
Archived from groups: comp>lang>java>databases (more info?)
Hi,

I am writing Java application using JDBC to support Oracle RAC
database, but I got the following ONS related exception. Can anyone
tell me why I have this error?


Exception in thread "Thread-6" oracle.ons.SubscriptionException:
Subscription request timed out after 30000 millseconds. Possible
causes: OPMN may not be running, you may have an OPMN running in an
alternate ORACLE_HOME using duplicate port values, or OPMN may be
misconfigured.
at oracle.ons.SubscriptionNotification.waitForReply
(SubscriptionNotification.java:82)
at oracle.ons.ONS.addSubscriber(ONS.java:669)
at oracle.ons.Subscriber.realStartup(Subscriber.java:104)
at oracle.ons.Subscriber.<init>(Subscriber.java:80)
at
oracle.jdbc.pool.OracleRuntimeLoadBalancingEventHandlerThread$1.run
(OracleRuntimeLoadBalancingEventHandlerThread.java:74)
at java.security.AccessController.doPrivileged(Native Method)
at
oracle.jdbc.pool.OracleRuntimeLoadBalancingEventHandlerThread.run
(OracleRuntimeLoadBalancingEventHandlerThread.java:66)
Exception in thread "Thread-5" oracle.ons.SubscriptionException:
Subscription request timed out after 30000 millseconds. Possible
causes: OPMN may not be running, you may have an OPMN running in an
alternate ORACLE_HOME using duplicate port values, or OPMN may be
misconfigured.
at oracle.ons.SubscriptionNotification.waitForReply
(SubscriptionNotification.java:82)
at oracle.ons.ONS.addSubscriber(ONS.java:669)
at oracle.ons.Subscriber.realStartup(Subscriber.java:104)
at oracle.ons.Subscriber.<init>(Subscriber.java:80)
at oracle.jdbc.pool.OracleFailoverEventHandlerThread$1.run
(OracleFailoverEventHandlerThread.java:69)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.jdbc.pool.OracleFailoverEventHandlerThread.run
(OracleFailoverEventHandlerThread.java:61)

 >> Stay informed about: Oracle JDBC oracle.ons.SubscriptionException: 
Back to top
Login to vote
joe.weinstein

External


Since: Feb 26, 2009
Posts: 3



(Msg. 2) Posted: Thu Apr 09, 2009 10:49 am
Post subject: Re: Oracle JDBC oracle.ons.SubscriptionException: [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Apr 9, 9:12 am, wrote:
> Hi,
> I am writing Java application using JDBC to support Oracle RAC
> database, but I got the following ONS related exception. Can anyone
> tell me why I have this error?
>Possible
> causes: OPMN may not be running, you may have an OPMN running in an
> alternate ORACLE_HOME using duplicate port values, or OPMN may be
> misconfigured.

Have you verified whether the possibilities mentioned in the
error itself are not true? You are asking the driver to do FCF,
I guess, and that requires information from the RAC cluster,
via Oracle Notification Service. Is that running, and did you
give the driver the correct ONS info?
Joe

 >> Stay informed about: Oracle JDBC oracle.ons.SubscriptionException: 
Back to top
Login to vote
hotspring

External


Since: Apr 09, 2009
Posts: 1



(Msg. 3) Posted: Thu Apr 09, 2009 11:03 am
Post subject: Re: Oracle JDBC oracle.ons.SubscriptionException: [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Apr 9, 10:49 am, " "
wrote:
> On Apr 9, 9:12 am, wrote:
>
> > Hi,
> > I am writing Java application using JDBC to support Oracle RAC
> > database, but I got the following ONS related exception. Can anyone
> > tell me why I have this error?
> >Possible
> > causes: OPMN may not be running, you may have an OPMN running in an
> > alternate ORACLE_HOME using duplicate port values, or OPMN may be
> > misconfigured.
>
> Have you verified whether the possibilities mentioned in the
> error itself are not true? You are asking the driver to do FCF,
> I guess, and that requires information from the RAC cluster,
> via Oracle Notification Service. Is that running, and did you
> give the driver the correct ONS info?
> Joe

Yes, I think I correctly configured in Java side since I don't get
this exception all the time. During my test I got this exception
irregulary. Since my DBA set up the RAC, I don't know much about Orace
server side RAC set up but I found the followings; do you think this
may cause the problem? My testing RAC database uses two nodes but I
see ONS daemon is running on from only one node not from both. Is this
right?

Node 1

[oracle@rac1 ~]$ srvctl status nodeapps -n rac1

VIP is running on node: rac1

GSD is not running on node: rac1

Listener is not running on node: rac1

ONS daemon is not running on node: rac1



Node2

[oracle@rac1 ~]$ srvctl status nodeapps -n rac2

VIP is running on node: rac2

GSD is running on node: rac2

Listener is running on node: rac2

ONS daemon is running on node: rac2

[oracle@rac1 ~]$
 >> Stay informed about: Oracle JDBC oracle.ons.SubscriptionException: 
Back to top
Login to vote
joe.weinstein

External


Since: Feb 26, 2009
Posts: 3



(Msg. 4) Posted: Thu Apr 09, 2009 11:16 am
Post subject: Re: Oracle JDBC oracle.ons.SubscriptionException: [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Apr 9, 11:03 am, hotspring wrote:
> On Apr 9, 10:49 am, " "
> wrote:
>
>
>
> > On Apr 9, 9:12 am, wrote:
>
> > > Hi,
> > > I am writing Java application using JDBC to support Oracle RAC
> > > database, but I got the following ONS related exception. Can anyone
> > > tell me why I have this error?
> > >Possible
> > > causes: OPMN may not be running, you may have an OPMN running in an
> > > alternate ORACLE_HOME using duplicate port values, or OPMN may be
> > > misconfigured.
>
> > Have you verified whether the possibilities mentioned in the
> > error itself are not true? You are asking the driver to do FCF,
> > I guess, and that requires information from the RAC cluster,
> > via Oracle Notification Service. Is that running, and did you
> > give the driver the correct ONS info?
> > Joe
>
> Yes, I think I correctly configured in Java side since I don't get
> this exception all the time. During my test I got this exception
> irregulary. Since my DBA set up the RAC, I don't know much about Orace
> server side RAC set up but I found the followings; do you think this
> may cause the problem? My testing RAC database uses two nodes but I
> see ONS daemon is running on from only one node not from both. Is this
> right?
>
> Node 1
>
> [oracle@rac1 ~]$ srvctl status nodeapps -n rac1
>
> VIP is running on node: rac1
>
> GSD is not running on node: rac1
>
> Listener is not running on node: rac1
>
> ONS daemon is not running on node: rac1
>
> Node2
>
>  [oracle@rac1 ~]$ srvctl status nodeapps -n rac2
>
> VIP is running on node: rac2
>
> GSD is running on node: rac2
>
> Listener is running on node: rac2
>
> ONS daemon is running on node: rac2
>
> [oracle@rac1 ~]$

Maybe, but you'd have to ask the DBA
 >> Stay informed about: Oracle JDBC oracle.ons.SubscriptionException: 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
JDBC oracle question - Hello, I'm building a wireless application with Java J2ME (CDC profile). My application needs a direct connection with a remote Oracle database. For this purpose I think it's best to use JDBC. But which JDBC driver should I use? - Should I use an..

JDBC Oracle Problem - Oracle DB 9.2.0.1.0 Oracle9i 9.2.0.8 JDBC Drivers For use with JDK 1.4 The Problem is that I get a sql.exception ORA-00955 when trying to create a Table and insert records. Example: Table Test is created 3000 records are put in and than the..

JDBC & Access Oracle - Hi all, I'm fairly new to JDBC, and am looking to create a program to copy the examine the entire structure of an MS Access database and recreate it in Oracle. This includes re-creating views so that they can be executed in the Oracle database (as..

Jdbc Oracle getMetaData is slow? - Hello, I am fetching MetaData using the Oracle jdbc thin driver and find it very slow. Are there any global parameters or settings to be done to tune this? thanks, Peter

jdbc connection to database Oracle 10g - I have this problem: I am using Eclipse as development for java web apps. I am using Oracle 10g as back end specifically Oracle Toad 8 for handling db. I am using Eclipse BIRT ( business intelligent reporting tools ) for report generation. Upon testing...
   Database Forums (Home) -> Java All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]