How do I delete my blog?
Oracle database development
Hello Guest
  
  • Login
• Register…
• Start blog
  • Who, Where, When
• What is interesting here?
• Duels
  • Polls
• Avatars
• Interests
  • Cities and Countries
• Random blog
• Users search
  • Search
• Games
• Tests
• QAIX
  • Сообщества
• Talxy Chat
• Horoscope
• Online
 
Register!

QAIX > Oracle database developmentGo to page: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | next »

  Top users: 
  Recent blog posts: 
  They have birthday today: 
  Forums:   
  Discuss: 
  Recent forum topics: 
  Recent forum comments:
  Модератор:
Yesterday — Wednesday, 17 March 2010
RMAN block lever recovery question Joebayer 18:26:17
 Group,

I am using Oracle 9206 on windows. I have a corrupted block on system
tablespace. And I am using block level recovery (RNAN) to resolve this
problem.

I used
blockrecover file=?? block=?? where database is open? Is this correct?

The command seems to hang there for hours.

Any suggestions?


comment 5 answers | Add comment
Monday, 15 March 2010
Incomplete Recovery of tablespace Drops 18:32:46
 I am desperately trying to find out how to recover a single tablespace
to a specified point in time.

I got an scp from "list backup;"

so I am trying

RMAN> run {2> set until scn 103835211;3> shutdown immediate;4> startup mount;5> restore tablespace dwhva_dim;6> recover tablespace dwhva_dim;7> }

RMAN> alter database open resetlogs;

RMAN-00571: ===================­====================­====================­
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===================­====================­====================­
RMAN-03002: failure of alter db command at 02/27/2006 14:57:42
ORA-01139: RESETLOGS option only valid after an incomplete database
recovery


if I only do "alter database open;" then the state of my tables will
not be the one from the backup but from the time of shutdown.

How is it done?


I read somewhere that you can only make incomplete recoveries of the
whole database. Is this true?

kind regards
Oliver Drobnik

comment 6 answers | Add comment
Monday, 22 February 2010
Problem with SQLPLUS for Linux Star69 06:25:32
 Hello, I've downloaded from oracle.com this software to connect with a
Oracle server from my university:

(Instant Client Downloads for Linux x86)

Instant Client Package - Basic: All files required to run OCI, OCCI,
and JDBC-OCI applications

*Instant Client Package - SQL*Plus: Additional libraries and executable
for running SQL*Plus with Instant Client

I've followed the Installation Steps:

1. Download the appropriate Instant Client packages for your platform.
All installations REQUIRE the Basic package.

2. Unzip the packages into a single directory such as "instantclient".

3. Set the library loading path in your environment to the directory in
Step 2 ("instantclient"). On many UNIX platforms, LD_LIBRARY_PATH is the
appropriate environment variable. On Windows, PATH should be used.

4. Start your application and enjoy.

But when I run sqlplus I get:

sqlplus: error while loading shared libraries: libsqlplus.so: cannot
open shared object file: No such file or directory

I tried to define LD_LIBRARY_PATH with the directory, I also add that
directory to PATH, but I've got the same error. I'm using Ubuntu Linux.
Any idea?

Thank you very much.
comment 5 answers | Add comment
Saturday, 13 February 2010
ORA-00279, ORA-00278 and Specify log: {<RET>=suggested | filename | AUTO | CANCEL} Hari Om 18:29:29
 I am using Oracle 9.2.0.4 on IBM AIX 5.1L.

I had one instance named "solar" on my database running. I wanted to
change ALL the file locations like redo01.log, system01.dbf etc etc..
to a different new location. So, here is what I did:

1) SQL> ALTER database backup controlfile to trace

-- this saves the controlfile in udump directory which I edit it and
change the locations -- of all the data files on it. SO this is what I
have now and I save it is solar.sql
2) EDIT the file:

Example: I changed the REDO Log Location from
/rdisk/solar/gp1/re­do01.log to /redo/solar/gp1/red­o01.log as shown
below.

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "SOLAR" RESETLOGS NOARCHIVELOG
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 113
LOGFILE
GROUP 1 '/redo/solar/gp1/re­do01.log' SIZE 100M,
GROUP 2 '/redo/solar/gp1/re­do02.log' SIZE 100M,
GROUP 3 '/redo/solar/gp3/re­do03.log' SIZE 100M
DATAFILE
'/dict/solar/system­01.dbf',
'/data/solar/undotb­s01.dbf',
'/dict/solar/drsys0­1.dbf',
'/data/solar/exampl­e01.dbf',
'/data/solar/indx01­.dbf',
'/dict/solar/odm01.­dbf',
'/dict/solar/tools0­1.dbf',
'/data/solar/users0­1.dbf',
'/dict/solar/xdb01.­dbf',
'/data/solar/oem_re­pository.dbf'
CHARACTER SET WE8ISO8859P1
;
RECOVER AUTOMATIC DATABASE using backup controlfile
ALTER DATABASE OPEN resetlogs;
ALTER TABLESPACE TEMP ADD TEMPFILE '/data/solar/temp01­.dbf'
SIZE 99614720 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 16383M;

