Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to install NetBeans with Oracle database

ac.arijitMar 28 2016 — edited Mar 29 2016

Hi,

I recently did the following tasks, and got messed up with the installation

1. Installed Oracle database 10g Enterprise Ediition in my D: drive on Windows 7.

2. Checked for the database to be running fine with SqlPlus. Yes!! It was working fine.

3. Installed the Oracle Developer Suite 10g, in the same location (under D: drive), and opened the Forms Builder, JDeveloper, Reports Builder to see whether it properly connects to the database or not. Yes!! It was working fine.

4. Installed NetBeans 8.1 with JDK 8 bundle in the same location (under D: drive). But since then, my database isn't working, i'm not able to login with SqlPlus, neither can i open the enterprise manager, nor i can connect to the database from any Developer Suite application.

Lately, i heard that Oracle 10g comes with JDK1.6 and isn't compatible with JDK8. Also, i found that Oracle 11g is compatible with JDK 5/6 and Oracle 12c is with JDK 6/7/8.

Please!! Can anyone make me understand this whole compatibility issues in a simpler way. Also, please suggest me some way i can setup a development environment, where i can have an Oracle database (10g/11g), Oracle Developer Suite (10g/11g) and NetBeans (as latest version as possible). Any help is highly appreciated

Regards,

Ari 

Comments

KanchDev
Hi Jumbo,

You can consider an incremental rman backup from production database and recover DR database.

This method is available from 10g. otherwise you need to recreate the Standby database.


Cheers,
Kanchana.
CKPT
If the DR is not functioning from last 6 months, According to database size you can rebuild standby database.

if the data difference is not so huge, You can perform incremental roll forward.

For 10g, refer this below link

http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/scenarios.htm#CIHIAADC
Shivananda Rao
As said, you can recreate the standby database if the size of the production database is quite less. If not, then make use of the incremental or rollforwarding method.

Refer this MOS ID *Steps to perform for Rolling forward a standby database using RMAN incremental backup when primary and standby are in ASM filesystem [ID 836986.1]*
SITI
Hi SRP,

DB status:

1.*No ASM storage.*

2.*oracle 9i.*

3.*Archive logs deleted on both Primary and Standby.*

my question:

1.without recreate standby.*is their any method to recover the standby database?*

Regards,
Jumbo.
Shivananda Rao
Since you have lost the archives on the primary database, it is not possible for you to recover your standby database.

The only option is to recreate it fully (if the size of the primary database is small) or to go with the roll forwarding method.
Ganadeva
Hi,

Try this for 9i

Rolling a Standby Forward using an RMAN Incremental Backup in 9i [ID 290817.1]

Please let us know if this works...

Regards,
Ganadeva
SITI
thank you for all.
1 - 7

Post Details

Added on Mar 28 2016
5 comments
1,832 views