General :: Configure Php To Connect With Oracle?
Aug 23, 2010
On 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
ADVERTISEMENT
Mar 28, 2010
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.
View 3 Replies
View Related
Jul 24, 2011
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.
View 1 Replies
View Related
Jan 24, 2011
I need to configure autostart of oracle database 11g & oracle soa suite 11g after successful OS startup. Linux: Redhat version 5. I have commands needed for startup, but not sure on where to keep the file.
View 2 Replies
View Related
Apr 16, 2011
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 Related
Mar 13, 2010
im 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]...
View 7 Replies
View Related
Apr 29, 2011
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.
View 2 Replies
View Related
May 30, 2010
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 Related
Sep 15, 2010
How 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.
View 1 Replies
View Related
Nov 27, 2010
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 Related
Apr 20, 2010
I'm trying to configure DNS on Oracle Enterprise Linux 5.4 - Kernel 2.6.18-128.el5. When I restart the named service, I'm not getting any errors. But service is showing Failed. What could be the reason?
View 3 Replies
View Related
Mar 4, 2010
I'm trying to configure a reverse proxy for Oracle Database connections. What I have:
Host outside --> Reverse proxy --> Oracle Database
The "Revese proxy" has two IP, one for local and another for outside.I've tried with iptables, but unable.Now I'm trying with "redir".When I do a tnsping database, it works and says OK. But executing sqlplus user/pass@database, it tries to connect but time later I receive a timeout. What i do is a redir from port 1521 in "Reverse proxy" to 1521 in "Oracle database" why this doesn't work or any other way to do it?
View 1 Replies
View Related
May 26, 2010
I am a first time Linux user - though I've Unix and Windows experience. So though I can follow your most tech instructions, I'll need some hand-holding.
Need help getting my wireless network to work on my newly installed Oracle Linux on Dell laptop.
Not sure what wireless card is installed, or it's mac address (though I can boot into windows and get that info, I don't want to - it'll be kind of a let down if I can't fix it all thru Linux).
Install has detected a Broadcom wired card, but not the wireless. Funny thing is that it detected the Bluetooth.
View 3 Replies
View Related
Apr 15, 2011
I have installed oralce-xe 10g on CentOs. I am facing error while connecting it
SQL> connect
Enter user-name: HR
Enter password:
[code]...
View 1 Replies
View Related
May 31, 2011
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 Related
Mar 14, 2009
I'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).
View 2 Replies
View Related
Oct 25, 2009
I have a dell wireless wlan 1397 mini card with an ethernet 802.3. Now I am trying to connect by a wired connection. Supposedly a have a bcm5784m nic. I have tried to configue the bcm5784m which was shown it to be regonized through fedora 11, i could activate it, and connection still failed. In my driver list on my dell inspiron and studio 1737 the bcm5784m was not checked as a download i needed. What in the hell am I doing wrong. I have searched exhaustively and have found nothing concerning the wire ethernet card or bcm. Supposidly ubuntu does support the dell studio 1737 laptopForgive my spelling. Oh and by the way I am using kubuntu 9.04 jaunty.
View 5 Replies
View Related
Feb 18, 2010
i want to configure VNC server on Fedora 12 to be able to connect from any place how to configure it i try Google to find instruction about it but i found alot on ways to configure and they are difference what you recommend
View 1 Replies
View Related
Jan 12, 2010
How i can configure sshd to connect ONLY with Public Key Auth?
currentStatus : If you have no key. then you can log in with your password.
View 2 Replies
View Related
Jul 3, 2011
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)
View 3 Replies
View Related
Jan 3, 2011
I tried yesterday with my friend to create ssh server in ubuntu server via vmware on his pc and we're done it, but after typed this (sudo apt-get install openssh-server ) we don't knows what we supposed to do after that, i google it many times but i couldn't find any what i need, all those guides talks about how to connect on ssh in LAN or by useing 192.168.xx.xx but i need to make connect from outside his network, is that mean he need something like domain name or DynDNS ?, my friend got daynamic ip from his isp and i've seen before many websites offers secure shell able to made it connect.
View 1 Replies
View Related
Mar 19, 2011
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 Related
May 24, 2010
My 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).
View 8 Replies
View Related
Oct 23, 2010
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]
View 2 Replies
View Related
Mar 4, 2011
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 Related
May 16, 2011
i need to deploy oracle packaged thorugh unix instead of using SQLplus where in you can directly type the commands.
View 4 Replies
View Related
Jan 12, 2011
i 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 Related
Mar 31, 2010
I 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
View 5 Replies
View Related
Jan 12, 2010
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 Related
Aug 11, 2011
i 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