3) SHUTDOWN this DATABASE
4) Copy the files to above location.
5) Run the above script SOLAR.SQL

and it shows: CONTROL FILE CREATED..... BUT Gives following error with
it...

ORA-00279: change 2212096 generated at 2/2/2005 09:46:04 nВeeded for
thread 1
ORA-00289: suggestion : /u01/admin/ar/arch/­arch_1В_5006.dbf
ORA-00280: change 2212096 for thread 1 is in sequence #5006
ORA-00278: log file '/u01/admin/ar/arch­/arch_1_50В05.dbf' no longer
needed for this recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}


CAN anyone help me or give some hints/pointers to this ERROR.
Any related information would be appreciated...

THANKS!

HARI OM

comment 5 answers | Add comment
ORA-1113 signalled during: alter database open Stephen 18:26:43
 I was hasty and I did a cold backup incorrectly, I believe. I shut
the database down and backed up only the data files for one (out of 4
tablespaces). I started Oracle and proceeded to work on all 4
tablespaces. Today I needed to quickly roll back the tablespace I
"backed up", so I stopped Oracle and pasted the backed up datafiles
back in. Now Oracle won't start...

ORA-1113 signalled during: alter database open

Is there a command I can run to tell Oracle I am sure these data files
are consistent, and to let me open the database? Even point me in the
right direction and I will appreciate it.

Thanks,
Stephen

comment 12 answers | Add comment
Thursday, 11 February 2010
recover from Drop Table w/o recovery NetComrade 18:16:55
 Which Oracle version has this feature, and what is it called?

Thanks!
.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes
remove NSPAM to email
comment 2 answer | Add comment
Monday, 25 January 2010
ORA-16005: database requires recovery Amogh 12:00:32
 Hi All,

I shutdown the database with the abort option (shutdown abort).
Following this, I do the following:
1)start the instance
2)execute SQL to mount the database
3)execute SQL to Open the database in READ-ONLY mode.

At this point I get an error, which says:
ORA-16005: database requires recovery

I know that this is because I issued a shutdown abort before, and that
a subsequent startup will require instance recovery procedures.

I do not get the error if I open the database in READ/WRITE mode.

Any particular reason why I get an ORA-16005 in READ-ONLY mode?

Regards,
Amogh
comment 2 answer | Add comment
Thursday, 21 January 2010
Startup Error Deke 02:42:26
 I started up a Oracle 10g database running on a WinXP machine and found
this:

ORACLE instance started.

Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145750508 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
Database mounted.
ORA-00316: log 3 of thread 1, type 0 in header is not log file
ORA-00312: online log 3 thread 1:
'C:\ORACLE\PRODUCT\­10.1.0\ORADATA\LAP2\­REDO03.LOG'


Can any one help in resolving this matter?


Thanks
comment 15 answers | Add comment
Oracle DB cannot restart due to missing REDO-file T. Lehrmann 02:42:23
 Hello,

I have a big problem with my Oracle DB (V 9.1): the service cannot start and
when trying to connect Oracle error message "ORA-01033" pops up, saying
"ORACLE initialization or shutdown in progress". In the log file is written:
"Errors in file c:\oracle\admin\DBN­AME\bdump\DBNAME_lgw­r_480.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'C:\ORACLE\ORADATA\­DBNAME\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: File cannot be opened
O/S-Error: (OS 2) System cannot find the specified file"

This was casued because I deleted the 3 REDO-logfiles REDO01.log, REDO02.log
and REDO03.log of my database (I am no real DBA, I thought Oracle only needs
this files if one wants to recover a DB!).

Apparently, Oracle recreated REDO01.LOG, but not the other two files and now
has problems to even start the DB.


Is there any way (e.g. nologging adjustments in init.ora) to get my DB
started again?


Any help will be appreciated! Thanks in advance,
Thomas


comment 9 answers | Add comment
Wednesday, 13 January 2010
UnsatisfiedLinkError­ using OCI Driver of Oracle 10g Nish 13:54:06
 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.regis­terDriver(new
Oracle.jdbc.driver.­OracleDriver());
OracleConnection conn =
(OracleConnection)D­riverManager.getConn­ection
("jdbc:oracle:oci8:­@10.3.10.21:1521:myd­b","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\ojdb­c14.jar;.
D:\>set PATH=%PATH%;D:\Orac­le\instantclient10_1­
-------------------­---
where, "D:\Oracle\instantc­lient10_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\instantcl­ient10_1 TestNew
Exception in thread "main" java.lang.Unsatisfi­edLinkError:
t2cCreateState
at oracle.jdbc.driver.­T2CConnection.t2cCre­ateState(Native
Method)
at
oracle.jdbc.driver.­T2CConnection.logon(­T2CConnection.java:3­24)
at
oracle.jdbc.driver.­PhysicalConnection.<­init>(PhysicalConnec­tion.java:344)
at
oracle.jdbc.driver.­T2CConnection.<init>­(T2CConnection.java:­136)
at
oracle.jdbc.driver.­T2CDriverExtension.g­etConnection(T2CDriv­erExtension.java:79)­
at
oracle.jdbc.driver.­OracleDriver.connect­(OracleDriver.java:5­45)
at java.sql.DriverMana­ger.getConnection(Dr­iverManager.java:512­)
at java.sql.DriverMana­ger.getConnection(Dr­iverManager.java:171­)
at TestNew.main(TestNe­w.java:39)
-------------------­-----------

I am not able to find out what is going wrong.
Any help will be highly appreciated.

Thanks in advance,
Nish.

comment 4 answer | Add comment
Tuesday, 8 December 2009
Missing listener.ora and tnsnames.ora file Guest 12:06:24
 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/pro­duct/9.2.0/network/a­dmin

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

comment 5 answers | Add comment
Wednesday, 2 December 2009
SQL Queries SLOW after Oracle 8i to 10g migration Blue Crystal Solutions 21:49:46
 
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?

comment 9 answers | Add comment
Monday, 30 November 2009
[Oracle 10g] Can't run SQL Scripts. Why? Peter Koch Larsen 19:26:53
 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"."WW­V_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

comment 7 answers | Add comment
SQL Backtrack v4.00 for Oracle; Issues With Listing of Backups SAP BASIS Consultant 19:22:28
 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 :
comment 3 answer | Add comment
Monday, 23 November 2009
Oracle ODBC/OLEDB - can't get it to work Martijn Tonies 16:45:00
 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


comment 8 answers | Add comment
Tuesday, 10 November 2009
oci to sql conversion? Pieter Breed 09:38:02
 Hi,

I have a component that uses the OCI library to do spatial index
queries. The component is badly written and is based on examples. To
state it shortly, our company has very little experience with oracle
and OCI, and the maintenance on the component is a mess. Is it possible
to rewrite these queries using some flavour of SQL?

If I can do this, I can connect directly to oracle using some ODBC
driver and can write my queries in a more maintainable language (like
c#) with normal sql techniques.

I have oracle 8i.

Thanks,
Pieter Breed

comment 7 answers | Add comment
Friday, 6 November 2009
Oracle Installation in Text mode -- I.e. No GUI Sampath 08:33:56
 I need to install Oracle 9i/10g on my Solaris Server. Server doesn't
have Sun Workstation. I don't have GUI interface. We use command line
prompt. So, I think I can't use X-Windows,

Can somebody tell me Universal installer require X-Windows for
installation or not?
Can I do installation from Command line prompt having the software in
CD? If yes, Please, give me details.

Sampath.

comment 9 answers | Add comment
Wednesday, 28 October 2009
Loading 300 million records AlexK 08:28:12
 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

comment 17 answers | Add comment
Thursday, 8 October 2009
ORA-12546: TNS:permission denied / telnet: socket: Permission denied Sivaran 13:56:35
 
I just want to share my tricky problem we had today. We noticed users
not able to login to SQL plus or telnet from them box. Everything else
was working fine. You can ftp / login / rlogin etc. Nothing was
changed and no new software was installed. We rebooted the server that
did not help. Finally we found that it is a permission problem on
device file

crw-rw-rw- 1 root sys 42, 0 Jan 10 16:15 tcp@0:tcp

make sure you have read permission.

Thakns
Siva

comment 1 answer | Add comment
Friday, 2 October 2009
[Oracle 10g 10.1.0.2] TNS:listener does not currently know of service requested in connect Mike Henkins 12:23:15
 hi,
My system is Windows XP.
Oracle 10g : 10.1.0.2.0

I can connect through sqlplus (and toad) with the following command:

sqlplus scott/tiger /

but I cannot connect with this: sqlplus scott/tiger@localho­st:1521:cambridg

I am trying to connect to my database cambridg on my computer (named
eclipse).
Where is the problem ? Can anyone help me here ?

This is my tnsnames.ora

# tnsnames.ora Network Configuration File:
c:\oracle\product\1­0.1.0\Db_1\network\a­dmin\tnsnames.ora
# Generated by Oracle configuration tools.

CAMBRIDG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ECLIPSE)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cambridg)
)
)

