Re: How to add...

On Jul 11, 7:49 am, "Malone" <davor.boko..._at_zg.t-com.hr> wrote:
> Oracle enviorment variables in /etc/profile ? You know, ORACLE_SID etc,
> etc...
>
> And one more thing...i want to add emctl start dbconsole to that profile so
> i dont have to start it up manually every time i restart computer..that goes
> for listener too...
>
> Can someone help me..?
>
> I'm going nuts... :(
>
> Im a noob so go easy on me...

Please don't put such items in /etc/profile, as EVERYONE gets that profile set before any others and it creates security issue.

You should have a proper .profile for the 'oracle' user account to set such environment variables; you can pass this profile to any other individual users who will need such access.

The listener should be started (and it will be) provided you use the dbstart/dbshut scripts provided by Oracle; access to these should be configured in the init.d directory via another script, often named 'oracle'. Two links need be created; one in the rc3.d directory to start the oracle processes[ e.g. S99oracle}, one in the rc0.d directory [K09oracle] to kill the oracle processes on a run-level change. (We're using Solaris so this may change for your system -- consult the O/S documentation for how to configure run-level process adminstration). You can also include the call to emctl in this process start/process stop script so it will start/stop when the database and listener do.

The /etc/profile is the default profile for EVERY user; it's wise to understand its use in order to prevent abusing it's power.

David Fitzjarrell Received on Wed Jul 11 2007 - 08:13:07 CDT