topic Re: Display dinamically the ORACLE_SID variable value in PS1 in Operating System - HP-UX

Display dinamically the ORACLE_SID variable value in PS1

gaudiobe — Fri, 29 Apr 2011 06:29:04 GMT

I'm triyng to dysplay the $ORACLE_SID value on the prompt.
After setting the ORACLE_SID by command line I wolud like to see it in the prompt.
I tried to change it in the PS1 variable in .profile file but my attempt was unsuccessfully:
PS1="$(echo $ORACLE_SID):\$PWD>

Example:
ORADB1:\> export ORACLE_SID=ORADB2
ORADB2:\>

Have you got any suggest?

Regards,
BG

Re: Display dinamically the ORACLE_SID variable value in PS1

Dennis Handly — Fri, 29 Apr 2011 06:35:58 GMT

The trick is to use single quotes:
PS1='$ORACLE_SID:$PWD> '

Re: Display dinamically the ORACLE_SID variable value in PS1

Joseph Steinhauser — Mon, 06 Jun 2011 14:21:15 GMT

Try this in ksh or sh-posix:

export PS1='${ORACLE_SID:-NoSID},${LOGNAME}[${PWD##*/}]$ '

It should include SID,User, and short PWD in your prompt. Also, if SID is ever unset/null then your prompt will tell you.

Re: Display dinamically the ORACLE_SID variable value in PS1

gaudiobe — Mon, 06 Jun 2011 16:05:37 GMT

Solved.

Thanks for the great support.

Regards,
BG