EXTPROC_CONNECTION_­DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)



And my listener.ora :

# listener.ora Network Configuration File:
c:\oracle\product\1­0.1.0\Db_1\network\a­dmin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\product\1­0.1.0\Db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ECLIPSE)(PORT = 1521))
)
)
)

A tnsping works perfect :

C:\bob>tnsping cambridg

TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on
30-JUIL.
-2005 14:46:11

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
ECLIPSE)
(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =
cambridg)))
OK (20 msec)

I get the following message:

C:\>sqlplus scott/tiger@localho­st:1521:cambridg

SQL*Plus: Release 10.1.0.2.0 - Production on Sam. Juil. 30 15:10:58 2005

Copyright (c) 1982, 2004, Oracle. All rights reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in
connect
descriptor

Also, in the services running, I can see that the listener is started and
running:
OracleOraDb10g_home­1TNSListener

Maybe it has something to do with the other listener, that I cannot start:
OracleOraDb10g_home­1TNSListenerSID_LIST­_LISTENER

Any help would be much appreciated as I am currently stucked with that.

Thanks a lot



comment 15 answers | Add comment
Thursday, 1 October 2009
how to connect jdk1.5 to oracle 11g india 08:23:03
 sir , i don't know for connecting jdk1.5 to oracle 11g . so i want solution for this
Add comment
Thursday, 3 September 2009
Copy a table from 1 schema to another Rj 06:38:51
 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..

comment 6 answers | Add comment
Saturday, 22 August 2009
Oracle Developer Suite 10g cannot be installed into existing Oracle Home ericzutter 07:16:11
 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?
comment 2 answer | Add comment
Thursday, 20 August 2009
Problem while running developer report via web client Rameshkumar X Rajendran 11:27:11
 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

comment 3 answer | Add comment
Thursday, 13 August 2009
how to connect to oracle 10g using oci driver with jdk1.6.0 avinash 08:06:03
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("orac­le.jdbc.driver.Oracl­eDriver");
Connection con = DriverManager.getCo­nnection("jdbc:oracl­e: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.ClassNotF­oundException: oracle.jdbc.driver.­Oracle.Driver
at java.net.URLClassLo­ader$1.run(URLClassL­oader.java:200)
at java.security.Acces­sController.doPrivil­eged(Native Method)
at java.net.URLClassLo­ader.findClass(URLCl­assLoader.java:188)
at java.lang.ClassLoad­er.loadClass(ClassLo­ader.java:306)
at sun.misc.Launcher$A­ppClassLoader.loadCl­ass(Launcher.java:26­8)
at java.lang.ClassLoad­er.loadClass(ClassLo­ader.java:251)
at java.lang.ClassLoad­er.loadClassInternal­(ClassLoader.java:31­9)
at java.lang.Class.for­Name0(Native Method)
at java.lang.Class.for­Name(Class.java:164)­
at OracleOciConnection­.main(OracleOciConne­ction.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
comment 1 answer | Add comment

Add new topic:

How:  Register )
 
Login:   Password:   
Comments by: Premoderation:
Topic:
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или законы РФ. Ваш ip-адрес записывается.


QAIX > Oracle database developmentGo to page: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | next »

see also:
compiliation of latest cvs fails von…
Memory persistence with apache question
pass tests:
Avatar's from Elfen lied.
see also:
moya maaalenkaya predislovka!!!
Poschemy vso po anglish?

  Copyright © 2001—2010 QAIX
Идея: Монашёв Михаил.
Авторами текстов, изображений и видео, размещённых на этой странице, являются пользователи сайта.
See Help and FAQ in the community support.qaix.com.
Write in the community about the bugs you have noticedbugs.qaix.com.
Write your offers and comments in the communities suggest.qaix.com.
Information for parents.
Пишите нам на .
If you would like to report an abuse of our service, such as a spam message, please .
Если Вы хотите пожаловаться на содержимое этой страницы, пожалуйста .