I found this...



connect_string
A valid Oracle database connect string, in one of the forms:

name | name/password | [Email Address Removed] | name/[Email Address Removed] Message-----
From: Robert Marz
[mailto:oracledba-ezmlmshield-x3975158.[Email address protected]
Sent: Monday, February 28, 2005 8:46 AM
To: LazyDBA Discussion
Subject: OEM Agent-Jobs - oralogon as sysdba

Hi,

I'm writing a OEM job in oratcl.
My Database and OEM-Version is 9.2.0.6

I have to connect as sysdba.

[...]
[oralogon "sys/[Email Address Removed] as sysdba"]
[...]

won't work.
Connect without "as sysdba" works fine
Connect via sqlplus as sysdba works also.

Anyone did that before and can help?

Thanks in advance

Robbie

PS:
The documentation says:
<doc>
Purpose This function connects to an Oracle server using a connect string
and an optional role. this connection cannot be shared.

Syntax oralogon connect_string [AS] [SYSDBA|SYSOPER|NORMAL]

connect_string See common parameters on "Common Parameters" on page 3-15..
Comments This verb is identical to oralogon except that the returned
connection is not shared. Also, an optional role can be specified.
</doc>



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: see
http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree to
these terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page