ORA-01033: ORACLE initialization or shutdown in progressÄoes the Oracle thin client require the first database to be working on connect and only failover if something goes wrong during the connection? What I want is for the application to try the next server if the connection to the first server fails (which I could do using try application logic but would prefer the driver to take care of the details for me). However, the Oracle JDBC OCI driver support is the same as thick client support, in which all of Oracle Advanced Security features are implemented. However when I put site1 first I get the same error as if I tried to connect directly to site1 - which is: : The JDBC Thin driver gives the user process a direct connection to Oracle by implementing a form of TCP/IP imitating Oracle Net and TTC on top of Java sockets. The Oracle JDBC Thin driver does not support Oracle Advanced Security third party authentication features such as RADIUS, Kerberos, and SecurID. ![]() However, when using jdbc 19.15, it was observed that sessions are keeping. Only One ONS Registration Is Effective When Calling setONSConfiguration () Method. If I specify site2 first in my list then I get a connection (just like I'd expect if I just tried to connect to site2). When using jdbc thin 12.1.0.2 to connect to the oracle database, it was observed that when the application (JDBC connections) generates a report, the sessions on the db side reached around 45 and immediately killed by the database and the sessions resets to 4 sessions. The following notes discuss some common problems found on using High Availability features in Oracle JDBC: Intermittent TNS-01153 and NL-00305 Using a JDBC/Thin Connection to a 3-Node RAC Database.Now I know that site1 is down and site2 is up. ![]() However this isn't happening in practice. We presently use the thin driver to connect to an Oracle8i (8.1.6) database. ![]() I have a regarding which JDBC client side driver to use: Thin or OCI.Our web application uses Servlets and JSPs (we do not use applets), which are housed in a Tomcat engine. ![]() I've read that I can set up a JDBC thin client connection string so that my Java program will attempt to connect to the first database first then, if there's a problem, it will attempt to connect to the second database. Selection of JDBC client side driver - Thin Vs OCI Hi Tom,As always, thanks for your help.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |