Switching user to oracle to connect Oracle 11g DB with 'sysdba' Post: 302628201

Sponsored Content

Top Forums Shell Programming and Scripting Switching user to oracle to connect Oracle 11g DB with 'sysdba' Post 302628201 by NetBear on Monday 23rd of April 2012 05:25:16 AM

04-23-2012

Registered User

Switching user to oracle to connect Oracle 11g DB with 'sysdba'

I need to connect my Oracle 11g DB from shell script with 'sysdba' permissions. To do this I have to switch user from 'root' to 'oracle'.
I've tried the following with no success.

Code:

  su - oracle -c "<< EOF1
        sqlplus -s "/ as sysdba" << EOF2
        whenever sqlerror exit sql.sqlcode;
        set echo off 
        set heading off
    
        shutdown immediate
        startup mount
        alter database archivelog;
        alter database open;
        
        exit;
        EOF2
    EOF1"

I'm getting the following error.

Code:

> [root@vEMS-23 devel]# ./enableArchiveLogs.sh en ERROR: ORA-01031:
> insufficient privileges
> 
> 
> SP2-0306: Invalid option. Usage: CONN[ECT] [logon] [AS
> {SYSDBA|SYSOPER|SYSASM}] where <logon>  ::=
> <username>[/<password>][@<connect_identifier>] [edition=value] | /
> SP2-0306: Invalid option. Usage: CONN[ECT] [logon] [AS
> {SYSDBA|SYSOPER|SYSASM}] where <logon>  ::=
> <username>[/<password>][@<connect_identifier>] [edition=value] | /
> SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting
> SQL*Plus [root@vEMS-23 devel]#

As far as I may understand it fails to authenticate as 'sysdba'. It doesn't occurs if I eliminate 'su - oracle -c' and run script as an oracle user initially.

Any clues?
Thanks in advanced.

Last edited by radoulov; 04-23-2012 at 09:30 AM..

NetBear

View Public Profile for NetBear

Find all posts by NetBear

3 More Discussions You Might Find Interesting

1. Programming

Help on a perl script to connect to oracle ASM as sysdba

I am novice to perl. Can someone guide me on the below query. We have an existing perl script which connects to database to check the disk group status which i wanted to retieve directly from ASM rather than database. This is because, a cluster has more than 4 databases running and a check on...

2. Shell Programming and Scripting

Use perl to connect to Oracle ASM as sysdba

3. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL...

LEARN ABOUT DEBIAN

make-sqldeveloper-package

MAKE-SQLDEVELOPER-PACKAGE(1)			    Oracle SQL Developer Debian package builder 		      MAKE-SQLDEVELOPER-PACKAGE(1)

NAME

       make-sqldeveloper-package - Oracle SQL Developer Debian package builder

SYNOPSIS

       make-sqldeveloper-package [options] <file>

DESCRIPTION

       make-sqldeveloper-package is a utility that builds a Debian package for Oracle SQL Developer.

       The  Oracle  SQL Developer program is governed by the copyright holder (Oracle USA, Inc.), so you may be limited as to what you can do with
       the resulting package (i.e. no redistribution, etc). This utility will simply help you create the Debian package, it is your responsibility
       to  use	the  resulting package acordingly with the OTN license, a copy of which is included in the created package, that you must agree on
       when downloading the source.

       This utility will require you to download the "Oracle SQL Developer  for  other	platforms"  archive  from  <http://www.oracle.com/technet-
       work/developer-tools/sql-developer/> to create the Debian package from.

OPTIONS

       -b|--build-dir <dir>
	      base directory to build package (autogenerated)

       -e|--email <email>
	      local maintainer email (use DEBEMAIL or auto-generate)

       -i|--install
	      install the generated package - needs root privilege (no)

       -k|--keep-dir
	      keep the build directory (no)

       -l|--revision <number>
	      local revision to append to package version (1)

       -m|--maintainer <name>
	      local maintainer name (use DEBFULLNAME or leave empty)

       -r|--root-command <command>
	      command to gain root privilege for package build (fakeroot)

       -u|--upstream-version <version>
	      force the upstream version (autodetected)

       -h|--help
	      display the help screen

       -v|--version
	      show the program version

       <file> the "Oracle SQL Developer for other platforms" archive from <http://www.oracle.com/technetwork/developer-tools/sql-developer/>

AUTHOR

       make-sqldeveloper-package was written by Lazarus Long <lazarus.long@bigfoot.com>.

       This manual page was written by Lazarus Long <lazarus.long@bigfoot.com>, for the Debian project (but may be used by others).

GNU
								    2012-11-13					      MAKE-SQLDEVELOPER-PACKAGE(1)