OraFAQ Forum: SQL & PL/SQL » Start DB session using sh script with out the password

Home » SQL & PL/SQL » SQL & PL/SQL » Start DB session using sh script with out the password (10g Release 2)

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

Start DB session using sh script with out the password [message #596643]

Wed, 25 September 2013 07:02

arunprakash647
Messages: 5
Registered: August 2013

Junior Member

Hi,

I am trying to write a shell script to start a DB session without using the DB Password.

Could any one help me in doing this script?

Thanks in advance.

Report message to a moderator

Re: Start DB session using sh script with out the password [message #596646 is a reply to message #596643]

Wed, 25 September 2013 07:21

dariyoosh
Messages: 538
Registered: March 2009
Location: France

Senior Member

Hi,

- Why do you need this? What do you want to do exactly?
- What is the OS?
- What is the context of the authentication (connecting as an administrator or an ordinary user)?
- Have you looked at Secure External Password Store?

Regards,
Dariyoosh

Report message to a moderator

Re: Start DB session using sh script with out the password [message #596649 is a reply to message #596643]

Wed, 25 September 2013 07:37

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The solution depends on where your shell script is executed.
If it is not on the database server then the best solution is Oracle External Secure Password Store (aka Oracle wallet).
If it is on the database server, you can still use this authentication (which is in my opinion the best solution) or you can use OS (aka External) authentication.
You can read an introduction of all possible authentications in Security Guide, Chapter 4 Authentication Methods

Report message to a moderator

Re: Start DB session using sh script with out the password [message #646317 is a reply to message #596649]

Thu, 24 December 2015 15:44

rohit_shinez
Messages: 139
Registered: January 2015

Senior Member

Actually i am not getting how i can hide the password so that no one can't see the actual password basically in encrypt format

Report message to a moderator

Re: Start DB session using sh script with out the password [message #646322 is a reply to message #646317]

Thu, 24 December 2015 16:40

Solomon Yakobson
Messages: 3312
Registered: January 2010
Location: Connecticut, USA

Senior Member

To start database make OS user member of OS group - for Unix/Linux OS groups for Oracle adminstrative access are set in $ORACLE_HOME/rdbms/lib/config.c. For Windows it is ORA_DBA, ORA_OPER, ... Then you can connect without password.

For non SYSDBA activities use Oracle wallet.

SY.

Report message to a moderator

Re: Start DB session using sh script with out the password [message #646323 is a reply to message #646322]

Thu, 24 December 2015 16:45

Solomon Yakobson
Messages: 3312
Registered: January 2010
Location: Connecticut, USA

Senior Member

Also, for activities on local databases you could create OS authenticated Oracle user. I wouldn't recommend OS authentication for remote connections (setting remote_os_authent to true presents security risk).

SY.

Report message to a moderator

Re: Start DB session using sh script with out the password [message #646324 is a reply to message #646317]

Thu, 24 December 2015 17:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

rohit_shinez wrote on Thu, 24 December 2015 13:44

Actually i am not getting how i can hide the password so that no one can't see the actual password basically in encrypt format

like below

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Thu Dec 24 15:19:31 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  456146944 bytes
Fixed Size                  1344840 bytes
Variable Size             348129976 bytes
Database Buffers          100663296 bytes
Redo Buffers                6008832 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@localhost ~]$ id
uid=500(oracle) gid=500(oracle) groups=500(oracle),54323(davfs2)
[oracle@localhost ~]$

Report message to a moderator

Re: Start DB session using sh script with out the password [message #646326 is a reply to message #646317]

Fri, 25 December 2015 06:18

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

rohit_shinez wrote on Thu, 24 December 2015 22:44

Actually i am not getting how i can hide the password so that no one can't see the actual password basically in encrypt format

Read again the links and try them,, it is clear.

Report message to a moderator

Previous Topic:	how to fetch deleted row
Next Topic:	Materialized View

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 21 07:55:19 CDT 2026