RE: Connect sys/password@database as sysdba & E-Business suite

[Mladen Gogala]

Title: Message

You should set remote_os_authent and remote_os_roles  to true, otherwise RMAN will not be able to connect to the remote isntance as

sysdba. On the other hand, you might want to reconsider it, because that would open your instance wide to the various forms of network

attacks.

 

 

--
Mladen Gogala
Oracle DBA

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jack van Zanen
Sent: Friday, September 12, 2003 4:29 AM
To: Multiple recipients of list ORACLE-L
Subject: Connect sys/[EMAIL PROTECTED] as sysdba & E-Business suite

Hi All,

I have seen some weird behaviour and must have been searching in the wrong places.

When logging in to a 9i RAC environment using the syntax sys/[EMAIL PROTECTED] as sysdba it works fine at the primary instance but reports invalid username/password at the secondary instance.

Is this "normal" behaviour?

When connecting to an e-business suite(11.5.9?) database I noticed that my sessions (ODBC & SQL*Plus) were executing the suites portal login procedure.In fact all connections did this.

Also my ODBC connection timed out on tables owned by a none suite schema.

Is there a database logon trigger on e-business suite that forces every connection through the suites security mechanism or something?

(I have never worked with e-business so I know nothing about it, I just installed some monitor tools repository in this database and could not get to the data)

TIA

Jack

 

Note:

This message is for the named person's use only.  It may contain confidential, proprietary or legally privileged information.  No confidentiality or privilege is waived or lost by any mistransmission.  If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender.  You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.  Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.