Do i need any changes after upgrade of LINUX machine ?

Joy Stick · 03-27-2017, 09:17 AM

Hi All,

I upgraded my Linux Machine to OEL 5.11 from 5.5

>> OEL 5.5 kernal - BEFORE UPGRADE OS VERSION

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 kernal - AFTER UPGRADE OS VERSION

PHP Code:



$ uname -a
Linux AUSDEV 2.6.18-419.0.0.0.1.el5PAE #1 SMP Fri Feb 24 09:20:35 PST 2017 i686 i686 i386 GNU/Linux

>> This is oracle user .bash_profile always i am using

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

~

Wihout any changes of .bash_profile, some commands are NOT worked in 5.11 for oracle user which already worked fine.

$ . .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

PHP Code:



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

Problems are i cannot access sqlplus

$ . .bash_profile

PHP Code:



[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.

1) If i remove oraenv from .bash_profile, why i cannot access db ?
2) can i use above setup for OEL 5.11 also ?
3) My confusions are LD_LIBRARY_PATH and $PATH.

PHP Code:



$ ifconfig
-bash: ifconfig: command not found

Thanks in advance.

Habitual · 03-27-2017, 02:51 PM

dupe reported

rtmistler · 03-27-2017, 03:09 PM

The duplicate is actually a newer question and this thread is the original question. Any members who have insight into the OP's problem, please offer your answers in this thread, the other one has been closed.

@Joy Stick:

You cite certain commands which are no longer working after your upgrade. Perhaps you should cite which commands they are and see also if you have those commands (binaries) on your system. For running commands, the PATH variable matters. The LD_LIBRARY_PATH is a reference for other things, but the actual PATH variable is what controls how to find binary executable files.

smallpond · 03-27-2017, 03:23 PM

Should PATH contain $ORACLE_HOME or $ORACLE_HOME/bin?

Joy Stick · 03-27-2017, 03:29 PM

Hi,

My straight questions are if we upgrade linux machines from one version to another ,
Without any changes , can we proceed ?

My confusions are , on OEL 5.5 everything was fine but problems are in 5.11.
After upgrade to 5.11, problems are coming for oracle user.

Problems are described above

Joy Stick · 03-27-2017, 03:33 PM

Hi,

I am seeing lots of examples.
As a experienced person, can you suggest me where can i make changes in .bash_profile for oracle user ?

Thanks.

michaelk · 03-27-2017, 08:04 PM

Post the contents of the oraenv file.

The dot in the command . oraenv is the source or dot operator. It reads and executes the commands in the oraenv file. I assume that the path for sqlplus is added in that file but it could change the existing path. There is nothing sacred about the path environment and you can change it as desired in your .bash_profile.

Code:

export PATH=$ORACLE_HOME/bin:$PATH:/sbin