topic Re: Re : Oracle profile in Operating System - HP-UX

Re : Oracle profile

Vincent_5 — Wed, 10 Nov 2004 09:38:21 GMT

Hi Guys,
Can anyone help with steps how can I set my profile in oracle so that when I log-in through CDE environment with Oracle account I can start sqlplus at prompt ? Oracle version use 9.2

Currently situation on my server,

when i su - oracle
I can strat sqlplus immediately, and in env I can see the path for ORACLE_HOME=oracle and etc. Please advice???

Regards
Vincent

Re: Re : Oracle profile

Pete Randall — Wed, 10 Nov 2004 09:43:30 GMT

Vincent,

I believe you simply need to set DTSOURCEPROFILE=true in ~/.dtprofile.

Pete

Re: Re : Oracle profile

Vincent_5 — Wed, 10 Nov 2004 09:54:33 GMT

Hi ,
Thanks for the info, but are you referring to setting the DTsource profile with oracle user account??

Regards
Vincent

Re: Re : Oracle profile

Fred Ruffet — Wed, 10 Nov 2004 10:03:08 GMT

I think Pete is talking about the last line in .dtprofile file in your oracle user's home directory (the directory he is in when he logs).

Regards,

Fred

Re: Re : Oracle profile

twang — Wed, 10 Nov 2004 10:04:55 GMT

I have same experience before, see the resolution below:
You can force the system to sources these files by enabling the "loginShell" resource for each of the terminal emulator windows.

To do this on a system-wide basis you will need to create the sys.resources file in the /etc/dt/config/C/ directory and add the following line to this new resource file:

*loginShell: true

The permissions on this file should be 644 :

/usr/bin/chmod 644 /etc/dt/config/C/sys.resources

NOTE: If this file already exists, this resource line can be added to the end of the existing file.

To do this on a per-user basis you will need to create the .Xdefaults file in the user's $HOME directory and add the following line to this new resource file:

*loginShell: true

The permissions on this file should be 644 :

/usr/bin/chmod 755 $HOME/.Xdefaults

NOTE: If this file already exists, this resource line can be added to the end of the existing file.

Both of these changes will take effect with the next login to CDE.

EXPLANATION
The *loginShell resource configures the terminal emulators (Dtterm, HPterm, XTerm) to behave as if the user has 'telnet'-ed or 'rlogin'-ed into the system.

This incorporates the default sequence of reading the /etc/profile and similar files when each new terminal window is opened. Therefore, the environment in the shell window will NOT be the same as as that of the standard CDE session (/usr/dt/bin/dtsession).

Re: Re : Oracle profile

Yogeeraj_1 — Wed, 10 Nov 2004 23:35:20 GMT

hi,

There is a line that needed to be uncommented

dtsource=true

this will allow your .profile to be sourced when you log in to the CDE environment.

hope this helps!
regards
Yogeeraj

Re: Re : Oracle profile

Gerhard Roets — Thu, 11 Nov 2004 06:47:00 GMT

Hi Vincent

Pete was reffering to the oracle user. The ~ is a shortcut for $HOME f the current user.

So the other way of writing it is $HOME/.dtprofile

Regards
Gerhard