LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Closed Thread
  Search this Thread
Old 03-27-2017, 03:16 PM   #1
Joy Stick
Member
 
Registered: Dec 2015
Distribution: RHEL 4.7
Posts: 127

Rep: Reputation: 0
I cannot set environment for Oracle DB


Dear Linux Experts,

I upgraded my LINUX Machine to OEL 5.11 from 5.5


OEL 5.5 details

PHP Code:
# uname -a  
Linux AUSDEV-1.COM 2.6.18-194.el5 #1 SMP Mon Mar 29 20:06:41 EDT 2010 i686 i686 i386 GNU/Linux 
OEL 5.11 details

PHP Code:
# uname -a
Linux AUSUAT 2.6.18-419.0.0.0.1.el5PAE #1 SMP Fri Feb 24 09:20:35 PST 2017 i686 i686 i386 GNU/Linux 
PHP Code:
[root@AUSUAT ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.11 (Tikanga
PHP Code:
[root@AUSUAT ~]# cat /etc/issue
Oracle Linux Server release 5.11
Kernel 
\r on an \

.bash_profile of oracle user

PHP Code:
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME
=$ORACLE_BASE/product/11.2.0/dbhome_1
export LD_LIBRARY_PATH
=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export PATH
=$ORACLE_HOME/bin:$PATH
export EDITOR
=vi
oraenv
alias rlsqlplus
='rlwrap sqlplus'
alias rlrman='rlwrap rman'
rlsqlplus / as sysdba 
$ . .bash_profile
[oracle@AUSUAT ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Mar 28 05:08:05 2017

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to an idle instance.

SQL> exit

Just comment before oraenv

$ vi .bash_profile
..
...
# . oraenv
..
...

Problems are i cannot access sqlplus

$ . .bash_profile
[oracle@AUSUAT ~]$ sqlplus / as sysdba
-bash: sqlplus: command not found

[oracle@AUSUAT ~]$ sqlplus -v
-bash: sqlplus: command not found

[oracle@AUSUAT ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/dbhome_1


I set environment varaible in .bash_profile.
If i remove oraenv from .bash_profile, why i cannot access db ?

Last edited by Joy Stick; 03-27-2017 at 03:21 PM.
 
Old 03-27-2017, 03:59 PM   #2
rtmistler
Moderator
 
Registered: Mar 2011
Location: USA
Distribution: MINT Debian, Angstrom, SUSE, Ubuntu, Debian
Posts: 9,914
Blog Entries: 13

Rep: Reputation: 4948Reputation: 4948Reputation: 4948Reputation: 4948Reputation: 4948Reputation: 4948Reputation: 4948Reputation: 4948Reputation: 4948Reputation: 4948Reputation: 4948
This thread has been closed.

Please do not repost the same question. Instead please wait for LQ members to have a chance to respond. Please also note that some questions may be very difficult for members to address because problems may be unique and complex. Since the other post was made earlier, that one will be left open for consideration.
 
  


Closed Thread


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Error on installing the Oracle Java SE Runtime Environment 6u45 Bouki CentOS 6 01-13-2015 10:03 PM
I am an Oracle Database Administrator working in a SAS environment aigberay Linux - Newbie 7 09-12-2013 04:12 AM
LXer: Oracle(R) Database Standard Edition One and Oracle Enterprise Linux on HP Set New World Record for Price Performance with TPC-C Benchmark LXer Syndicated Linux News 0 06-12-2007 06:01 PM
Linux Environment : Can't open lib '/opt/oracle/instantclient/libsqora.so.10.1 mitesh Linux - Software 0 06-03-2007 01:35 AM
How to Startup Oracle Listener In the Linux Cluster Environment research2004 Linux - Enterprise 1 05-02-2004 12:30 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 04:08 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration