Re: Sqlplus Worksheet connects to wrong database when launched from OEM console

check the sid in your tnsnames.ora file
always do a select from v$datafile if you are not sure if this is the correct database  

-------Original Message-------  

From: oracle-l_at_freelists.org
Date: 07/02/04 13:20:10
To: oracle-l_at_freelists.org
Subject: Sqlplus Worksheet connects to wrong database when launched from OEM console  

Operating System : windows XP service pack 1 Product :: Sqlplus Worksheet
Product Version:: 9.2.0.1  

Sqlplus Worksheet connects to wrong database when launched from OEM console  

I am using OEM console 9.2.0.1 on Win Xp, oms also running on the same machine. Repository is on Win2000 machine.  

When I try to select a database and launch sqlplus worksheet from oem console, it connects to wrong database, in fact the next database in the tree. SQL scratch pad connects fine, and all other products connect fine. If I drop the database from oem console and re add it, it works fine, and after some time problem comes back for some other database  

Does any body else face the same problem? Is there any workaround?  

Thanks
Deen        

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mihalis I. Tsoukalos
Sent: Friday, July 02, 2004 11:29 AM
To: oracle-l_at_freelists.org
Subject: Re: WareHouse example information  

On Fri, Jul 02, 2004 at 06:58:55AM -0500, DENNIS WILLIAMS wrote:
> Mihalis
> Try user_tables, user_indexes, etc. Good chance to get familiar with
the
> Oracle dictionary.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
> I said it "looked" clear - Riddick
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mihalis I. Tsoukalos
> Sent: Friday, July 02, 2004 6:30 AM
> To: Oracle Mailing List
> Subject: WareHouse example information
>
>
> Dear list,
>
> I have installed Oracle 10g (Linux) with the WareHouse example database.
> What I want is to learn more info about this example database (schema
> etc.).
> Where can I find the info?
 

Yes, but which user is the owner of the example database?  

best regards,
Mihalis.  

--
18:27:59 up 13 days, 7:31, 2 users, load average: 0.12, 0.10, 0.03
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
 
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------