General :: Can Not Connect Oracle 11gR2/sqlplus In CentOS5.5?
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
ADVERTISEMENT
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
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
Apr 4, 2011
I am an ex-VMS systems programmer/DBA. I have been given the task of installing Oracle 11gR2 on Linux VMware. I have opened a ticket with Oracle on this, but thought I would see if anyone has already done this.
View 6 Replies
View Related
Nov 3, 2010
I'm trying to install Oracle DB on OpenSuse (is it smart, because it's not certified for that OS?)..and I've set oracle parameters using oracle script, but when I'm runnign through oracle installation, kernel parameters check reports that parametersa are 'n/a', like oracle OS account cannot access those parameters..
View 1 Replies
View Related
Nov 29, 2010
I am working as oracle DBA on 10g . Till last day I had worked on windows platform. Now my company want me to work on Linux platform. I am first time using Linux dont know A,B,C of Linux . I want to connect sqlplus through linux command prompt. I have exported enviornment variable of oracle but I am getting permission denied Below mention steps I ahd followed . Please help me to solve it
[oracle@bhel1 mj]$ ORACLE_SID=V7;export ORACLE_SID
[oracle@bhel1 mj]$ ORACLE_HOME=/usr/lib/oracle/v7/app/oracle/prod
ver;export ORACLE_HOME
[oracle@bhel1 mj]$ PATH=$ORACLE_HOME/bin:$PATH;export PATH
[oracle@bhel1 mj]$ NLS_LANG=AMERICAN_AMERICA.AL32UTF8;export NLS_
[oracle@bhel1 mj]$ LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_P
LIBRARY_PATH
[Code]....
View 1 Replies
View Related
Jul 5, 2011
i have the following script which when run from the linux sercer does not give me the sqlplus prompt. it does the su and leaves it there insted of continuing. The target is to run the script and it shd su and login to sqlplus
<#!/bin/sh
su -l oracle
export ORACLE_SID=MYDB
sqlplus user/password
#>
~
View 2 Replies
View Related
Oct 25, 2010
there is any other way to make oracledb on CentOS 5.4 and HP Proliant DL360 G5 Server fast access from a vb application. modified, reconfigured all to make faster but no use
View 2 Replies
View Related
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
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
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
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
Aug 30, 2010
I am trying to write a script to access sqlplus and use the output to replace the result in another file. But I am having some issues with it (This script is just a test script and I am just trying to print the updated value.
#!/bin/bash
I am not able to post the sqlplus connection, but it works.
bb=$a
[code]....
View 2 Replies
View Related
Aug 30, 2010
I am trying to write a script to access sqlplus and use the output to replace the result in another file. But I am having some issues with it (This script is just a test script and I am just trying to print the updated value.
#!/bin/bash
a=`echo exit|sqlplus -S -L xxx/xxx@xxx @test.sql`
bb=$a
[code].....
View 5 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
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
Feb 3, 2011
how to stup yum in centos5
View 9 Replies
View Related
Mar 30, 2010
could some one give hints tips ideas on how can we install centos 128 mb ram machine with minimal GUI, lowest graphics mode. what are main package i do need to remove it.
View 5 Replies
View Related
Feb 5, 2011
I install Vmware in winxp sp3, then install centos 5.5-i386 release 2 in Vmware. I want to type some command like yum install ..., but where to open system command? I searched the menu applications places system on the top of the desktop, but I am not sure which one is.
View 2 Replies
View Related
Apr 22, 2010
i have recently installed gnom desktop on centos5 and i am having issue regarding login as root when i am in vnc session, i can login as root through ssh but in vnc desktop it keep asking me password if i try to access display control or install software options. secondly it is fixed resolution 600*800 and i dont know how to change it , i cant see the display setting with "system-config-display", it keep asking me root password :/ and when i give password it says incorrect
View 6 Replies
View Related
Mar 4, 2010
I am trying to install CACTI in Centos5.3. Now I am facing two problem. My DAG repository is not working and thats why i am not able to use YUM for CACTI....So i downloaded the cacti-0.8.7e.tar.gz and using this software according to following links
[URL]
But it is of no use ..so can somebody tell me about a tutorial through which i can install cacti without YUM ..IN addition to this if somebody has any clue of how to activate DAG repository in CENTOS 5.3 then i will be delighted.
View 3 Replies
View Related
Jan 26, 2011
i would like to know how to install kde / gnome desktop on centos5 but not use yum,because my yum always fails due proxy problem.
View 3 Replies
View Related
Jan 7, 2009
I have yum installed mysql 5 on Centos5 and I can successfully run queries through shell.However, I want to now allow external access to mysql via some mysql tools (Mysql Administrator/Mysql Query Browser) which is on some windows machines on the same network.Mysql is running on port 3006.When i try connecting through mysql Admin i get the following:Could not connect to the specified instance.MySQL Error Number 2003Can't connect to MySQL server on 'ipaddress' (10065)If you want to check the network connection, please click the Ping button.Googling this I get the impression its something port related, but I have tried what I have found and still no go.When I ping the server I get:
Start Pinging:
Reply from ipaddress: Time=0ms TTL=64
Reply from ipaddress: Time=0ms TTL=64
[code]....
View 5 Replies
View Related
Apr 10, 2011
I am going to allow myself a few cheeky ones next weekend. So I though it would be nice to have a clock on my desktop reminding me of how long to go. Is there a countdown clock I can add to my Gnome desktop? I am using Centos5 & F14.
View 2 Replies
View Related
Apr 1, 2010
I would like to ask today how to open up specific ports in Linux firewall (iptables). Recently I have changed the SSH port in server from 22 to 30022 by typing
Code:
# vi /etc/ssh/sshd_config
Code:
Port 30022
"/etc/ssh/sshd_config" 111L, 3027C
And then for the iptables configuration file:
Code:
# vi /etc/sysconfig/iptables
[code]....
How to configure the iptables properly so that my Windows PC can access the Linux with port 30022?
View 10 Replies
View Related
Jul 16, 2010
I have a problem in gnome desktop.i have started getting a black screen with a X cursor in my centos.see the preview:[URL]
View 3 Replies
View Related
Feb 23, 2011
I will receive a new Dell without any operating systems. I will need to install CentOS-5.5 on this machine. How can install it? What files do I need to download?
My computer will have no OS installed. Which is the easiest way to install, using CentOS-5.5-i386-LiveCD-Release2.iso or CentOS-5.5-i386-bin-DVD.iso? What are the basic procedures?
View 1 Replies
View Related
