RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star

2004-01-30 Thread Igor Neyman
t;. > If you don't want your OracleServiceSID to start the database > automatically, change the value to "FALSE". > This way service will be still running, but you should be able to > startup the database from OEM. > > Igor Neyman, OCP DBA > [EMAIL PROTECTED]

RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star

2004-01-30 Thread Dharminder Softhome
run and I believe I need to study about this more), but not the database. And then from OEM now I can startup the database. My impression was that OEM should be able to do all these tasks itself. Thanks to all others who have replied as well. -Original Message- Igor Neyman Sent: Friday, J

RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star

2004-01-30 Thread Jacques Kilchoer
't want your OracleServiceSID to start the database > automatically, change the value to "FALSE". > This way service will be still running, but you should be able to > startup the database from OEM. > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] Are you sure about that? This

RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star

2004-01-30 Thread Igor Neyman
ange the value to "FALSE". This way service will be still running, but you should be able to startup the database from OEM. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Dharminder Softhome Sent: Friday, January 30, 2004 2:20 PM To: Multiple recipients of list OR

RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star

2004-01-30 Thread Mercadante, Thomas F
Well, you can't. Windows is different from other systems in that you have these "services" that have to be running in the background. Once the services are running, you can use OEM to shutdown and startup the database. But the service has to be running first. Sorry. Have yo

RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star

2004-01-30 Thread Thomas Day
Dharminder Softhome"To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star

RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star

2004-01-30 Thread Dharminder Softhome
Tom, As stated earlier, here the intention is to startup the database using OEM only and without using windows service. As for as I understand if the OracleServiceSID is properly setup and if startmode for the service is set to automatic then it will startup the database automatically once you

RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to start a dedicated ....

