Re: Hit Ratio

2003-12-20 Thread Nuno Souto
¦D Unreal, eh? that's SAP for you... Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - Just thought I would share my hit ratio with y'all. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network

Re: Duplicating with rman

2003-12-20 Thread Yong Huang
Hi, I'm not sure why your RMAN output says LOGFILE GROUP 1 ( '/z01/oradata/DEVL/redo_01a.dbf', '/z02/oradata/DEVL/redo_01b.dbf', GROUP 2 ( '/z01/oradata/DEVL/redo_02a.dbf', Where's the ) reuse shown in your RMAN script? Are you sure the script you showed here was run? Yong Huang you

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

Re: Linux

2003-12-20 Thread Paul Drake
--- Seema Singh [EMAIL PROTECTED] wrote: Hi Does anyone know good Linux administration book? Can you guyes suggest any good linux user group? thx -Seema Matt Welsh's Running Linux is now out in 4th Edition. Just make sure that you find a recent edition, as there are still plenty of RedHat

RE: Unable to coonect to database after server upgraded from NT to W2K

2003-12-20 Thread Paul Drake
--- Norris, Gregory T [ITS] [EMAIL PROTECTED] wrote: The server was probably added to a domain (or moved to a different one) as part of the upgrade. Try adding the following entry to your sqlnet.ora file. SQLNET.AUTHENTICATION_SERVICES = (NONE) good call. You'll also see this if a

Re: problem with mult datafiles and local mng tblspaces

2003-12-20 Thread Paul Drake
--- John Blake [EMAIL PROTECTED] wrote: I have a 9.2.0.3 DB running on AIX 4.3.3 An application running on W2K using SQLLDR to load approx 6g of data using local managed tablespaces ie.. CREATE TABLESPACE PARENTDAT DATAFILE '/vol01/oradata/e450dev/parentdat01.dbf' SIZE 2000M REUSE,

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: Hit Ratio

2003-12-20 Thread Jared Still
Actually, it isn't SAP. I was simply creating a set of MV's based on SAP tables in another database. The script I was running is used to keep track of how much IO is going on, just to ensure that everything is still working during the build. Once the physical IO exceeds the logical IO, the HR

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

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