Software :: Unable To Connect Oracle?
Apr 15, 2011I have installed oralce-xe 10g on CentOs. I am facing error while connecting it
SQL> connect
Enter user-name: HR
Enter password:
[code]...
I have installed oralce-xe 10g on CentOs. I am facing error while connecting it
SQL> connect
Enter user-name: HR
Enter password:
[code]...
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 Relatedhow can i connect remotly to Oracle Database using shellscript?.is oracle client is require for connect to oracle db remotly?
View 2 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]...
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.
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).
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.
here's my setup: 32 bit Ubuntu 10.10 with an AMD 2.7GHz processor, and 2GB of RAM.I get Oracle 11G R2 installed, except two things fail near the end of the installation (I think they're both Oracle Net services or something. I broke a cardinal rule by not writing them down. ) I try to use sqlplus through Terminal, but the system can't find sqlplus. I'm assuming it isn't installed. I'm unable to connect to it through JDeveloper.
View 2 Replies View RelatedI'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.
Added the repo and installed Virtualbox.
Added user as vboxusers group
Added the following packages according to the error log
- make gcc kernel-source dkms
Finally /etc/init.d/vboxdrv setup reports an error
Stopping VirtualBox kernel modules done
Uninstalling old VirtualBox DKMS kernel
[Code].....
i am installing oracle database 10g2 in my fedora12 with the help of this link ORACLE-BASE - Oracle Database 10g Release 2 (10.2.0.1) Installation On Fedora 7 (F7)Now i am start my Database using sqlplus:[oraclelocalhost ~]$ sqlplusSQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 16 10:53:47 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.Enter user-name: /as sysdbaConnected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 167772160 bytes
[code]...
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'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.
Currently using oracle 9i with 3 database(maindb,arist,samp) in redhat 5.3 server .I want to stop 2 database "maindb" and "samp" manually ( in XP or Vista we can stop service oraclemaindb and oraclesamp ), but in redhat i dont know how to stop services and how to see currently running oracle services.
View 1 Replies View RelatedWe have a Oracle 11.2 database running on Red Hat 5.5. The database have a scheduled job to fetch some files from another server using ftp, and herein lies the problem.he job runs a pl/sql that runs the function in an (by us compiled) external libraryThe ftp-functionality itself is done by using libncftp and it's API's.The process starts correctly, but then trying to login to the actual ftp host, ncftp only reports "Unknown username/password" (which is not the case).I have the exact same code in an executable and when run from an interactive shell, it works fine.So the only thing I can come up with, is there are differences when the process is started by Oracle, rather then being ordinary" process.And I am stuck.If there are any environment variables, paths etc missing when running the extproc-process, how do I find out which?Because the real problem is NOT wrong user or password.
View 8 Replies View RelatedWhen I do xhost + also it hangs.Without the xclock I am not able to run oracle reports in production for bar code printing as I am not able to start a standalone reports server. Help needed to start xclock and where to look for any help
View 2 Replies View RelatedI'm new to Ubuntu and I'm remote from the server. I'm setting up an Ubuntu server 10.04 x64. My intention is to load Oracle 11g, however I know I will need to be able to export an X display back to my desktop (Solaris) to run the Oracle installer. What do I need to load to get X working enough to export the display back to myself. I need to provide additional information. Since I'm new I may not have adequately covered what's needed.
View 4 Replies View RelatedI 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.
I tried to install vsftpd on my server and while the installation went fine, I can't run
Code:
restart vsftpd
As I the get error
Code:
restart: Unable to connect to system bus: Failed to connect to socket /var/run/dbus/system_bus_socket: No such file or directory Though I'm able to restart the service with
sudo /etc/init.d/vsftpd restart with a warning telling me to use the service utility. Not only that, but despite the port being open it won't allow me to log in, it just hangs, and I have local users enabled (I've used the default .conf file). Does dbus not come installed in 10.04, and if I did install it would it make a difference for restarting the service? Are there further steps needed not available in the tutorial on the Ubuntu Server Guide for 10.04 to enabling local user authentication? -edit- Figured it out, dbus wasn't installed, vsftpd is working fine now.
I install and configure the vncserver following and reading 1000papers, but all of this present the same problem; when i try to connect to my vncserver,recive this mesage: unable connect to socket: No route to host (113) The OS version is Fedora Core 14 and tigervnc-server i try different solutions including:Allow TCP connection modifing files /etc/gdm/custom.conf and /usr/share/gdm/gdm.chemas Disable SELinux removing iptables Here follow the vncserver configuration:
[code].....
The ip address of the vncserver is correct because i can do ssh on it. Where or what can i do?
I'm trying to setup PS3 media server on my new OpenSuse 11.2 and I'm being unable to connect to the PS3. The multimedia server seems to being working ok, only it has not appear on XMB.
I've been searching on PS3 Media Server forums and try a couple of solutions regarding /etc/hosts and adding full qualified domain name of server to it, but it doesn't seems to work.
I am unable to connect to wireless network in ubuntu 10.10.i have noticed that the iwlagn driver isnt been used by anything.
View 9 Replies View RelatedI am trying to setup a dhcp server for my internal network. I have two NICs, a modem, and a wireless router. I have my server connected directly to my modem which is providing me with Internet access on eth1 and is working fine. I have dhcp and dns setup on eth0 which is connected to my router. The router shows that it is connected to the Internet but when the router gives a client computer an IP address, the client is unable to connect to the Internet but can connect to the router. I will post my configuration files below with my current configuration.
[Code]....
I just switched from Ubuntu to Fedora 13 because I was unable to get Ubuntu to connect to wireless networks. I tried everything suggested in help and forums, and kept getting "Bad Password" with WICD and Network Manager. Now, with Fedora...I still can't connect.
Problem #1: The guide says to "...make sure that the relevant wireless interface (usually eth0 or eth1) is controlled by NetworkManager," and that I do this via: System>Administration>Network
However, there is no Network option under System>Administration.
Problem #2: I open Network Manager, which displays a list of networks. I click on mine, configure it with WPA and the right password, and it fails to connect: "The network connection has been disconnected."
I couldn't connect my Micromax 300G modem in Debian Linux. From internet (in Windows Vista), I came across the information of USB_ModeSwitch and then I downloaded it. While going to install it, I came across the problem that TCL-interpreter is not available in Debian Linux. Then again I restarted my laptop in Windows Vista and connected my Micromax modem and from internet downloaded TCL8.5.10-src.tar.gz. But while going to install it, I came across the problem that " configure: error: no acceptable C compiler found in $PATH " . Also as presently, I am unable to connect my modem therefore I am unable to issue the code:" apt-get update ".
View 16 Replies View RelatedI'm trying to connect to the internet on ubuntu, but what ever i do fails. I've tried every thing i possibly can, and when all else failed, i had to come and ask. When i try to connect to the internet, it always says "unable to connect". I have no clue why. I'm choosing the default wired setting. To the side of it, it says never, so that might be the problem?
View 3 Replies View RelatedIn my lan environment i've configured a server with rhel5 and a desktop with fc12.I was unable to ssh between rhel5 & fc12. when i'm trying to login through ssh i was getting following error
[code]...
host - Ubuntu 9.10VM - Debian 5.04Sun vbox$ cat /etc/network/interfacesauto loiface lo inet loopback
# The primary network interface
auto eth0
iface eth0 inet manual
[code]....