Oracle Installation Error On Ubuntu-sqlplus / Command Not Found
Mar 5, 2011
tried installing oracle 10g in ubuntu. i am successful with the oracle installation.i am able to login to sqlplus using oracle OEM,but when i try to login through command prompt , i get the following error:
rakesh@ubuntu:/$ sqlplus "/ as sysdba"
bash: sqlplus: command not found
[color="#000000"][/color]
rakesh@ubuntu:/$ sqlplus
bash: sqlplus: command not found
i have also tried to set the oracle_home, oracle path & oracle SID.
find the below configuration parameters which i have set to.
root@ubuntu:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin# more oracle_env.sh
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export ORACLE_HOME
ORACLE_SID=XE
export ORACLE_SID
#NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
[code]....
View 4 Replies
ADVERTISEMENT
May 7, 2013
I am installing oracle 11g under ubuntu 12.10(32bits) and getting an error 'all_no_orcl' 'ins.rdbms.mk'. It occurs when it tries to invoke the file.my laptop is 32 bits, 30.7 hd, 1.5 GB ram, 2MB cahe. The OS is installed on an external drive.
View 4 Replies
View Related
Feb 17, 2013
I installed oracle 11g on fedora 14 64 bit. i followed the instructions from the oracle docs. successfully installed. even the scripts ran. but when i try to execute dbca command. it says command not found. im in the oracle user acc.
View 10 Replies
View Related
Aug 27, 2013
Provide the installing steps of oracle 12c in ubuntu.
View 3 Replies
View Related
Feb 20, 2013
I am trying to install oracle 11gr1 to my ubuntu 12.10 and when i run ./runInstaller.sh
It said that OS Kernel Parameter: ip_local_port_range failed and the installer create a script to fix it but every time i run the script on terminal, it gives me
'The upper limit of ip_local_port range in response file is not greater than value in /etc/sysctl.conf, hence not changing it.
net.ipv4.ip_local_port_range = 9000 65535
View 11 Replies
View Related
Jun 23, 2010
I am facing one problem we used to copy any document and for open any document in WINDOWS
Host('CMD /C COPY '||'"'||:Old_Doc||'"'||' X:�3�3'||:New_Doc);
Client_Host('Cmd /C Start '||'X:�3�3'||:New_Doc);
But these commands not running in Linux.
View 12 Replies
View Related
Mar 13, 2013
I am installed the Oracle database following the this link .
1.Downloaded 11g express edition
2.Created a new user 'oracle' under the group dba. Following steps are executed using this.
3.unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip and then Converted the rpm to the Ubuntu package
sudo alien --scripts -d oracle-xe-11.2.0-1.0.x86_64.rpm
4.Created /sbin/chkconfig file and added the entries as specified here
5.Created /etc/sysctl.d/60-oracle.conf and added the entries as specified in same link as above.
6.Below steps:
ln -s /usr/bin/awk /bin/awk
mkdir /var/lock/subsys
touch /var/lock/subsys/listener
7.sudo dpkg --install oracle-xe_11.2.0-2_amd64.deb (.deb generated in step 3)
8.sudo /etc/init.d/oracle-xe configure (left the default values as it is)
9.Set the following env variables in ~/.bashrc file
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
export ORACLE_BASE=/u01/app/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:$PATH
[code]....
Now when exectute any SQL statements on SQLplus, i end up with the following error
SQL> select * from dual;
select * from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
I have increased the swap memory as specified in here
free -m
total used free shared buffers cached
Mem: 3901 3428 473 0 182 1988
-/+ buffers/cache: 1258 2643
Swap: 5066 0 5066
View 6 Replies
View Related
Jul 3, 2013
Most of the ones I'm seeing online relate to the database, not the client. I have linux.x64_11gR2_client.zip and and trying to do runInstaller and I get up to perform prerequisite tests and it tells me that I am missing packages and that kernel parameters are wrong. I've tried to run the runfixup.sh file and get a lot of this:
./orarun.sh: 186: [: true: unexpected operator./orarun.sh: 848: [: unexpected operator./orarun.sh: 864: [: unexpected operator./orarun.sh: 882: [: unexpected operator./orarun.sh: 903: [: unexpected operator./orarun.sh: 1052: [: unexpected operator./orarun.sh: 1057: [: unexpected operator./orarun.sh: 1075: [: unexpected operator./orarun.sh: 1085: [: unexpected operator./orarun.sh: 1115: [: unexpected operator./orarun.sh: 1143: [: unexpected operator./orarun.sh: 1189: [: unexpected operator./orarun.sh: 139: [: unexpected operator./orarun.sh: 139: [: unexpected operator./orarun.sh: 1228: [: unexpected operator./orarun.sh: 1284: [: unexpected operator./orarun.sh: 1342: [: unexpected operator./orarun.sh: 1426: [: unexpected operator./orarun.sh: 1451: [: unexpected operator And many of the supposedly missing packages actually are installed. IE: make. I have make 3.81 installed but the installer insists upon make 3.80.
View 3 Replies
View Related
Feb 18, 2011
My problem is i install Oracle 9i enterprise edition 9.0.1.1.1 in windows xp professional but at the time of oracle database confiuration assistent it show me following errors it show:
Not a zip file(End header not found)
View 1 Replies
View Related
Feb 12, 2010
I want to install Toad on Ubuntu 8.04 . provide me link where step by step instruction guide is available
View 3 Replies
View Related
Oct 11, 2012
just now i installed oracle 10.2.0.1 client version in one my linux server. after successfully installation sqlplus is not working .
below are my .profile details.
# Set up the shell variables:
EDITOR=vi
export EDITOR
### Set the umask
umask 022
### Set ulimit
[code].....
View 4 Replies
View Related
Dec 3, 2012
I am getting "ORA-03114: not connected to ORACLE" while installing "Oracle Database 11GR2" on "Oracle RAC 11R2" cluster setup. I am getting this error at the time of "Oracle Database Configuration Assistant" configuration reaches till 39% on HP-UX 11.31 IA64 platform.
View 25 Replies
View Related
May 6, 2013
I downloaded the 11G 64bit for windows and unzipped the files into one folder and ran the setup.exe as an administrator. It opened up the java screen and I chose, create and configure a database. Next screen I chose, Desktop Class, when I click next it dies. It does not show me teh next screen. I went to the appdata folder and saw this error but not sure what to do EXCEPTION_ACCESS_VIOLATION (0xc0000005).
View 10 Replies
View Related
Jan 23, 2010
i have installed oracle 10g. normally with that URL address
we can navigate to this URL in our browser and log in as the SYS user with the associated password, and connect as SYSDBA. Enterprise Manager can be used to perform common database administration tasks... but..,in my system when this procedure is run i'm receiving an error stating that the server cannot be found...
View 5 Replies
View Related
Feb 15, 2013
i am trying to copy the data from a remote database which has Oracle 8i thru Sqlplus copy command to the local database which has Oracle 11gR2.
copy from abc/abc@remote
insert emp_new
using
select *
from emp_old
where rownum < 1001;
is it possible to copy the remote database thru sqlplus copy command ?
View 6 Replies
View Related
Feb 18, 2013
I have some Oracle Databases and sometimes for me is easier to access to the databases with SQLPLUS instead SQLDEVELOPER or TOAD.
But i can't reach to a good configuration of command line prompt to do queries against the database, normaly if it returns a lot o rows and columns it is unreadable.
View 5 Replies
View Related
Feb 19, 2008
how to run dos command from sql prompt.
i.e.
SQL>!DIR
Same can be done in unix using ! character.
SQL>!ls -lrt
View 6 Replies
View Related
Jul 25, 2012
In my sql*plus when i am writing the command ed .It was showing the error as \
SQL> ed
SP2-0110: Cannot create save file "afiedt.buf"
i tried to define the editor by using the command define_editor=notepad;
But still my problem was not solved.
View 2 Replies
View Related
Aug 28, 2012
I am trying to execute the SQLPLUS command (CONNECT) from the stored procedure.It is throwing below error message.
Stored Procedure:
SQL> select user from dual
2 ;
USER
------------------------------
SYS
SQL> create or replace
2 PROCEDURE PROCEDURE1 AS
3 BEGIN
4 sqlplus sys/sys@D as sysdba;
5 --execute immediate 'create user 'kkk' identified by 'kkk';
6 END PROCEDURE1;
7 /
Warning: Procedure created with compilation errors.
SQL> show err
Errors for PROCEDURE PROCEDURE1:
LINE/COL ERROR
-------- -----------------------------------------------------------------
3/9 PLS-00103: Encountered the symbol "SYS" when expecting one of the
following:
:= . ( @ % ;
The symbol ":=" was substituted for "SYS" to continue.
[code]....
View 29 Replies
View Related
Jul 31, 2013
I need to parse .sql file to tree and I can't find how to do it.
(We apply sql files by sqlplus and we have some problems with '/': after anonymous blocks - it haven't applied without '/'; Also not-anonymous block applied twice when we have both ';' and '/'. I need to report about problems before file will apply.) I've tried to use ANTLR with it grammar but it build awful tree.
View 5 Replies
View Related
Jan 21, 2011
I am able to start SQLPLUS from Start | Program files | Oracle - OraHome92 | Application development |
Unfortunately, when trying to start it from the "command prompt" window with the following command SQLPLUS, it generates the infamous error message like
"... unknown etc... "
Any variables i need to change on my client machine ?
View 11 Replies
View Related
Jul 21, 2010
I'm trying to change a password. I can connect to the db then at the SQL prompt I'm using:
alter user <name> identified by <new password>
The dos window comes back with '2' - then just sits there
View 4 Replies
View Related
Jul 29, 2012
I am using the SQL*PLUS COPY command to move the data from my database to another remote database. The data in my database also contains DATETIME format. But since COPY command cannot handle DATETIME format, I am wondering is there any workaround for this.
Note: Due to some limitations, I cannot use other methods like DATABASE LINK or EXPDP/IMPDP commands.
View 12 Replies
View Related
Sep 6, 2010
The way to create a short cut on desktop to have an sql*plus (command line).
i.e. I want to have an short cut on desktop when I click that short cut that would connect me to a specific database with a username and password (which i supply while creating the shortcut-I would provide the database name, username and password)
View 7 Replies
View Related
May 2, 2013
I'm trying to get Oracle 11.2.0.2.0 XE working on Ubuntu 13.04. For some reason I keep getting the error:
"ORA-00845: MEMORY_TARGET not supported on this system".
I have checked several forums for an answer. All problems had something to do with a tmpfs that is too small. I have tried mounting tmpfs of 8G without any luck. I tried both tmpfs and shmfs.
Here's my configuration atm:
Filesystem Size Used Avail Use% Mounted on
/dev/sda6 110G 6.4G 98G 7% /
none 4.0K 0 4.0K 0% /sys/fs/cgroup
udev 7.8G 4.0K 7.8G 1% /dev
tmpfs 1.6G 904K 1.6G 1% /run
none 5.0M 0 5.0M 0% /run/lock
none 6.0G 36K 6.0G 1% /run/shm
none 100M 28K 100M 1% /run/user
/dev/sda1 180M 45M 126M 27% /boot
/dev/sdb1 688G 2.5G 651G 1% /home
/home/ydbondt/.Private 688G 2.5G 651G 1% /home/ydbondt
shmfs 6.0G 36K 6.0G 1% /run/shm
Kernel info:
Linux DELL-YOURI 3.8.0-19-generic #29-Ubuntu SMP Wed Apr 17 18:16:28 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
I also have found another error in clsc.log:
Oracle Database 11g Clusterware Release 11.2.0.2.0 - Production Copyright 1996, 2010 Oracle. All rights reserved.
[ CLSE][1032939328]clse_get_crs_home: Error retrieving OLR configuration [0] [Error opening olr.loc file. No such file or directory]
View 7 Replies
View Related
Dec 24, 2011
I m getting error while installing ORACLE 10.2.0.1 client on windows error is as follows :"The path is more than 1023 character....."
------------------------------------------------------------------------------
my PATH variable contains following value
D:\oracle\product\10.2.0\client_1\bin;C:\Program Files\CA\SC\CAWIN\;E:\oracle\product\10.2.0\db_1\bin;C:\Program Files\Common Files\NetSarang;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\PROGRA~1\CA\SC\CAM\bin;C:\Program Files\CA\DSM\bin
View 1 Replies
View Related
Jun 1, 2012
I have facing a error message(attached) while creating or installing database in my system.
find attached error snap for the your reference only.
View 11 Replies
View Related
Apr 22, 2010
I am trying to install oracle 11g on windows 2003 ent with sp2 , where I am getting an error, The java runtime environment was not found at bin/javaw.exe. hence the oracle universal installer cannot be run.
View 4 Replies
View Related
Aug 9, 2010
I am trying to install oracle 11gR2 64-bit on windows XP 64-bit Operating System, after the completion of the steps where I have to enter the path for the ORACLE BASE and other parameters when I click next and then Finish, I receive an error, you can check in the attachment.
View 11 Replies
View Related
Apr 22, 2011
When Oracle was installed, there was an error in the server's domain name (missing a "."). Is there an easy way to fix this domain name in the Oracle installation after the fact? I know about tnsnames.ora, pfile, system parameters, and I'm pretty sure I can do emagent -config. My concern is that the "Installed Products" would not like the fact that the domain name is now "abc.proj.org" when installation was done on "abcproj.org". The /etc/hosts file had "abcproj.org", and we want to fix it to "abc.proj.org".
I need to reinstall Oracle -- is there a better way?
View 3 Replies
View Related
