OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Connect as sysdba

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connect as sysdba [message #58455]

Thu, 28 August 2003 02:49

Dik
Messages: 27
Registered: June 2002

Junior Member

Hi,

1. I connect in OS(Unix) as user Tornado, then I can connect on my database as sysdba like this :

$sqlplus /nolog
sqlplus>connect / as sysdba;
Connected

So, if someone get my Tornado password he can connect on database as sysdba. How can I prevent this!

2. I would like to create a script for shutdown and startup database. How can I hide password in script:
sqlplus user/password
shutdown immediate

Where can I get a cold backup script?

Thanks

Report message to a moderator

Re: Connect as sysdba [message #58458 is a reply to message #58455]

Thu, 28 August 2003 06:46

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

first,
NO user should be allowed to access oracle directly in OS in the server,  exept ORACLE user in DBA group.
and
if your password is compromised (for ORACLE account or any account!), you cannot help anything.

2. there is already a prewritten script supplied by oracle.
$ORACLE_HOME/bin/dbstart-- will start the databases
$ORACLE_HOME/bin/dbshut-- will stop the databases
to make use of these, just edit your oratab file and make changes accordingly.
by defualt these scripts are executed by os user ORACLE.
therefore, no password is required.

Report message to a moderator

Re: Connect as sysdba [message #58469 is a reply to message #58458]

Fri, 29 August 2003 08:37

Kartik Nair
Messages: 15
Registered: August 2003

Junior Member

Set up the correct environment before using setting up the cron for your backups, start or stop the database.

An entry in the oratab will help while bringing down the server itself, so that there is clean shutdon and startup.

Make use of the orapasswd file in your scripts.

Report message to a moderator

Previous Topic:	Install 9.2 On Linux
Next Topic:	Exceptions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:43:27 CDT 2024