General :: Connect From Java To Oracle Through Driver 1?
Apr 29, 2011How do i connect from java to oracle through driver 1?
i have installed open suse linux 11.3 and jdk 1.6.20.0.
How do i connect from java to oracle through driver 1?
i have installed open suse linux 11.3 and jdk 1.6.20.0.
me as to how i should go about accessing the oracle-xe db that I just installed on my ubuntu 10.04 notebook via sqlplus? I have successfully installed the �oracle-xe 10g server� and client� and I can access the admin page from the browser.However when I try to say sqlplus on the s me this:�error while loading shared libraries:libsqlplus.so: cannot open shared object file: No such file or directory�I have set the paths and variables right Im sure, but I just cant connect with sqlpolus
View 1 Replies View RelatedOn RHEL 5.2, i have installed Oracle client 11.1 and Php 5.1.6. After that i somehow installed and configured oci8.so. When i do phpinfo Under oci8 it shows oci8 support enabled.However on running php program that connect with oracle database i get following error PHP Warning: oci_connect() [<a href='function.oci-connect'>function.oci-connect</a>]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that ORACLE_HOME and LD_LIBRARY_PATH are set and point to the right directories in /var/www/html/index.php on line 5
View 5 Replies View Relatedim a newbie in this of linux. I want to have a linux virtualbox with DB servers like Oracle, MySQL, PostgreSQL and so on, so i installed Fedora in virtualchine of virtualbox. In the network configuration i set the Bridge Connection to enable Fedora to get IP from DHCP and it works fine. After that i've installed Oracle 10G Express and it works fine, i can connect without problems to oracle admin web application from Fedora. Previously i checked if port 1521 is open on fedora so when Oracle is running i use nmap and i get this:
Code:
nmap locahost
Starting Nmap 5.21 ....
[code]...
tried hard to install oracle-11g-R2 in my CentOS5.5,during the install,I did all my job step by step as this article says: Q1: when I 'su oracle 'sqlplus /nolog',it said:"sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory".The article has a ution for this problem:"Solution: Install libaio and libaio-devel packages. If packages already installed and error still occurs try execute "ldconfig" as root."Then i executed "ldconfig" as root ,and run "sqlplus /nolog",it occured another problem:"SP2-0667: Message file sp1<lang>.msbSP2-0750: You may need to set ORACLE_HOME to your Oracle software directory"
View 2 Replies View RelatedHow i will use sqlplus in shell script? Can any one provide sample code which explain following:
1. Connect to oracle DB
2. Exceute select * from tablename
3. Release connection to the DB
4. Append output in file everytime when query executes.
I'm trying to configure unixODBC on Linux rehat EL 5 32 bit to connect to an Oracle 10g database server. But when I retest the connection after the configuration then The error occurs:
# isql -v oralab4_dns vonphot vonphoto
isql: symbol lookup error: /usr/lib/libreadline.so.3: undefined symbol: PC
I have searched on Google.com for 2 days but I can't resolve the problem.
installer: jre-6u25-linux-x64.bin
extracted in /usr/java/
now, how do i make it recognized by iceweasel?
the reason of me using it instead of openjdk is that i need newer jre for IBM bladecenter manager web interface.
I'm a new user for oracle,tried to install oracle 10g on redhat linux 5 but gettinh the same error message.response/ runInstaller[oracle2@localhost database_10201]$ sh runInstaller _runInstaller: line 54:/tmp/database_10201/install/.oui: Permission denied_Doany one plz help me how to give full set of permisions to an user in linux to access a folder??
View 2 Replies View RelatedI have installed oralce-xe 10g on CentOs. I am facing error while connecting it
SQL> connect
Enter user-name: HR
Enter password:
[code]...
how can i connect remotly to Oracle Database using shellscript?.is oracle client is require for connect to oracle db remotly?
View 2 Replies View RelatedI'm using Kubuntu 8.04 and now I've installed OpenOffice 3, both in Spanish.I have oracle client installed and can connect to Oracle databases with clients like tora.What I try:
- Open Database and select connect to an existing database.
- Select Oracle JDBC.
- Next
- DatabaseName: I put the sid of the database of oracle. (orcl)
Server URL: The name of the server containing the database. It's resolved by a ping. (database.organization.es)
Port: 1521
- Oracle JDBC Driver:
oracle.jdbc.driver.OracleDriver
But I press the test button, I receive an error: JDBC Driver can't be loaded (really, the message is in spanish).
I've AMD64 system with Ubuntu 11.04 installed. It's been rough ride for me to install oracle-xe-universal. I've already spent more than 2 days on this. Still unsuccessful.
1) First I downloaded the packages libaio_0.3.104-1_i386.deb and oracle-xe-universal_10.2.0.1-1.1_i386.deb
2) Then I ran
sudo apt-get install bc (ran fine)
sudo dpkg -i --force-architecture libaio_0.3.104-1_i386.deb (ran fine)
sudo dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.1_i386.deb
(gave me dependency error for libc6 (>= 2.3.2), I modified the control file to remove dependency and rebuilt the package) (now worked fine) Oracle xe is now installed. Then I tried to start the DB it started but it's HTTP client never started. So I decided to uninstall the oracle-xe=universal. None of the sudo apt-get remove oracle-xe-universal command's didn't worked for me. So i went for manual uninstallation directions as per oracle link.
I ran the following command-
--Manually uninstalling Oracle 10g--
sudo rm -rf /usr/lib/oracle /etc/oratab /etc/init.d/oracle-xe /etc/sysconfig/oracle-xe /usr/share/doc/oracle_xe /usr/share/doc/oracle_xe_client
Then I again ran the following command to install oracle-xe
sudo dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.0_i386.deb
See below what I got as the output-
rocky@ubuntu:~/git/mygit/edas2/libaio$ sudo dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.1_i386.deb
dpkg: warning: overriding problem because --force enabled:
package architecture (i386) does not match system (amd64)
[code]....
Even in applications menu I don't see the if oracle has been installed. So i conclude first time installation was ok but somehow http client didn't worked. After manual uninstallation, second installation didn't even loaded/installed the oracle-xe in init.d directory.
I've just installed java (jre-6u21-linux-i586.bin) on Red Hat 4.4 AS and issued this command to check the java version: java -versionand got :bash :java: command not found
View 4 Replies View RelatedJava is installed in linux machine and when I enter the command java -version it shows java is not found.At the same time when i run from the folder where its installed with ./java -version it works.
first of all why its not working from any other place? also why do I need to give ./ from the folder?
Do Windows XP, Vista, Windows 7 and all Linux distributions have Java JRE installed so end-users don't have to install it to run Java applications?
View 4 Replies View RelatedI have a jsp code. After executing that code, a Java program should be executed without refreshing the page. that is, my first page is a login page which is in jsp. After logging in the next page must be displayed which is a Java code. is that possible? Can we use applet for that?
View 1 Replies View RelatedI'm at wits-end here trying to get Fedora up and running. Just installed Fedora 14 from a live CD on my 32-bit Toshiba laptop computer. I'm at college for the semester, which means all internet access is through my school. Problem is, in order to get online via my school, I need a java plugin for Firefox. For non-Windows computers, users must log-in to the network through a web browser, using a Java applet. This requires a java plugin. I cannot access my school's network without it. An alternative to this is to use my Droid X's wireless tethering capability. This is normally how I solve the Java problem whenever I install a new Distro (I'm a distro-hopper).
Unfortunately, however, my computer is not picking up any wireless connections and I have no idea how to search for them. When I right-click the networking icon, I ensure that networking is enabled. When I left-click the icon, it's not even showing a list of wireless connections, leading me to believe that either a) wireless networking is disabled or b) Fedora doesn't notice that I have a wireless card at all. Maybe neither of these are the problem, I don't know. I'm no expert by any means. In fact, I'm quite new to Linux. I'm posting this from a netbook which has PCLinuxOS on it, which is connected to my school's network via ethernet. I looked up the java installation instructions on the java website.
I followed them by a) downloading the RPM and saving it to my external hard drive, which I then used to transfer it to the laptop which has Fedora 14 on it. I did my best to follow the instructions for installation which are given on the website, but to no avail. I cannot get any plugin to show up in Firefox. When I run the "java -version" command, I get "java version 1.6.0_22", and two more lines of output, which indicate that I have java installed on my computer. Is this correct and if so, how do I get the plugin installed in FireFox? I've opened FireFox and checked to see if the plugin is there or not, and it is not.
I have a centos 5.5 machine. I have forwarded both port 22 and 8080 on my router. I can connect on 22 via telnet ip 22 and even can remotely login into the machine. The problem when I start my java listener program which is listening on 8080 it cant not establish any connection (via telnet ip 8080). I have even add this into the iptables too -A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 9000 -j ACCEPT. I have disabled the SELINUX too.
View 9 Replies View RelatedTrying to get OpenbavoPOS to connect to my remote Postgresql database, but so far i've only been able to connect to the local postgres installation. I _am_ able to access the remote databases with psql. I've read literally dozens of pages, and am pulling my hair out. I'm trying jdbc:derby.//192.168.15.10:5432/bravo I get back java.sql.SQLException no suitable driver found for jdbc:derby.//192.168.15.10:5432/bravo If I use jdbc:derby./root/bravo - all is OK, using a local database created in /root I have jdk installed on the client; does it need to be on the server also?
Server = CentOS 5.4 PostgreSQL version 8.1.21
Client = CentOS 4.8 PostgreSQL version 8.1.4
[code]....
Does anyone know Oracle e-Delivery (link below)? It looks like free download of linux is available form this site.
[URL]
1. What is the difference between Oracle Linux x86 32 bit and x86 64 bit?
2. How can I verify which one (x86 32 bit vs. x86 64 bit) I need for my PC?
3. What's the difference between the two below (one with Source and the other without 'Source')? I am trying to figure out which one I need.
- Oracle Linux Release 5 Update 2 for x86_64 (64 Bit)
- Oracle Linux Release 5 Update 2 Source for x86_64 (64 Bit)
I installed Oracle Linux 5 and now I can not boot into Vista. However if I use Debian Live CD Vista is there and looks fine (as far as I can see). Is there a way I can use a live CD to fix grub? I have googled it but none of the commands I found worked.
View 9 Replies View RelatedMy Setup: Dell Laptop (BIOS allows boot from USB) - Vista 32 bit installed, 4 GB memory
External 500 GB HDD (iOmega) - Partitioned as follows:
NTFS: 50 GB
/boot: 1 GB
below two on one logical volume:
swap: 5 GB
/: rest ~ 440 GBI installed Oracle Enterprise Linux on the external HDD.
Did not install the Grub bootloader as I don't really want a startup boot option. The way I was planning to make it work was: When USB HDD connected and laptop powered up, it'll boot to the Oracle Linux. When the USB drive is not connected and laptop powered up, it'll boot to Vista. When I boot with the USB HDD connected, nothing happens. I get a blank screen with a blinking cursor. The USB HDD light comes on though. Is the above plan possible, or do I have to have a Boot loader installed?
If I have to have a boot loader installed, how can I just install the bootloader and not have to reinstall Linux on the HDD. The Linux drive is currently empty, so I'm open to any good suggestions to partitioning it. I want to keep a small amount of NTFS space on that drive to store some windows files and documents that I can carry around. The rest 450 GB is open for Linux. And I Plan to install Oracle Database and Apps on Linux (which takes about 350 GB of space).
Instead of using sudo to start the listener, first use su - oracle, then start the listener.
su - oracle
password: oracle
lsnrctl start LISTENER
lsnrctl status
I was then able to bring up the Oracle home page a few minutes later with: [URL]
I am wanting to purchase a desktop or workstation to run Oracle 11g and E-Business suite -- Does Dell have Redhat OS and will a desktop or workstation be the best setup
View 2 Replies View Relatedi need to deploy oracle packaged thorugh unix instead of using SQLplus where in you can directly type the commands.
View 4 Replies View Relatedi have linux redhat (OEL rel 5) on the development server, that is being used for my project. i wanted to install oracle client version 10.2.0.1 on my box. i decided to use silent mode installation, but i am unable to find proper steps in making a response file and running installer in silent mode i went throught the manuals and refered some of the sites, but there is lots of confusion regarding the pre-installation tasks like setting the environment variables,etc
View 1 Replies View RelatedI tried to install oracle 11r2 in red hat el5. [root@perf Downloads]# uname -a Linux perf.com 2.6.18-8.el5 #1 SMP Fri Jan 26 14:15:21 EST 2007 i686 i686 i386 GNU/Linux
some of the prerequisite patches are not updated
Current Requirements
gcc-4.1.1-52.el5 gcc-4.1.2
libgomp-4.1.1-52.el5 libgomp-4.1.2
glibc-2.5-12 glibc-2.5-24
[Code].....
we need the following files,where can i download it?
I serached in net.but there is no use.most of them related to fedora core
I have a newly built RHEL 5.2 machine and Oracle (10.2.04)was just loaded. I have a startup script that was provided by one of my coworker admins, which "works" but I need info on exactly where to put it, and whatever else needs to be done to correctly start/stop the oracle deamons. Would rc4.d be the right place?
View 5 Replies View Relatedi want install oracle 10g to redhat 5 i want to change bash_profile.but I can't find it when I looked to the /home/oracle/..
View 2 Replies View Related