bash_profile

[syedhafeez69]

hello.. I have oracle 10g on linux platform. After the installation of oracle i configured bash profile.I configured it correctly, after configuring when i run bash profile by the statement {. .bash_profile} its giving the following errors..
/home/oracle/app/oracle/product/11.1.0/db_1': not a valid identifier
bash: export: `=test': not a valid identifier
PLEASE HELP ME WITH THIS....

[Tim...]

Hi.

It sounds like you've made a mistake in the file.

Please post the contents of the file, so I can see where the mistake is.

Cheers

Tim...

[syedhafeez69]

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs
export $ORACLE_HOME=/home/oracle/app/oracle/product/11.1.0/db_1
export $ORACLE_SID=test
PATH=$PATH:$ORACLE_HOME/bin

export PATH
unset USERNAME
~

OK here is my bash profile.... after this when i run bash profile by the statement {. .bash_profile} its giving the following errors..
/home/oracle/app/oracle/product/11.1.0/db_1': not a valid identifier
bash: export: `=test': not a valid identifier
PLEASE HELP ME WITH THIS....

[Tim...]

Hi.

These two lines are incorrect:

Code: Select all

export $ORACLE_HOME=/home/oracle/app/oracle/product/11.1.0/db_1
export $ORACLE_SID=test

They should be:

Code: Select all

export ORACLE_HOME=/home/oracle/app/oracle/product/11.1.0/db_1
export ORACLE_SID=test

You only use the $ prefix when you are referencing a value from an existing variable. Bot when you are creating a new one or exporting a variable.

Cheers

Tim...

[syedhafeez69]

ok tom thanks for that i got the bash profile correct.. now when i am switching to oracle user by the command { su - oracle } its giving the same error
[-bash: export: `=/home/oracle/app/oracle/product/11.1.0./db_1': not a valid identifier
-bash: export: `=test': not a valid identifier]
but its switching to the oracle user... and after this when i am running sqlplus its again giving the error as
[ -bash: sqlplus: command not found ]..

sorry for inconvenience.. and thanks a lot for the help....

[Tim...]

Hi.

I doesn't look like you've changed anything to me.

Cheers

Tim...

[syedhafeez69]

ok tim here is my bash profile after the changes

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs
export ORACLE_HOME=/home/oracle/app/oracle/product/11.1.0/db_1
export ORACLE_SID=test
PATH=$PATH:$ORACLE_HOME/bin

export PATH
unset USERNAME
~
~
~
~
~
~
~
~
~
".bash_profile" 14L, 283C ...

i seems to get it right.. i need u to have a look at once... thanx

[Tim...]

Hi.

It looks fine. Not sure what can be wrong. What happens if you switch the two lines to:

Code: Select all

ORACLE_HOME=/home/oracle/app/oracle/product/11.1.0/db_1; export ORACLE_HOME
ORACLE_SID=test; export ORACLE_SID

Cheers

Tim...

[syedhafeez69]

its giving the same error tim when i am switching to the oracle user [su - oracle]
-bash: export: `=/home/oracle/app/oracle/product/11.1.0./db_1': not a valid identifier
-bash: export: `=test': not a valid identifier
i think bash profile would have given the error there itself if its not properly configured.... it would have given error at the time of running it{. .bash_profile}
thanks

[Tim...]

Hi.

This does not make sense. I can only assume you are editing the wrong .bash_profile file. Please post the output from the following command:

Code: Select all

cat /home/oracle/.bash_profile

Cheers

Tim...

[syedhafeez69]

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs
export $ORACLE_HOME=/home/oracle/app/oracle/product/11.1.0./db_1
export $ORACLE_SID=test
PATH=$PATH:$ORACLE_HOME/bin

export PATH
unset USERNAME

{ this is the output of the command cat /home/oracle/.bash_profile }

[Tim...]

Hi.

So that is the answer. All the changes I've been asking you to do should have been done in the "/home/oracle/.bash_profile" file, but as you can see you still have the old entries.

Edit this file, changing those two entries to:

Code: Select all

export ORACLE_HOME=/home/oracle/app/oracle/product/11.1.0./db_1
export ORACLE_SID=test

You still have the $ in front of the variables, which is causing the error message.

Cheers

Tim...

[syedhafeez69]

ok Tim i now i got the output of the command [cat /home/oracle/.bash_profile] as : -

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs
export ORACLE_HOME=/home/oracle/app/oracle/product/11.1.0./db_1
export ORACLE_SID=test
PATH=$PATH:$ORACLE_HOME/bin

export PATH
unset USERNAME

after this when i am running sqlplus by the command [sqlplus / as sysdba] its giving the error as
{-bash: sqlplus: command not found}

[Tim...]

Hi.

Your PATH has been set to include "$ORACLE_HOME/bin", which should be the location of the sqlplus binary. If it is not it means one of two things:

1) You've not installed the Oracle software yet.
2) You've installed it, but not into the location you've set your ORACLE_HOME to.

To check you have used the correct path in the ORACLE_HOME definition, run the following command as the "root" user.

Code: Select all

find / -name sqlplus

Post the output of this command here.

Cheers

Tim...

[syedhafeez69]

hi tim..
the output of the command [find / -name sqlplus] is

find: /proc/26431/task: No such file or directory
/home/oracle/app/oracle/product/11.1.0/db_1/sqlplus
/home/oracle/app/oracle/product/11.1.0/db_1/bin/sqlplus