2004-01-30 Thread Dharminder Softhome
, 2004 12:39 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Starting Database from OEM 9.2 gives ORA-12500 Failed to start a dedicated There is not enough memory to start a dedicated connection. so change the server mode from dedicated to shared, (you can do it change some

Re: Starting Database from OEM 9.2 gives ORA-12500 Failed to start a dedicated ....

2004-01-30 Thread Vélez
, then you have to assign one listener port for each database.   hope this helps   Mauricio Vélez Oracle DBA     Dharminder Softhome <[EMAIL PROTECTED]> wrote: Hey all,Following is the environment.Windows 2000Oracle Enterprise 9.2,OEM 9.2I have two 9.2 database installed on my system.

RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star

2004-01-30 Thread Jared . Still
/30/2004 07:44 AM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:                 Subject:        RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star Dharminder, Changes the service to AutoStart when th

RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star

2004-01-30 Thread Mercadante, Thomas F
of list ORACLE-L start a Thomas, That is the real problem. I can start the database using Windows 2000 OracleServiceSID. But I want to start up the database using OEM only. Thanks. -Original Message- Thomas Day Sent: Friday, January 30, 2004 9:19 AM To: Multiple recipients of list ORACLE

RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to start a

2004-01-30 Thread Dharminder Softhome
Thomas, That is the real problem. I can start the database using Windows 2000 OracleServiceSID. But I want to start up the database using OEM only. Thanks. -Original Message- Thomas Day Sent: Friday, January 30, 2004 9:19 AM To: Multiple recipients of list ORACLE-L start a Go to the

Re: Starting Database from OEM 9.2 gives ORA-12500 Failed to start a

2004-01-30 Thread Thomas Day
inder Softhome"To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Starting Database from OEM 9.2 gives ORA-12500 Failed to s

Starting Database from OEM 9.2 gives ORA-12500 Failed to start a dedicated ....

2004-01-29 Thread Dharminder Softhome
Hey all, Following is the environment. Windows 2000 Oracle Enterprise 9.2, OEM 9.2 I have two 9.2 database installed on my system. OEM is configured properly. One of the database is in automatic startmode and this DB contains OEM repository. I start the machine, open OEM, login to OEM and then

Looking for OEM 9i book(s)

2004-01-15 Thread Boivin, Patrice J
Title: Message Are there any good 3rd party OEM 9i books out there?   I know OEM 10G is the new version, but I am looking for a 9i one right now.   Specifically on PM and on CP.   Thanks.   Patrice.

RE: 9i OEM/tools to monitor 8i instances

2004-01-15 Thread Nikhil Khimani
Repost ... -Original Message- Sent: Wednesday, January 14, 2004 9:14 AM To: '[EMAIL PROTECTED]' L&G, Has there been any issue monitoring and administering 8i databases using 9i tools? I am seeing some strange behavior when using 9i OEM tools to monitor 8.1.7.

9i OEM/tools to monitor 8i instances

2004-01-14 Thread Nikhil Khimani
L&G, Has there been any issue monitoring and administering 8i databases using 9i tools? I am seeing some strange behavior when using 9i OEM tools to monitor 8.1.7.0 database and unfortunately I can not reproduce on a consistent basis. TIA, Nikhil -- Please see the official ORACLE-L FAQ:

password hash and db link is a risk (was OEM permissions)

2003-12-24 Thread Pete Finnigan
Hi There are risks with knowing the password hash for any user not just system. Unfortunately reading it from dba_users is not the only way to get it. There are a number of other options as well that i won't go into here. As Arup pointed out the password hash is calculated from the username and p

RE: Risk of knowing password hash value (Was: OEM permissions)

2003-12-23 Thread Bellow, Bambi
Looks like they're using VMS's algorithm. *That's* a shocker! -Original Message- Sent: Tuesday, December 23, 2003 3:45 PM To: Multiple recipients of list ORACLE-L Actually, the concatenated string of userid and password is hashed. So if that is same, you got yourself the same hashed pas

RE: Risk of knowing password hash value (Was: OEM permissions)

2003-12-23 Thread Davey, Alan
Very Nice. I didn't know how the 2 values were used within the hashing algorithm. I would have thought it was a little more complex. - Alan Davey Senior Analyst/Project Leader Oracle 9i OCA; 3/4 OCP w) 973.267.5990 x458 w) 212.295.3458 -Original Mes

RE: Risk of knowing password hash value (Was: OEM permissions)

2003-12-23 Thread Jared Still
You could conceivably do this, much like lopht or crack. It would take a rather large password database, and a cracker with some intelligence. This is the same reason that unix now uses shadow passwords. Jared On Tue, 2003-12-23 at 12:29, Norris, Gregory T [ITS] wrote: > Not really... you coul

Re: Risk of knowing password hash value (Was: OEM permissions)

2003-12-23 Thread Arup Nanda
Actually, the concatenated string of userid and password is hashed. So if that is same, you got yourself the same hashed password. Consider this: SQL> create user ABC identified by DEF; User created. SQL> create user ABCD identified by EF; User created. SQL> select password from dba_users whe

RE: Spam: RE: Risk of knowing password hash value (Was: OEM permi

2003-12-23 Thread Stephen.Lee
I wonder if there is a pre-encrypted list available of all Monty Python words, Babylon 5 words, Star Trek words, etc. etc. Actually, I can't think of any better password than LEXADOIG. > -Original Message- > > Not really... you could easily compile a list of passwords > and their assoc

RE: Risk of knowing password hash value (Was: OEM permissions)

2003-12-23 Thread Norris, Gregory T [ITS]
Ah, you're right... the username is taken into account when the password is hashed. Quite a few applications have forced usernames, however, so I'm still a bit uneasy. It's clearly not as bad as I thought, however. -Original Message- Davey, Alan Sent: Tuesday, December 23, 2003 2:59 PM

RE: Risk of knowing password hash value (Was: OEM permissions)

2003-12-23 Thread Davey, Alan
No. Two different users with the same password would have different hash values. So you would have to loop through a "dictionary list" for each user within your local database. Once you got a match, then you could logon to the target database with that user/password combo. --

RE: Risk of knowing password hash value (Was: OEM permissions)

2003-12-23 Thread Norris, Gregory T [ITS]
Not really... you could easily compile a list of passwords and their associated hashes. Once this is done, it's just a simple matter of matching the hashes. -Original Message- Jared Still Sent: Tuesday, December 23, 2003 1:24 PM To: Multiple recipients of list ORACLE-L As long Oracle c

RE: Risk of knowing password hash value (Was: OEM permissions)

2003-12-23 Thread Jared Still
As long Oracle can manage to keep its modified DES algorithm secret, this should make it somewhat difficult to crack passwords in the manner that can be done with unix passwords. It could still be done, but the time required would make it just too time consuming IMO. Jared On Tue, 2003-12-23

RE: Risk of knowing password hash value (Was: OEM permissions)

2003-12-23 Thread Stephen.Lee
When I brought the issue up, I didn't know if one could in fact maliciously use that info. And, as I originally stated, it was something I had not tried. But paranoia (healthy, I think) dictates there's gotta be a way. When one looks at the Unix password world which brought about the necessity f

RE: Risk of knowing password hash value (Was: OEM permissions)

2003-12-23 Thread Norris, Gregory T [ITS]
Same here... SQL> select password from dba_users where username = 'SCOTT'; PASSWORD -- F894844C34402B67 -Original Message- Michael Thomas Sent: Monday, December 22, 2003 10:44 PM To: Multiple recipients of list ORACLE-L Hi, Okay. I'm almost a believer of th

RE: Risk of knowing password hash value (Was: OEM permissions)

2003-12-23 Thread Jamadagni, Rajendra
[EMAIL PROTECTED]> . oraenv ORACLE_SID = [OLDNCS1] ? DEVL [EMAIL PROTECTED]> sys SQL*Plus: Release 9.2.0.2.0 - Production on Tue Dec 23 08:30:45 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production W

RE: Risk of knowing password hash value (Was: OEM permissions)

2003-12-23 Thread Scott Canaan
This is what I got, Oracle 8.1.7.4 on Sun Solaris (I dropped the user): Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option JServer Release 8.1.7.4.0 - Production SQL> create user scott identified by tiger; User created. SQL> select password 2

Re: Risk of knowing password hash value (Was: OEM permissions)

2003-12-23 Thread Rachel Carmichael
9.2.0.2 on Sun Solaris... and yes, I got the same encrypted password --- Michael Thomas <[EMAIL PROTECTED]> wrote: > Hi, > > Okay. I'm almost a believer of this as a problem. How > about 9.2.0.4 on RH9.3. > > 1) What does anyone/everyone get for my this query (my > results shown): > > connect

Re: Risk of knowing password hash value (Was: OEM permissions)

2003-12-22 Thread rahul sharma
8.1.7 on win2000 SQL> select password 2 from dba_users 3 where username = 'SCOTT'; PASSWORD -- F894844C34402B67 - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, December 23, 2003 11:44 AM > Hi, > >

Re: Risk of knowing password hash value (Was: OEM permissions)

2003-12-22 Thread Jared Still
Yes, I misunderstood. Once I change the password, I can no longer connect to the account. My hasty little test was missing an important condition: I should have pretended I didn't know the password to the other database, which would prevent me from logging back on exploiting the db link. Wonder

Re: Risk of knowing password hash value (Was: OEM permissions)

2003-12-22 Thread Jared Still
On RH 8.0 Oracle 9.2.0.4: F894844C34402B67 It is required that a password for a particular users always hashes to the same value, regardless of platform or Oracle version. This has been true for as long as I have used oracle: since 7.0.13. If not, export/import would not be able to recreate use

Re: Risk of knowing password hash value (Was: OEM permissions)

2003-12-22 Thread Jared Still
It doesn't matter which account I logged into DB2 with, as long as that account has privileges to read DBA_USERS. SYSTEM was used simply because it was the only account on the database that could be logged into remotely, so my test could be run without switching between machines. If I had grante

Re: Risk of knowing password hash value (Was: OEM permissions)

2003-12-22 Thread Michael Thomas
Hi, Okay. I'm almost a believer of this as a problem. How about 9.2.0.4 on RH9.3. 1) What does anyone/everyone get for my this query (my results shown): connect system/[EMAIL PROTECTED]; alter user scott identified by tiger; -- select password from dba_users where username = 'SCOTT'; PASSWORD -

Re: Risk of knowing password hash value (Was: OEM permissions)

2003-12-22 Thread Yong Huang
Jared, I see you log out and log back in as SYSTEM to DB2. But how do you know the password for SYSTEM to log back in with after you change it? What if you don't log out? When I tried that (i.e. not logging out), I got ORA-1017. Yong Huang --- Jared Still <[EMAIL PROTECTED]> wrote: > Environmen

Re: Risk of knowing password hash value (Was: OEM permissions)

2003-12-22 Thread Jared Still
Environment: DB1: RH 8.0 with Oracle EE 9.2.0.4 DB2: Win2k SP3 with Oracle EE 9.2.0.1 SYSTEM user on each database initially have different passwords. It goes something like this: DB1: select password from dba_users where username = 'SYSTEM'; Let's say the result is 'AC424SDK4398' DB2: Log

Risk of knowing password hash value (Was: OEM permissions)

2003-12-22 Thread Yong Huang
Hi, Gregory, I only have access to Oracle 9.2 on my laptop. Here's my test. I have ORCL and AUX1 databases, the latter created by RMAN DUPLICATE some time ago. I logon AUX1 as SYSTEM. Set SYSTEM password hash value to the same as in ORCL. Create link L to ORCL without password. Selecting from a ta

RE: OEM permissions

2003-12-20 Thread Norris, Gregory T [ITS]
There's no reason I can see that he couldn't create the dblink first, and then reset the password using the encrypted value. Alternately, the dblink could be created using the DBMS_SYS_SQL package... no knowledge of the current password required. create database link foo conn

RE: OEM permissions

2003-12-20 Thread Thomas A. La Porte
I believe the point is not that you can create links to SYS or SYSTEM accounts, but instead to application accounts, e.g. if I created a link from my private database to the company's HR database using a duplicated HR_MANAGER schema, I may be able to access data that I otherwise should not have

RE: OEM permissions

2003-12-20 Thread Jared Still
You could use protocol.ora to specify which machines are allowed to make a connection to the database. In some environments this would be fairly painless. SAP for example. The users do not connect to the database, they connect to the app server. The number of machines that legitimately require

RE: OEM permissions

2003-12-20 Thread Yong Huang
Hi, I think you're describing a real security hole. But I'm not sure how it's exploited exactly. Let's say John Doe sets up his database on his desktop, which is part of the production database network. He sees the hash value of SYSTEM's password on production and sets the hash value for his own S

RE: OEM permissions

2003-12-19 Thread Jamadagni, Rajendra
That's why we have scripts which give us a report every few days on users that have db_links, any of the *_ANY_* privs (like alter any table), dba privs etc, also a list of some sensitive schemas too. Our application support needed to work with users to grant/revoke roles and private synonyms.

RE: OEM permissions

2003-12-19 Thread Jesse, Rich
Sure it does, just not by default. Check out the 07_DICTIONARY_ACCESSIBILITY parameter. Enjoy! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Friday, December 19, 2003 11:

RE: OEM permissions

2003-12-19 Thread Stephen.Lee
2003 12:34 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: OEM permissions > > > A possibly related question: > I'm curious if everyone allows your developers to see > V$SQL... views? If not, then ... whatever ... no > comment. > > I'm disap

RE: OEM permissions

2003-12-19 Thread Michael Thomas
> him. > > Yong Huang > > Jamadagni, Rajendra wrote: > > Dennis, > > "select any table" has to be a big no no ... anyone > can select from sys.link$. > But I am still trying how OEM can be used for > _development_?? what am I > missing? As for ...

RE: OEM permissions

2003-12-19 Thread Yong Huang
Rajendra wrote: Dennis, "select any table" has to be a big no no ... anyone can select from sys.link$. But I am still trying how OEM can be used for _development_?? what am I missing? As for ... One of our groups hired a new consultant and he (claimed to have DBA background) immediately sh

RE: OEM permissions

2003-12-19 Thread jo_holvoet
I believe a role 'OEM_MONITOR' is created in 9i when you create a DB; pre-9i you can create it yourself (via catsnmp.sql or something like that) and you can use that instead of granting specific other privileges. Oracle claims that it contains a minimum set of privileges for OEM use,

RE: OEM permissions - thanks!

2003-12-18 Thread DENNIS WILLIAMS
a DBA. He says that he prefers to use OEM instead of Toad. What I'm really asking is what could these grants be used for besides just reading data? If there are other actions that could be done, I could at least ask him not to perform those actions, so if something bad happens I have provid

RE: OEM permissions

2003-12-18 Thread Odland, Brad
I would say OEM for dbas only. To difficult to manage for developers. Dangerous. Too much low level stuff for managers and developers to poke around with. OEM is not really a development tool. 2 cents -Original Message- Sent: Thursday, December 18, 2003 8:24 AM To: Multiple

RE: OEM permissions

2003-12-18 Thread Mercadante, Thomas F
Dennis, I think you are probably ok with this. But the best way to do this is to create an Oracle account, grant what he asks, and start OEM using that account. Try and change things and see what happens. Then you will know for sure what the impact is. Good Luck! Tom Mercadante Oracle

RE: OEM permissions

2003-12-18 Thread DENNIS WILLIAMS
nt as a DBA. He says that he prefers to use OEM instead of Toad. What I'm really asking is what could these grants be used for besides just reading data? If there are other actions that could be done, I could at least ask him not to perform those actions, so if something bad happens I have pro

RE: OEM permissions

2003-12-18 Thread Stephen.Lee
Wouldn't this allow viewing DBA_USERS? I haven't tried this myself, but it seems that I could set up another oracle instance, create a user identified by values, then create database link. > -Original Message- > > We have a new manager that wants his group to use

RE: OEM permissions

2003-12-18 Thread Jamadagni, Rajendra
Dennis, "select any table" has to be a big no no ... anyone can select from sys.link$. But I am still trying how OEM can be used for _development_?? what am I missing? As for One of our groups hired a new consultant and he (claimed to have DBA background) immediately shot off an em

OEM permissions

2003-12-18 Thread DENNIS WILLIAMS
We have a new manager that wants his group to use OEM for development access, as an alternative to Toad. He has requested a special Oracle userid with the following grants: SELECT_CATALOG_ROLE SELECT ANY DICTIONARY SELECT ANY TABLE Does this seem reasonable for OEM? The manager is

OEM: How to add Tunneling DB?

2003-12-04 Thread jaysingh1
Hi List, I have OEM which is running on my local NT box. OEM repository is located in my local database/NT box. I am connecting to all the databases which is running on Solaris thru tunneling for all DML and DDl activity. Now I would like to add the databases which are running on Solaris to my

OEM: Could not locate dispatch for OEM SDK

2003-12-04 Thread jaysingh1
Hi List, When I try to open SQL Analyze utility from OEM, getting the following error in pop-up window. "Could not locate dispatch for OEM SDK." "VDOShell.exe" CLSIDFromProgID failed for ProgID OracleSMPConsole2" Any help would be appreciated. -- Please see

Unable to view reports in web browser using OEM console.

2003-11-19 Thread dharminder
I have been using the following setup. Windows 2000 Prof. / Oracle 9.0.1 / OEM 9.0.1 While using OEM console, when I want to view the database report, it just popup a DOS windows, but it does not show the report in the web browser. But on the other hand, I can view the reports by opening the web

Re: how to drop an oem repository?

2003-10-14 Thread Jose Luis Delgado
Ryan... try this: 1.- Backup your $ORACLE_HOME/sysman/config directory files 2.- Delete them (or rename them, as you wish). 3.- Try again your DBCA. HTH JL --- Ryan <[EMAIL PROTECTED]> wrote: > I dropped an oem repository using the oem > configuration assistant. Im now tryin

how to drop an oem repository?

2003-10-14 Thread Ryan
I dropped an oem repository using the oem configuration assistant. Im now trying to use the GUI to create a new one. It says that I cannot create a new one, becuase another OEM 'service' exists. I dropped the user and the tablespace. How do i get rid of the service so i can make

Re: how to drop an oem repository?

2003-10-14 Thread Ryan
ignore i figured it out. - Original Message - From: Ryan To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 14, 2003 2:14 PM Subject: how to drop an oem repository? I dropped an oem repository using the oem configuration assistant. Im now

Re: OEM Problem?

2003-10-14 Thread Gaja Krishna Vaidyanatha
prompted for the password, type it in. Bottom line is that you need to use "double quotes" around the username, needs to be in upper case. Hope that helps, Gaja --- Ryan <[EMAIL PROTECTED]> wrote: > for some reason when i created the OEM repositiory > the OEM assistan

OEM Problem?

2003-10-13 Thread Ryan
for some reason when i created the OEM repositiory the OEM assistant created the following username.   OEM_RYAN-2LE36OFJCE_OEMREP   I cant connect to this user, drop it or alter it because of '-' in the name. how do i get rid of the repository and start over?    

RE: probe database using OEM event or job

2003-09-30 Thread Reardon, Bruce (CALBBAY)
Hi, Can you just use the built in OEM event "Database UpDown" - though perhaps this only comes with the Diagnostics Pack for OEM. As for a user defined test - You could just do something like "select user from dual" and hope it comes back if it can't connect - I haven

Re: probe database using OEM event or job

2003-09-30 Thread Tanel Poder
Title: probe database using OEM event or job On unix you could do:   while true; do tnsping ALIAS > out || mail [EMAIL PROTECTED] < out; sleep 300; done;   (obviously you have to replace ALIAS and e-mail address there) It will send you the tnsping output if it happens to fail. (you&#x

probe database using OEM event or job

2003-09-30 Thread Baylis, John
Title: probe database using OEM event or job Can someone help me with this? Running Oracle 9.2.0.3 under win2000 I have an application server that occasionally looses connectivity with the listener on the database server although other application servers have no problems connecting. I

9iAS OEM web site screens

2003-09-15 Thread Boivin, Patrice J
Is there a way to speed up the response time from these screens? (at port 1810) Sometimes it takes up to a minute before the screens come back. Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Service

RE: Jobs and OEM... how to

2003-09-09 Thread Igor Neyman
> Perl and cron. > > > -Original Message- > Sent: Tuesday, September 09, 2003 10:04 AM > To: Multiple recipients of list ORACLE-L > > > Hi to everybody!! > > I would like to create a job that EXPort my > database, > but... I *do not* want to use OEM. >

RE: Jobs and OEM... how to

2003-09-09 Thread Jack van Zanen
How about a shell script, scheduled with AT or CRON? -Original Message- Sent: Tuesday, September 09, 2003 5:04 PM To: Multiple recipients of list ORACLE-L Hi to everybody!! I would like to create a job that EXPort my database, but... I *do not* want to use OEM. OEM uses tcl and the

RE: Jobs and OEM... how to

2003-09-09 Thread Jose Luis Delgado
ber 09, 2003 10:04 AM > To: Multiple recipients of list ORACLE-L > > > Hi to everybody!! > > I would like to create a job that EXPort my > database, > but... I *do not* want to use OEM. > > OEM uses tcl and the intelligent agent to schedule > its > jobs... >

RE: Jobs and OEM... how to

2003-09-09 Thread Stefick Ronald S Contr ESC/HRIDD
Title: RE: Jobs and OEM... how to Perl and cron. -Original Message- From: Jose Luis Delgado [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 09, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Subject: Jobs and OEM... how to Hi to everybody!! I would like to create

Jobs and OEM... how to

2003-09-09 Thread Jose Luis Delgado
Hi to everybody!! I would like to create a job that EXPort my database, but... I *do not* want to use OEM. OEM uses tcl and the intelligent agent to schedule its jobs... how can I create a job that can export my database? (no problem if I have to program with tcl files) Any ideas? any sample

Re: OEM

2003-08-25 Thread Nuno Souto
S. Don't say that in front of any of the Oracle boffins... It's like a religion. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, August 25, 2003 4:29 AM > > Piece of junk. I'll stick with the scrip

Re: OEM

2003-08-24 Thread Jared Still
Last night I decided to give OEM another try. Launched the configuration manager, installed the repository, so far, so good. Tried to discover a couple of nodes. First tried rsysdevdb, a linux box with 8.1.7 and 9.2.0 on it. Since there is no agent running there, I had the opportunity to

Re: OEM

2003-08-24 Thread Yechiel Adar
We use OEM 9.2.01 with 8.16. Some of the features does not work but everything that should work is working.   BTW - Anybody knows if the SQL tuner in OEM know about the CASE already?   Yechiel AdarMehish - Original Message - From: AK To: Multiple recipients of list ORACLE

Re: OEM

2003-08-21 Thread Hemant K Chitale
I am able to use OEM 9.2.0.1 against 8.0.4-8.0.6 and 8.1.6-8.1.7 databases. Hemant At 08:59 AM 20-08-03 -0800, you wrote: Does OEM 9.2.0.1 works well with 8.1.7.4 database ? or in general with all versions of databases (7.3,8.0,8i,9i ) ? Does it recognise underline db version and sends

RE: OEM

2003-08-20 Thread Ruth Gramolini
Have a look at the compatibility matrix for OEM. 9.0.2.3 doesn't do everything it should with 8.0.x and 8.1.7 doesn't run on XP machines. There are alot of caveats so check the specs for your combination. Ruth > -Original Message- > From: [EMAIL PROTECTED] [mailto:

Re: OEM

2003-08-20 Thread Jay Hostetter
In my experience, OEM doesn't work well with any version. >>> [EMAIL PROTECTED] 08/20/03 12:59PM >>> Does OEM 9.2.0.1 works well with 8.1.7.4 database ? or in general with all versions of databases (7.3,8.0,8i,9i ) ? Does it recognise underline db version and sends comman

OEM

2003-08-20 Thread AK
Does OEM 9.2.0.1 works well with 8.1.7.4 database ? or in general with all versions of databases (7.3,8.0,8i,9i ) ? Does it recognise underline db version and sends commands appropriately . Any Idea ?   thanks, -ak  

change manager in OEM

2003-08-14 Thread AK
Do you guys use change Manager in OEM. At first instacce it looked appealing to me . I had seen other code management softwares but they were limited to "only program code " management  .Everytime some tables or schema change occure you have write bunch of scripts to propagate tho

Oracle Tools Comparable with OEM ?

2003-07-31 Thread VIVEK_SHARMA
Any Oracle Tools Comparable with OEM having  Free Evaluation Copy or Freeware for Download  ?   Any names ,  Links etc ?   Thanks  

RE: OEM Repository Problem

2003-07-15 Thread Munish Bajaj
\omsconfig.properties At 10:14 PM 7/14/2003 -0800, you wrote: >Hi Listers, > >I had OEM repository on my database installed on my PC. > >Accidentally I dropped the database. Now I have recreated the database. >But an not able to use this database to create New OEM repository as the >OEM confi

Re: OEM Repository Problem

2003-07-15 Thread Wolfgang Breitling
This is a shot in the dark, but try and delete (or rename) \sysman\config\omsconfig.properties At 10:14 PM 7/14/2003 -0800, you wrote: Hi Listers, I had OEM repository on my database installed on my PC. Accidentally I dropped the database. Now I have recreated the database. But an not able to

OEM Repository Problem

2003-07-14 Thread Munish Bajaj
Hi Listers,   I had OEM repository on my database installed on my PC.   Accidentally I dropped the database. Now I have recreated the database. But an not able to use this database to create New OEM repository as the OEM config assistant says that the database already had a repository

Re: OEM tools

2003-07-09 Thread Gabriel Aragon
]> wrote: > > Tools -> Tuning Pack -> Tablespace Map > > - Kirti > > --- Gabriel Aragon <[EMAIL PROTECTED]> wrote: > > Hi, I'm using the OEM 92010 with oracle 92 when I > look > > for the option "SHOW TABLESPACE MAP" I can't find >

RE: OEM tools

2003-07-09 Thread Jesse, Rich
From: Kirtikumar Deshpande [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 09, 2003 1:40 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: OEM tools > > > > Tools -> Tuning Pack -> Tablespace Map > > - Kirti > > --- Gabriel Aragon <[EMAIL PRO

Re: OEM tools

2003-07-09 Thread Kirtikumar Deshpande
Tools -> Tuning Pack -> Tablespace Map - Kirti --- Gabriel Aragon <[EMAIL PROTECTED]> wrote: > Hi, I'm using the OEM 92010 with oracle 92 when I look > for the option "SHOW TABLESPACE MAP" I can't find it, > I remember using the OEM with 806 oracle DB

RE: OEM tools

2003-07-09 Thread Mercadante, Thomas F
e recipients of list ORACLE-L Hi, I'm using the OEM 92010 with oracle 92 when I look for the option "SHOW TABLESPACE MAP" I can't find it, I remember using the OEM with 806 oracle DB and that option was available choosing STORAGE->TABLESPACES->tb_name and then clic

OEM tools

2003-07-09 Thread Gabriel Aragon
Hi, I'm using the OEM 92010 with oracle 92 when I look for the option "SHOW TABLESPACE MAP" I can't find it, I remember using the OEM with 806 oracle DB and that option was available choosing STORAGE->TABLESPACES->tb_name and then click right button, in the database&#x

Re: OEM 9i - saving/copying reports between repositories

2003-06-30 Thread Kaing, Leng
up with an answer rather than just the usual "not possible". Seems like I always get this reply with any questions relating to OEM. This thing looks good on the surface but if you try to do anything complicated... --- From: =?iso-8859-1?q?arun=20chakrapani=20rao

Re: OEM 9i - saving/copying reports between repositories

2003-06-27 Thread arun chakrapani rao
the files are stored in oem_webstage directory you will have to copy these files to the other location and give the path. As you must be knowing  the oem reporting server should have the management server running on the same machine. when you remove default reporting from the console it doesnt

OEM 9i - saving/copying reports between repositories

2003-06-26 Thread Kaing, Leng
G'day all, I've create a number of custom reports in one of our OMS and would copy them into another OMS. How does one go about doing this? Where are the reports stored? Is there a file that we can copy around? Or if we look at the problem in another way - OEM itself comes with a

RE: OEM question

2003-06-20 Thread Thater, William
Stephen Lee scribbled on the wall in glitter crayon: > The old simple snapshot replication is OK. It's just that some of > this later stuff makes you think they rounded up all the guys who > have tape on their glasses and wear suspenders with their pants that > are too short, gave them a drug to

RE: OEM question

2003-06-20 Thread Stephen Lee
The old simple snapshot replication is OK. It's just that some of this later stuff makes you think they rounded up all the guys who have tape on their glasses and wear suspenders with their pants that are too short, gave them a drug to put them in an *extra* geeky mood, gave them unlimited amount

RE: OEM question

2003-06-20 Thread Thater, William
7;t use any of that.;-) as for OEM, i always use it stand alone... but that's mostly because i'm too dense to get it configured right to do anything else with it.;-) -- Bill "Shrek" ThaterOracle DBA BAARF Party memb

RE: OEM question

2003-06-19 Thread Stephen Lee
No No. THOSE guys did replication. Then the worst of the bunch worked in conjunction with the authors of graduate Math texts to come up with Advanced Queuing. -Original Message- I have tried to automate various things with OEM jobs and events and eventually decided that at and dbms_job

RE: OEM question

2003-06-19 Thread Niall Litchfield
Title: Message You are correct about the chicken/egg problem with the repository. You don't necessarily require a repository if you are using it as a management console rather than an application managament framework.   I have tried to automate various things with OEM jobs and event

Re: OEM question

2003-06-18 Thread Ruth Gramolini
Title: OEM question Lisa, You can put the catalog in any database.  I have mine in a separate database right now and use rman to back it up.  I run it in archivelog mode of course.  It takes less than a minute to back it up, including the archivelogs.  I used to have it with my rman

  1   2   3   4   5   >