Hi Tanel I did not mention that w/o the connect string it works
Will look at the password file. I have not tried to run a query in SQL*Plus, will ask the cst to do so. I use a new user for the repository (not apps) Jack -----Original Message----- Sent: Friday, September 12, 2003 1:49 PM To: Multiple recipients of list ORACLE-L Hi! Are you sure that you have correct password file in second instance? Maybe you're using wrong password (or do not have pwdfile) buf on first instance you just belong to os DBA group, thus you can log on using whatever password you provide. If you access your data using ODBC, which username do you use? Is it APPS? Afaik there is no restricting logon trigger in apps, at least up to 11.5.7 there isn't. Try to execute the exact query manually under same user first, to see whether the timeout problem comes from database or ODBC driver. Tanel. ----- Original Message ----- To: Multiple recipients of list ORACLE-L Sent: Friday, September 12, 2003 11:29 AM 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
