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