Yesterday — Friday, 3 July 2009
|
Hi , Are u familiar with Oracle Cl... arabe 19:04:13 |
| | Hi , Are u familiar with Oracle Clinical? I need access to do some practice in writing the Validation Procedures. Any advice.
Thanks
LowLifeD |
| | Add comment |
Sunday, 28 June 2009
|
Oracle Developer Suite 10g cannot be installed into existing Oracle Home ericzutter 09:35:07 |
| | I downloaded the latest Oracle versions for studying. (I don't have a metalink account because I am actually not working)
I want to install Oracle Database 11g + Oracle Developer Suite 10g on the same Windows XP Desktop. I did the following steps :
- Install Oracle Database 11g in ORACLE_HOME "C:\oracle\product\11.1.0\db_1". - Create a database DEV - Startup database DEV, listener and configure sqlnet.ora+tnsnames.ora - Connect to the database with sqlplus system@dev => connection succeeded - Install Oracle Developer Suite 10g in ORACLE_HOME "c:\oracle\product\DevSuiteHome_1" and choose Installation Type "Complete (1.13 GB)"
When I install Oracle Developer Suite 10g I receive the following error:
Oracle Developer Suite 10g (10.1.2.0.2) cannot be installed into existing Oracle9i 9.2.0.1.0 or higher Oracle Home.
I don't understand why I receive this error. Oracle Developer Suite creates a seperate Oracle Home, so I don't understand why the error says that it tries to install into an existing Oracle Home.
What must I do to solve this problem?
|
| | 1 answer | Add comment |
Friday, 5 June 2009
|
| Oracle ODBC/OLEDB - can't get it to work Martijn Tonies 09:31:48 |
| | Hi all,
I've just did another re-install of the Oracle 10g client.
I can see the Oracle ODBC driver in the Windows ODBC Control Applet. But whenever I select it, it returns an: --------------------------- Microsoft ODBC Administrator --------------------------- The setup routines for the Oracle in OraClient10g_home1 ODBC driver could not be loaded due to system error code 998. --------------------------- OK ---------------------------
As for the OLEDB driver - it doesn't show up in the list of available OLEDB drivers.
Does anyone have an idea?
I've searched, but cannot find a workable solution to get this ODBC working
-- With regards,
Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server Upscene Productions http://www.upscene.com
|
| | 6 answers | Add comment |
Wednesday, 27 May 2009
|
| Missing listener.ora and tnsnames.ora file Guest 10:10:14 |
| | We recently installed Oracle 9i on Redhat and have discovered that there is no listener.ora and tnsnames.ora file in the usual location: /u01/app/oracle/product/9.2.0/network/admin
The server has been running fine and we have performed imp's and exp's without any issues, clients have also been connecting without issue.
We discovered the files were missing when attempting to run sqlplus on the server, it gave an: ORA-12514: TNS:listener could not resolve SERVICE_NAME........ ,
and upon investigation discovered the missing files.
Anyone seen this before? Thx
|
| | 3 answer | Add comment |
Saturday, 23 May 2009
|
how to connect to oracle 10g using oci driver with jdk1.6.0 avinash 21:33:23 |
 | i am new oracledatabase combine with java programing . i tired this program .
----code----- import java.sql.*; public class OracleOciConnection { public static void main(String args[]) { try {
Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con = DriverManager.getConnection("jdbc:oracle:oci8:@","hr","hr"); System.out.println("connected to oracle using oci driver"); con.close(); } catch(Exception ex) { ex.printStackTrace(); } }
it successfully complies but on execution it gives an error C:\java>java OracleOciConnection java.lang.ClassNotFoundException: oracle.jdbc.driver.Oracle.Driver at java.net.URLClassLoader$1.run(URLClassLoader.java:200) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:164) at OracleOciConnection.main(OracleOciConnection.java:9) can any tell me how to solve this problem i changed path ,classpath many times i search many sites but sloved my problem .
so plz tell me step by step connection to database i am using oracle10g and jdk1.6.0 . i have also install jdk1.5.0 and also tell me what option to chose in ODBC Data Source Administrator window |
| | Add comment |
Wednesday, 13 May 2009
|
| [?] SYSDBA audit Vladimir 18:41:03 |
| | Hello,
I need to audit SYSDBA activity, so I turn audit_sys_operations to TRUE, and SYSDBA/SYSOPER activity is being placed into Windows Application Log. Is there a way to place those activity records into DB or somehow get an access to those records from SQL?
Thank you for your time, Vladimir.
|
| | 9 answers | Add comment |
Monday, 11 May 2009
|
| SQL Queries SLOW after Oracle 8i to 10g migration Blue Crystal Solutions 11:50:13 |
| | I have just migrated from Oracle 8i to Oracle 10g on a Windows 2003 server. The server is of higher processing power. Several SQL Queries, some complex ones are very slow.
Some SQL Queries run faster and some queries run slower. Some queries used to run in 6 minutes now take up to 6 hours. Some queries run faster. The indexes are exactly the same in both versions. What has changed in the optimizer when upgrading from 8i to 10G? What needs to be done for these queries? And why?
|
| | 8 answers | Add comment |
Thursday, 7 May 2009
|
| Running Setup in Oracle Developer Suite 10g for windows XP Pro SP2 Jean-Benoit MORLA 09:54:34 |
| | Hi,
I can't get past the first screen in the setup/installer of Oracle Developer Site. There are 3 fields: Source -> points to the products.jar file Destination ->Origin Oracle Home directory is a variable "OraDb10g_Home1" Destination ->Path:C:\oracle\product\10.1.0\db2 Now if I click the button "Installed Products", I see a tree with a "OraDb10g_Home1" leaf and the message: not available. How can I fill these fields with the correct values? Many thanks jbmorla@tiscali.fr
|
| | 7 answers | Add comment |
Thursday, 19 March 2009
|
| Problem while running developer report via web client Rameshkumar X Rajendran 23:46:36 |
| | Hi, I am working in reports builder. We are migrating from reports6i to 10g. I downloaded the existing RDF files in our reports server (AIX ver 5) to my local machine and compiled them in reports10g. Then copied them to another test server where we have Ora dev 10g is installed. For few reports I was to attach libarries manually. Now those reports are not working when accessed via webclient. I am getting following error. Error attaching PL/SQL Library 'xy.pll'. REP-0736: There exist uncompiled program unit(s). REP-1247: Report contains uncompiled PL/SQL.
I even tried with copying the existing RDF file from the production server along with the library. Still I am getting the same problem!
Could you please help me to resolve this problem.
Thanks,
Ramesh
|
| | 2 answer | Add comment |
Friday, 16 January 2009
|
| SQL Backtrack v4.00 for Oracle; Issues With Listing of Backups SAP BASIS Consultant 19:26:50 |
| | Hello,
I created a few successful online backups, and 2 successful cold backups, for a database using SQL Backtrack. The cold backup was taken today (Nov 18), and the online backups on Nov. 16 and Nov. 17.
However, when I try to restore my cold backups, they are not listed as 'previous database incarnations'. However, it seems like SQL Backtrack is asking for a data close to the cold backup, and not one associated with the online backup. (Unless it chooses the online and restores with the logs)..
Why would Backtrack not list the cold backups as database invocations, and ask for a Nov. 18 date range for restoring a Nov. 16 online backup?
Thanks, DF
**********************************************************
OBACKTRACK Database File Restore Menu
1. Restore selected database files 2. Perform a time-based recovery 3. Perform a change-based recovery 4. Perform a recovery from a retained backup
Choose: 1-4 [c=cancel, q=quit, ?=help] OBACKTRACK> 2
Select database incarnation
1. Incarnation 1 - created on 11/15/2004 07:42:23 2. Incarnation 2 - created on 11/16/2004 13:08:39 3. Incarnation 3 - created on 11/16/2004 13:49:21
Choose: 1-3 [c=cancel, q=quit, ?=help] OBACKTRACK> 3 Enter a date between '11/18/2004 09:29:32' and '11/18/2004 13:57:34': Enter time to recover to. Use the following format: %m/%d/%y %H:%M:%S :
|
| | 2 answer | Add comment |
Friday, 19 December 2008
|
| [Oracle 10g] Can't run SQL Scripts. Why? Peter Koch Larsen 13:31:38 |
| | Hi all
I am in the process of porting an application to Oracle and have as a start downloaded 10g. I have been able to run scripts for a while, but now I am unable to run anything - no matter what user I login as. The errorcode is as follows:
ORA-01400: cannot insert NULL into ("FLOWS_020100"."WWV_FLOW_SW_RESULTS"."FILE_ID")
Unable to submit the script to run.
(If I instead of the script try to run my code as a SQL Command, the result is: "The requested URL /apex/wwv_flow.show was not found on this server ").
Can anyone help me to get on my feet again?
Kind regards Peter Koch Larsen
|
| | 6 answers | Add comment |
Wednesday, 10 December 2008
|
| How to delete a lock Dn.Perl@Gmail.Com 16:12:08 |
| | A table has been locked and I want to free it. I have looked at v$lock and v$session objects, but I don't know what entry to delete from where. What I do know is that nobody is using the database right now, and it is okay for me to delete the appropraite entry (whether from v$lock or v$session). Out of the first 5-10 links which turn up in a google or google-groups search for "delete lock oracle", no link provides a quick route to delete a lock and free the locked object.
Please advise.
|
| | 7 answers | Add comment |
Tuesday, 9 December 2008
|
| 9i to 10g migration Dave 22:57:51 |
| | OK, Im having a bit of difficulty here and hoping that the knowledgeable folks here at cdos can help me out:
We are upgrading a 9iR1 database to 10gR2. At the same time, we are upgrading the hardware. Both platforms are Win2K. Right now, I am attempting to transfer the 9i instances to the 10g server. I had thought I could do this with RMAN and the DUPLICATE command. However, this doesnt seem to work out: RMAN ends with the following error:
printing stored script: Memory Script { Alter clone database open resetlogs; } executing script: Memory Script
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00579: the following error occurred at 11/20/2005 09:49:29 RMAN-10039: error encountered while polling for RPC completion on channel clone_default RMAN-10006: error running SQL statement: select act from x$ksusex where sid=:1 and serial=:2 RMAN-10002: ORACLE error: ORA-03113: end-of-file on communication channel RMAN-03002: failure during compilation of command RMAN-03013: command type: Duplicate Db RMAN-03015: error occurred in stored script Memory Script RMAN-03002: failure during compilation of command RMAN-03013: command type: alter db RMAN-06136: ORACLE error from auxiliary database: ORA-01092: ORACLE instance terminated. Disconnection forced RMAN-06097: text of failing SQL statement: alter database open resetlogs RMAN-06099: error occurred in source file: krmk.pc, line: 23265 RMAN-04014: startup failed: ORA-32004: obsolete and/or deprecated parameter(s) specified
Recovery Manager complete.
Examination of the alert log indicates that the following obsolete and depreciated parameters are listed in the pfile:
Obsolete system parameters with specified values: enqueue_resources End of obsolete system parameter listing Deprecated system parameters with specified values: log_archive_start max_enabled_roles sql_trace End of deprecated system parameter listing
So my first question is: Where can I find how to enable similar functionality in 10g? Of particular concern to me is log_archive_start. (If I have to disable the others for the time being, it shouldnt affect much.) I am not finding the Oracle Database Upgrade Guide helpful in this regard as it only tells me that the parameter is depreicated.
However, I am unsure that this is the actual problem as I can start and stop the instance manually(without opening it) and while I get a warning, it works. The docs indicate that this is expected, a warning, but the db will open. Futher examination of the alert.log indicates the following additional error, which I suspect may be the actual problem:
Sun Nov 20 09:49:25 2005 SMON: enabling cache recovery Sun Nov 20 09:49:26 2005 Errors in file d:\oracle\admin\udump\orcl\orcl_ora_900.trc: ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option
Sun Nov 20 09:49:26 2005 Error 704 happened during db open, shutting down database USER: terminating instance due to error 704 Sun Nov 20 09:49:26 2005 Errors in file d:\oracle\admin\bdump\orcl\orcl_pmon_684.trc: ORA-00704: bootstrap process failure
This ORA-00704 is repeated several times, followed by:
Instance terminated by USER, pid = 900 ORA-1092 signalled during: alter database open resetlogs... <EOF>
I thought there might be an UPGRADE option to the DUPLICATE command, but docs do not seem to list one. I would appreciate any input as to what I am screwing up here, or how to accomplish what I am trying to do. I would prefer not to copy the os files over as that would require an outage of the production db to develop the test db, and a longer outage when we switch over, but that seems to be the only option right now.
Thanks for any and all help.
Regards, Dave
|
| | 7 answers | Add comment |
Tuesday, 21 October 2008
|
| set autocommit off; Guest 09:09:40 |
| | Anyone know why Oracle won't let me do this
set autocommit off;
in a PL/SQL procedure?
It won't take this:
create or replace procedure addname as begin set autocommit off; insert into test values('testname'); commit; end;
|
| | 4 answer | Add comment |
Sunday, 19 October 2008
|
| Access MS SQL Server tables from Oracle 9i Thorsten Jens 13:26:07 |
| | Hi,
I need to access MS SQL Server tables (SQL Server 2000 on Windows 2000) from applications running on Oracle 9i on a Solaris 8 (Sparc) server. I think I am in the same situation as the person in <e70fc892.0209031332.6045a661@posting.google.com> (which is from 2002).
I took a look at the Heterogenous Connectivity Admin Guide, and found I have the choice of Transparent Gateway (15K$) or Generic Connectivity. Has anybody used G.C. to do this before? Are there free/open source ODBC drivers for Solaris 8? Could I use unixODBC as a driver manager?
Thorsten
|
| | 12 answers | Add comment |
Monday, 13 October 2008
|
| Urgent help on using OCCI in Linux. Dragon_num_one 08:38:44 |
| | Hello there,
I am in urgent need to solve the following problem regarding use Oracle OCCI under Linux.
Could someone help me to solve this problem? Is OCCI so difficult to use?
the crash is caused by using getString(). If I commented out the second and third printf(), the program will be having no problem.
while (rs->next()) { printf("Book ID = %d\n", rs->getInt(1) ); printf("Title = %s\n", rs->getString(2).c_str() ); printf("Auther = %s\n", rs->getString(3).c_str() ); printf("Price = %d\n", rs->getInt(4) ); }
Thanks so much.
Steven
==================================================================
The OCCI I downloaded back is version 10.2.0.2, Instant Client Package - Basic
The following are some info of it.
Currently we use gcc 4.0.2 (gcc (GCC) 4.0.2 20051125 (Red Hat 4.0.2-8)), maybe they are not compatible.
Oracle C++ Call Interface - Downloads
OCCI for gcc 3.4.3 (Linux) Download (tar) OCCI 10.2.0.1.0 support files for building applications with gcc version 3.4.3 on RedHat Linux AS 4.0
Instant Client Downloads for Linux x86
Version 10.2.0.2
Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications
instantclient-basic-linux32-10.2.0.2-20060331.zip (33,901,074 bytes) (cksum - 2602139346)
*Instant Client Package - SQL*Plus: Additional libraries and executable for running SQL*Plus with Instant Client
instantclient-sqlplus-linux32-10.2.0.2-20060331.zip (740,155 bytes) (cksum - 3809431917)
*Instant Client Package - SDK: Additional header files and an example makefile for developing Oracle applications with Instant Client
instantclient-sdk-linux32-10.2.0.2-20060331.zip (602,224 bytes) (cksum - 3391827328)
I have been trying to find out what cause my app crash.
Here is the compiling and test result.
[LinuxMOne:stang] /home/stang/Desktop/occi/test> make
g++ -Wall -DLINUX -D_GNU_SOURCE -D_REENTRANT -g -I/home/stang/Desktop/occi/ include -c -o test1.o test1.cpp
g++ -Wall -DLINUX -D_GNU_SOURCE -D_REENTRANT -g -I/home/stang/Desktop/occi/ include -locci -lclntsh -lociei -lnnz10 -locci -lclntsh -lociei -lnnz10 -o test1 test1.o
/usr/bin/ld: warning: libstdc++.so.5, needed by /usr/lib/gcc/i386-redhat-linux/4.0.2/../../../libocci.so, may conflict with libstdc++.so.6
[LinuxMOne:stang] /home/stang/Desktop/occi/test> test1
Enter main ...
Enter login_info ...
====Restriction List====
=name= =ip= =port=
name = www.shaw.ca
ip = 33.33.33.33
Segmentation fault
[LinuxMOne:stang] /home/stang/Desktop/occi/test>
Now I am thinking it must be something to do with the compile warning:
/usr/bin/ld: warning: libstdc++.so.5, needed by /usr/lib/gcc/i386-redhat-linux/4.0.2/../../../libocci.so, may conflict with libstdc++.so.6
Any idea and solution?
Thanks,
Steven.Tang@mobidia.com
Now I changed the Linux to be RedHat EL AS 4 and gcc 3.4.5-2, I still got the program aborted:
*** glibc detected *** free(): invalid pointer: 0x09e557e0 *** Aborted
See the following info for detail.
Anyone there could help me please advise me what was wrong!!!
Thanks,
Steven
[magdev@magdev test]$ uname -a Linux magdev 2.6.9-34.EL #1 Fri Feb 24 16:44:51 EST 2006 i686 i686 i386 GNU/Linux
[magdev@magdev test]$ gcc --v Reading specs from /usr/lib/gcc/i386-redhat-linux/3.4.5/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --with-system-zli b --enable-__cxa_atexit --disable-libunwind-exceptions --enable-java-awt=gtk --host=i386-redhat-linux Thread model: posix gcc version 3.4.5 20051201 (Red Hat 3.4.5-2)
[magdev@magdev test]$ make g++ -Wall -DLINUX -D_GNU_SOURCE -D_REENTRANT -g -I/usr/include/occi -c -o test1.o test1.cpp g++ -Wall -DLINUX -D_GNU_SOURCE -D_REENTRANT -g -I/usr/include/occi -locci -lclntsh -lociei -lnnz10 -locci -lclntsh -lociei -lnnz10 -o test1 test1.o /usr/bin/ld: warning: libstdc++.so.5, needed by /usr/lib/gcc/i386-redhat-linux/3.4.5/../../../libocci.so, may conflict with libstdc++.so.6 [magdev@magdev test]$ test1 -bash: test1: command not found [magdev@magdev test]$ ./test1 Enter main ... Enter login_info ... Enter run() ... Enter insertRows ... SCOTT's salary = 60000, commission = 6000 Sleep for awhile to check ... Enter deleteRows ... The book table has book: Book ID = 1 Title = The C++ Programming Language *** glibc detected *** free(): invalid pointer: 0x09e557e0 *** Aborted
Steven Tang
|
| | 6 answers | Add comment |
Tuesday, 23 September 2008
|
| Oracle Timestamp Faby 12:35:28 |
| | Hi, I was wondering how I should convert a timestamp to compare it to '01-AUG-2006'.
Is any of the following right?
TO_CHAR(TRUNC(MYTIMESTAMP)) < '01-AUG-2006'
TO_DATE(TRUNC(MYTIMESTAMP)) < '01-AUG-2006'
TO_CHAR(MYTIMESTAMP,'DD-MON-YYYY') < '01-AUG-2006'
If you could give a brief explaination of why I am getting a different result for each of the previous answer, i would really appreciate.
Thank you Faby
|
| | 5 answers | Add comment |
Monday, 22 September 2008
|
| Time diff Eugene 15:29:29 |
| | Hi all, I have two columns representing start_datetime and end_datetime. They look like 1085008980 and 1085009504 respectively. They are stored in UTC format (number of seconds from '15/12/1970'). How do I calculate difference in hours:minutes:seconds?
Thanks, Eugene
|
| | 9 answers | Add comment |
Monday, 25 August 2008
|
| Rollup Aggregation Tuning Pawel 11:38:04 |
| | Hi,
I'm working on a data warehouse solution for fact data aggregation. Short description:
there's base level fact table:
TIME_ID, GEO_ID, PROD_ID, AMOUNT1, AMOUNT2....
Fact data is 3-dimensional with, say ~500 nodes in each of the hierarchies lowest level (input data). Rows are distinct. So there's 500^3 rows, with low cardinality for each separate dimension column.
I also have a flattened time hierarchy with 3 levels. Flattened with this procedure: When graph is (text-mode compliant ...
X (year) / \ / \ P Q (halfs) / \ \ / \ \ A B C (lowest level)
...HIER table rows look like this:
Lvl1, Lvl2, Lvl3 ---------------- X P A X P B X Q C
FACT table is joined with HIER (WHERE TIME_ID = Lvl3) Then ROLLUP(Lvl1, Lvl2, Lvl3) is used for full aggregation on time dimension. [The lowest level (Lvl3) might be skipped and gotten from FACT table - it's written here for clarity.]
I'd like to know your opinions about the best way to tune the performance of this query - or even rewrite it to leverage other Oracle features (e.g. Dimension objects). Fact table needs to be FULLy ACCESSed, but when GROUPing, there's sorting needed as far as I know, so what about bitmap indexes? Or concatenated bitmap index? Then PARALLEL - will Oracle use it's advantages here? Would partitioning help?
Thanks, Pawel
|
| | 2 answer | Add comment |
Tuesday, 12 August 2008
|
| Copy a table from 1 schema to another Rj 08:43:38 |
| | Hi all,
What is the statement to copy a table and all content to another schema. I dont need a link or any synchronization, just that table.
Thanks in advance..
|
| | 6 answers | Add comment |
Thursday, 31 July 2008
|
| NMO not setuid-root (Unix-only) Howard J. Rogers 08:12:13 |
| | This has probably been asked and answered somewhere before now, but Google only returns three answers and one of those is in fluent Japanese (and the other two don't help).
Oracle 10g on Linux, Enterprise Manager, attempting to alter the archive log mode of the database: it asks me to supply node and database credentials, and when I do, I get this error:
RemoteOperationException: ERROR: NMO not setuid-root (Unix-only)
Any suggestions? Normally, Enterprise Manager works fine. I can't think what I've done or haven't done this time around.
Regards HJR
|
| | 11 answers | Add comment |
Tuesday, 22 July 2008
|
| java.sql.SQLException: Exhausted Resultset Alessandro Lagostena 10:04:10 |
| | Hello Gents
I have a application that work from 3 years and now on a prticular action show this error :
java.sql.SQLException: Exhausted Resultset
The application scan a table with ~8000000 rows
Can this error depend from a bad status of the table ?
I check on the alert log of oracle and not found any message
Do someone have an idea ?
Thanks for the support
Regards LAGO
|
| | 3 answer | Add comment |
Wednesday, 16 July 2008
|
| Loading 300 million records AlexK 14:15:10 |
| | Hi All,
I'm trying to improve the performance of a procedure that loads approximately 300 million records into a table. Currently the process is using 'INSERT /*+ APPEND*/ .. INTO SELECT' and takes about 10 hours to run on 10G. The select joins about 5 tables, most of which are small except the driving table which has about 300M records in it. I believe the indexes are good as explain plan only shows the main table getting a full table scan. From what I've read online, it says that the 'INSERT .. INTO SELECT' is the fastest and most efficient way to load data from one table to another. Unfortunately the only examples I've seen where the quantity of records inserted are mentioned only deals with about 1 million records at most. Is this still the best approach to take when loading 300M records? Would a bulk collect or something else be better since so many records are being processed? Any information would be greatly appreciated. Thanks in advance.
Alex
|
| | 16 answers | Add comment |
Sunday, 22 June 2008
|
| UnsatisfiedLinkError using OCI Driver of Oracle 10g Nish 08:33:48 |
| | Hi All, I am working on Oracle 10g server and have been facing following problem.I installed instant client of Oracle 10g on a Windows2000 machine and tried to access the Oracle 10g server running on a "HP-UX 11.23" system using OCI JDBC driver. Following is the program, I executed for contacting server, ------------------------------------------ public class TestNew { public static void main(String[] args) { try { // Connect DriverManager.registerDriver(new Oracle.jdbc.driver.OracleDriver()); OracleConnection conn = (OracleConnection)DriverManager.getConnection ("jdbc:oracle:oci8:@10.3.10.21:1521:mydb","scott", "scott");
}catch(Exception e) { e.printStackTrace(); } } } --------------------------------------------
I have done the following for running the program, ---------------------- D:\>set CLASSPATH=D:\Oracle\instantclient10_1;D:\OracleDrivers\ojdbc14.jar;. D:\>set PATH=%PATH%;D:\Oracle\instantclient10_1 ---------------------- where, "D:\Oracle\instantclient10_1" is the path where instantclient is installed.
I tried to run it using the following command to get the following error, ---------------------- D:\>java -classpath %CLASSPATH% -Djava.library.path=D:\Oracle\instantclient10_1 TestNew Exception in thread "main" java.lang.UnsatisfiedLinkError: t2cCreateState at oracle.jdbc.driver.T2CConnection.t2cCreateState(Native Method) at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:324) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:344) at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:136) at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:79) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at TestNew.main(TestNew.java:39) ------------------------------
I am not able to find out what is going wrong. Any help will be highly appreciated.
Thanks in advance, Nish.
|
| | 2 answer | Add comment |
|