f



Oracle permissions issue Oracle 9.2.0.7/Win 2003

Oracle 9.2.0.7
Windows 2003

We are going through a Certification and Accreditation process with
our databases. We are being dinged for grants that any schema owner is
giving on its objects to database roles. We were told that only the
SYSTEM user or a user with DBA privileges should grant the permissions
on any object to any role.

We have changed the process so that the user SYSTEM will log in and
grant the permissions but here is something we have noticed.

Lets say that the schema in question is SCOTT.
The table to grant SELECT permission on is the EMP table.
The role to grant permissions to is EMP_ACCESS_ROLE

1. We log in as SYSTEM and run the following statement.

GRANT SELECT on SCOTT.EMP to EMP_ACCESS_ROLE;

2. When we run

select * from DBA_TAB_PRIVS where table = 'EMP';

GRANTEE                   OWNER TABLE_NAME   GRANTOR
PRIVILEGE
---------------------------------- ------------
------------------------ ----------------
------------------------------------
EMP_ACCESS_ROLE  SCOTT  EMP                  SCOTT       SELECT

We see that the GRANTOR is still the schema owner SCOTT. So when the
database is scanned again we are still being dinged for the schema
owner granting permission on an object to a role.

-------

3. We then tried this (even though this is retarded and unnecessary
since SYSTEM has the SELECT permission to begin with)

GRANT SELECT ON  SCOTT.EMP TO SYSTEM WITH  GRANT OPTION;

4. We then log in as SYSTEM and grant the permission again.

GRANT SELECT on SCOTT.EMP to EMP_ACCESS_ROLE;

5. When we run

select * from DBA_TAB_PRIVS where table = 'EMP';

GRANTEE                   OWNER TABLE_NAME   GRANTOR
PRIVILEGE
---------------------------------- ------------
------------------------ ----------------
------------------------------------
EMP_ACCESS_ROLE  SCOTT  EMP                  SYSTEM    SELECT

We see that the GRANTOR is now SYSTEM. But now we are being dinged
that the SYSTEM user has unnecessary permissions on the SCOTT schema
that it does not need to have, and also that the schema owner SCOTT is
still logging in to give permissions to other users.
--------------

Has anyone else run into this problem of the schema owner showing up
as the GRANTOR even though SYSTEM granted the permission. What was
your work around ?


Thanks in advance.

0
wallyraju (50)
8/30/2007 3:42:12 PM
comp.databases.oracle.server 22978 articles. 1 followers. Post Follow

2 Replies
641 Views

Similar Articles

[PageSpeed] 13

Wally wrote:
> Oracle 9.2.0.7
> Windows 2003
> 
> We are going through a Certification and Accreditation process with
> our databases. We are being dinged for grants that any schema owner is
> giving on its objects to database roles. We were told that only the
> SYSTEM user or a user with DBA privileges should grant the permissions
> on any object to any role.
> 
> We have changed the process so that the user SYSTEM will log in and
> grant the permissions but here is something we have noticed.
> 
> Lets say that the schema in question is SCOTT.
> The table to grant SELECT permission on is the EMP table.
> The role to grant permissions to is EMP_ACCESS_ROLE
> 
> 1. We log in as SYSTEM and run the following statement.
> 
> GRANT SELECT on SCOTT.EMP to EMP_ACCESS_ROLE;
> 
> 2. When we run
> 
> select * from DBA_TAB_PRIVS where table = 'EMP';
> 
> GRANTEE                   OWNER TABLE_NAME   GRANTOR
> PRIVILEGE
> ---------------------------------- ------------
> ------------------------ ----------------
> ------------------------------------
> EMP_ACCESS_ROLE  SCOTT  EMP                  SCOTT       SELECT
> 
> We see that the GRANTOR is still the schema owner SCOTT. So when the
> database is scanned again we are still being dinged for the schema
> owner granting permission on an object to a role.
> 
> -------
> 
> 3. We then tried this (even though this is retarded and unnecessary
> since SYSTEM has the SELECT permission to begin with)
> 
> GRANT SELECT ON  SCOTT.EMP TO SYSTEM WITH  GRANT OPTION;
> 
> 4. We then log in as SYSTEM and grant the permission again.
> 
> GRANT SELECT on SCOTT.EMP to EMP_ACCESS_ROLE;
> 
> 5. When we run
> 
> select * from DBA_TAB_PRIVS where table = 'EMP';
> 
> GRANTEE                   OWNER TABLE_NAME   GRANTOR
> PRIVILEGE
> ---------------------------------- ------------
> ------------------------ ----------------
> ------------------------------------
> EMP_ACCESS_ROLE  SCOTT  EMP                  SYSTEM    SELECT
> 
> We see that the GRANTOR is now SYSTEM. But now we are being dinged
> that the SYSTEM user has unnecessary permissions on the SCOTT schema
> that it does not need to have, and also that the schema owner SCOTT is
> still logging in to give permissions to other users.
> --------------
> 
> Has anyone else run into this problem of the schema owner showing up
> as the GRANTOR even though SYSTEM granted the permission. What was
> your work around ?
> 
> 
> Thanks in advance.
> 

Turn on auditing for GRANT statements in the database. Then when they 
ding you, you can pull up your audit trail and say "see....even though 
the Data Dictionary shows the grantor was SCOTT, it was in fact...SYSTEM".

But then this brings up another point to my mind...should this type of 
auditing be done on an individual basis? In that case, multiple DBAs 
should not be sharing the SYSTEM account. Rather, they should have their 
own accounts. That way, when you audit the GRANT commands, you can 
denote the actual individual who has performed the operation.

HTH,Brian

-- 
===================================================================

Brian Peasland
dba@nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com

0
dba (518)
8/30/2007 5:09:01 PM
On Aug 30, 1:09 pm, Brian Peasland <d...@nospam.peasland.net> wrote:
> Wally wrote:
> > Oracle 9.2.0.7
> > Windows 2003
>
> > We are going through a Certification and Accreditation process with
> > our databases. We are being dinged for grants that any schema owner is
> > giving on its objects to database roles. We were told that only the
> > SYSTEM user or a user with DBA privileges should grant the permissions
> > on any object to any role.
>
> > We have changed the process so that the user SYSTEM will log in and
> > grant the permissions but here is something we have noticed.
>
> > Lets say that the schema in question is SCOTT.
> > The table to grant SELECT permission on is the EMP table.
> > The role to grant permissions to is EMP_ACCESS_ROLE
>
> > 1. We log in as SYSTEM and run the following statement.
>
> > GRANT SELECT on SCOTT.EMP to EMP_ACCESS_ROLE;
>
> > 2. When we run
>
> > select * from DBA_TAB_PRIVS where table = 'EMP';
>
> > GRANTEE                   OWNER TABLE_NAME   GRANTOR
> > PRIVILEGE
> > ---------------------------------- ------------
> > ------------------------ ----------------
> > ------------------------------------
> > EMP_ACCESS_ROLE  SCOTT  EMP                  SCOTT       SELECT
>
> > We see that the GRANTOR is still the schema owner SCOTT. So when the
> > database is scanned again we are still being dinged for the schema
> > owner granting permission on an object to a role.
>
> > -------
>
> > 3. We then tried this (even though this is retarded and unnecessary
> > since SYSTEM has the SELECT permission to begin with)
>
> > GRANT SELECT ON  SCOTT.EMP TO SYSTEM WITH  GRANT OPTION;
>
> > 4. We then log in as SYSTEM and grant the permission again.
>
> > GRANT SELECT on SCOTT.EMP to EMP_ACCESS_ROLE;
>
> > 5. When we run
>
> > select * from DBA_TAB_PRIVS where table = 'EMP';
>
> > GRANTEE                   OWNER TABLE_NAME   GRANTOR
> > PRIVILEGE
> > ---------------------------------- ------------
> > ------------------------ ----------------
> > ------------------------------------
> > EMP_ACCESS_ROLE  SCOTT  EMP                  SYSTEM    SELECT
>
> > We see that the GRANTOR is now SYSTEM. But now we are being dinged
> > that the SYSTEM user has unnecessary permissions on the SCOTT schema
> > that it does not need to have, and also that the schema owner SCOTT is
> > still logging in to give permissions to other users.
> > --------------
>
> > Has anyone else run into this problem of the schema owner showing up
> > as the GRANTOR even though SYSTEM granted the permission. What was
> > your work around ?
>
> > Thanks in advance.
>
> Turn on auditing for GRANT statements in the database. Then when they
> ding you, you can pull up your audit trail and say "see....even though
> the Data Dictionary shows the grantor was SCOTT, it was in fact...SYSTEM".
>
> But then this brings up another point to my mind...should this type of
> auditing be done on an individual basis? In that case, multiple DBAs
> should not be sharing the SYSTEM account. Rather, they should have their
> own accounts. That way, when you audit the GRANT commands, you can
> denote the actual individual who has performed the operation.
>
> HTH,Brian
>
> --
> ===================================================================
>
> Brian Peasland
> d...@nospam.peasland.nethttp://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown
>
> --
> Posted via a free Usenet account fromhttp://www.teranews.com

Thanks for the info Brian. We'll see if having an audit trail will be
enough to satisfy them.

0
wallyraju (50)
8/30/2007 5:35:39 PM
Reply:

Similar Artilces:

help:How can i take Export of Oracle 9.2.0.1 from Oracle 9.2.0.7
How can i take Export of Oracle 9.2.0.1 from Oracle 9.2.0.7 1-what scripts are to be used 2-Where i can find these scripts. Thnks. You can't. You can use lower version export to export higher version database. The other way around has never been possible. -- Sybrand Bakker Senior Oracle DBA You probably have Oracle 9.2.0.1 running somewhere right, perhaps on another machine ? Set your ORACLE_HOME to 9.2.0.1 then export through sqlnet: exp username/pwd @9207instance Now you'll use the 9.2.0.1 export utility; this should work. "shahsyed" <shahsyed@gmail.com> schreef in bericht . > How can i take Export of Oracle 9.2.0.1 from Oracle 9.2.0.7 > > 1-what scripts are to be used > 2-Where i can find these scripts. > > Thnks. Hi, I guess oracle dosen't support backword comatibilty.then how it is possible?? Thanks Alok. On 9 Aug 2005 22:05:49 -0700, alok.behria@gmail.com wrote: >Hi, > > I guess oracle dosen't support backword comatibilty.then how it is >possible?? > >Thanks >Alok. Oracle is backwards compatible provided you have the definition of backwards compatible correct. You can connect (again) *lower version client* to a *higher version database* The other way around has nothing to do with backwards compatible, though it usually works, *with the exception of export/import, AS DOCUMENTED* (but I guess no one ever reads the docs) -- Sybrand Bakker, Senior Oracle DBA Hi, ...

massive performance drop Oracle 9i on multi processor system (Windows Server 2003, Oracle 9i, 9.2.0.6.0)
The performance of some complex PL/SQL functions has dropped dramatically since migrating from Oracle 8i (8.1.7.0.0) on Windows Server 2000 to 9i (9.2.0.6.0) on Windows Server 2003. We found out, that Oracle 9i performance on a multi processor CPU machine (our server has 4 XEON CPUs, Hyperthreading is disabled in BIOS) is highly dependent on init.ora parameters; unfortunately our trial and error approach to find the proper settings (we searched Oracle Tech Net (OTN) and google groups without success) did not help so far. We are testing performance behaviour with some business critical PL/SQL procedures that do authorization calculations for our application. Simplified these functions do a lot of inserts, deletes and selects in/from tables (being used as temp tables in lack of in memory temp table support of oracle 9i). We can monitor the progress within the stored procedure by using UTL_FILE functions to write a log file into the file system of the server; we real time monitor the log file using "tail -f". <PL/SQL do something> UnbufferedLogFileOutputUsingUTL_FILE(); <PL/SQL do something> UnbufferedLogFileOutputUsingUTL_FILE(); [...] When setting "CPU_COUNT = 1" in init.ora the function will typically run up to 10 seconds, when setting "CPU_COUNT = 4" it will take more than 2 minutes (!!!) We experimented with the following other parameters so far: db_writer_processes (set to 4 in combination with cpu_count = 4) fast_start_parall...

Oracle server 9.2.0.1.0, Client 9.2.0.4.0, Red Hat Linux enterprise advanced server 2.1
Hi Everybody, My Database server is running on Red Hat Linux enterprise advanced server 2.1, And my Oracle version is 9.2.0.1.0. My Client mechine also Red Hat Linux enterprise advanced server 2.1 , Oracle client version is 9.2.0.4.0. I am running a web application. Our application is in Magic edeveloper. I connect to Oracle using oracle gateway to my application. My Problem is my application is is becoming slow. I am not able to trace where the problem is. Before our application was running fine. recently i upgraded Oracle client version to 9.2.0.4.0. My Oracle client & server versions are different. I am getting error on my client mechine, it showing all memory address on the screen and the part of error is, arg register addr=83498cc .... Dump of memory from 0x83988c to 0x83499cc .... -- End of Call stack trace -- I am not able to trace where the problem is.Any insight please... Thanks, Ssreddy. ...

Upgrade from Oracle 9.2.0.1 to Oracle 9.2.0.3
Hello All, I am trying to upgrade oracle 9.2.0.1 to new patchset 9.2.0.3 or 9.2.0.4. Please recommend which is better 9.2.0.3 or 9.2.0.4? Also I had a bad experience with my development server when applying 9.2.0.3 patchset. Is there anything you recommend before I start again? Thanks Kumu Hello Kumu, What is the reason for upgrade? Any specific bugs or issues you experience? You can open TAR as well to get support recommendations for your situation. New patches can introduce new problems as you can see, Regards, Ron DBA Infopower http://www.dbainfopower.com Standard disclaimer: http://www.dbainfopower.com/dbaip_advice_disclaimer.html "kumu" <forlist2001@yahoo.com> wrote in message news:a44abd39.0402161837.6badb9ed@posting.google.com... > Hello All, > I am trying to upgrade oracle 9.2.0.1 to new patchset 9.2.0.3 or > 9.2.0.4. Please recommend which is better 9.2.0.3 or 9.2.0.4? > > Also I had a bad experience with my development server when applying > 9.2.0.3 patchset. Is there anything you recommend before I start > again? > > Thanks > Kumu "Ron" <support@dbainfopower.com> wrote in message news:<QqWdnRM_cMiwWqzdRVn-vg@comcast.com>... > Hello Kumu, > > What is the reason for upgrade? Any specific bugs or issues you > experience? > > You can open TAR as well to get support recommendations for your > situation. > > New patches can introduce new...

Install problems with Oracle installer 2.2 for Oracle 9i Client 9.2.0.1.0
Please forgive me if I am posting this in the wrong forum - I am an Oracle Newbie. Here are my computer specs : Windows 2003 - fully patch from Microsoft as of Sept 4th 2004 HP LP2000r 1 x 1,1 Gig Intel processor 1 GB RAM Hardware RAID 1, 12 GB with 8 GB freespace Clean install, no other programs. At first I tried running the Oracle installer program from the CD ROM and came up with the error that it could not find the javaw.exe program. I then tried installing and reinstalling several versions of java to no avail. Next I searched through groups.google and found the solution: 1. Copy the Oracle CD to the hard drive. I copied it to a subfolder directly to C:\Oracle9i 2. Change the file c:\oracle9i\install\ORAPARAM.INI to reflect the actual name of the directories listed in the install directories of the cd I just copied. I did this and next took out some "."s and put the absolute path to the java program and something called the "OUI_LOCATION". JRE_LOCATION=C:/oracle9i/stage/Components/oracleswdjre/13110a/1/DataFiles/Expanded OUI_LOCATION=C:/oracle9i/stage/Components/oracleswdoui/220120/1/DataFiles/Expanded Okay so good so far. This time the installer actually started. The problem occurs in the next few steps, when I click "next" (weiter in German) from the welcome screen- please understand if I translate something wrong here. Then I am shown the installation directory screen, where I select the default listed: Source : C:\Oracle...

Oracle 9.2 vs. Oracle 9.2.0.4.
I'm using SDK 1.4.2_03 either with an Oracle 9.2 or an Oracle 9.2.0.4 client version. The 9.2 version behaves as expected. My problem only occurs with the 9.2.0.4. version. If I try to process the ResultSet of database query and the selected column data includes leading blanks, the 9.2.0.4 seems to trim these leading blanks. Is this behaviour known or am I doing something wrong ? <code snippet> ResultSet result = null; Connection con = null; Statement stmt = null; Vector vec = new Vector(); try { con = DriverManager.getConnection(dbUrl, dbUser, dbPassword); stmt = con.createStatement(); result = stmt.executeQuery("SELECT DATA FROM CPTMESSAGEDATA";); while (result.next()) { vec.add(result.getString("DATA")); } con.close(); stmt.close(); } catch (SQLException e) { } </code snippet> CPTMessageData.DATA is of type VARCHAR2(50) not nullable with values like: " @20013 @E123 @G123 @ @ @ " " @3700167 @43186 @B50_300 @1 @20013 @1 @OK " Any help is appreciated. Alex ...

oracle database 9.2.0.8 32bit and windows server 2003 64bit
Hello! What about configuration like in subject... What about memory limits on 32bits? Can i rise sga more then 2GB? on 64 bit system but using 32 bit database? Any suggestion? Regards - MJ On 15 apr, 11:16, "hehehe" <m...@m.ccc> wrote: > Hello! > > =A0 =A0 What about configuration like in subject... What about memory lim= its on > 32bits? Can i rise sga more then 2GB? on 64 bit system but using 32 bit > database? Any suggestion? > > Regards - MJ Obviously, with only a little bit of thinking, you would have reached the conclusion, limits are determined by the OS of the database server. -- Sybrand Bakker Senior Oracle DBA thx. I will check Uzytkownik "sybrandb" <sybrandb@gmail.com> napisal w wiadomosci news:b5d54371-bf21-439b-85c3-ae21dafc21be@3g2000yqk.googlegroups.com... On 15 apr, 11:16, "hehehe" <m...@m.ccc> wrote: > Hello! > > What about configuration like in subject... What about memory limits on > 32bits? Can i rise sga more then 2GB? on 64 bit system but using 32 bit > database? Any suggestion? > > Regards - MJ Obviously, with only a little bit of thinking, you would have reached the conclusion, limits are determined by the OS of the database server. -- Sybrand Bakker Senior Oracle DBA On Apr 15, 5:16=A0am, "hehehe" <m...@m.ccc> wrote: > Hello! > > =A0 =A0 What about configuration like in subject... What about memory lim= its on &g...

Running ORACLE 8.1.7 & ORACLE 9.2 on the same UNIX server
Hi, I have recently installed ORACLE 9.2 Database on a UNIX server (2.8) which already has ORACLE 8.1.7. They have both a different SID and ORACLE_BASE. However I am having to use the ORACLE 8 listener for both ORACLE databases. Is it possible to run separate ORACLE 8 and ORACLE 9 listeners? Hello, There are no difficulty to use 2 listeners on the same machine. The point is that default listener used to listen on port 1521 (or 1526). You will have to change your listener configuration( netasst or by hand) in order to use a different port number, a different listener name and communicate it to your users for their tnsnames.ora. LSNR8I = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= TCP)(Host= machine)(Port= 1110)) ) Generally what I do is to create 1 listener per Oracle Version. After that, for starting listeners you'll have to launch lsnrctl start LSNR8I ou lsnrctl start LSNR9I I am used to name listeners with different names since 8i because you have the autoregistration stuff and with 2 listeners with the same name, you are not sure on which the database will register (or using le local_listener init parm). Regs, Olivier jonathan.johnston@bt.com (Jonathan Johnston) wrote in message news:<5e07fa5.0406080037.67d595a9@posting.google.com>... > Hi, > > I have recently installed ORACLE 9.2 Database on a UNIX server (2.8) > which already has ORACLE 8.1.7. They have both a different SID and > ...

restoring 9.2.0.6 datafiles with 9.2.0.7 Oracle
Hello Is there potential problem ? we want to use old datafiles in 9.2.0.6 with a patched oracle in 9.2.0.7... Thank you nonor wrote: > Hello > > Is there potential problem ? we want to use old datafiles in 9.2.0.6 > with a patched oracle in 9.2.0.7... > > Thank you No, you don't want to do that. You want to solve some problem, for which you believe that to be the solution. What is the problem you are trying to solve? In answer to your question -- yes, I'd think there would be disasterous problems. So, again -- what is the problem you are trying to solve? nonor wrote: > Hello > > Is there potential problem ? we want to use old datafiles in 9.2.0.6 > with a patched oracle in 9.2.0.7... That really describes a usual step in applying the 9.2.0.7 patchset. The database files are still at ( whatever ) the old patch level was .... say 9.2.0.6. You have to use the patched oracle binaries to open the database. But then the next step should be to follow the steps in the 9.2.0.7 for patching existing databases ... startup migrate and run the script to move the database files up to 9.2.0.7 ... Is that what you are attempting to do? Have you read the readme ( installation instructions ) for the 9.2.0.7 patchset? ...

Oracle server Upgrade from 9.0 to 9.2 on Windows 2003
Hi All, I am trying to upgrade an Oracle server running 9.0 on Win 2003. I do not want to keep 2 Oracle Homes for 9.0 and 9.2. I would rather uninstall 9.0 using oui. I will import the data from production database from export files. What will be my best (easy, hassle free) course of action: 1. Shutdown the current 9.0 instance 2. Drop the current 9.0 db 3. Uninstall the current 9.0 executibls using oui 4. Install the 9.2 executibles 5. Create new db instance 6. Import the data from export files Is this a good idea? Or should I have 2 Oracle Homes by installing 9.2 and upgrade the 9.0 db using dbua? Only problem is I cant find the dbua in the current 9.0 setup. Your advice / experience / feedback will really appreciated. Thanx in advance. Personally, I'd install 9.2 in a second Oracle Home and then upgrade the database. Once it is all done, feel free to remove the 9.0 software in that home. You'll use the DBUA in the 9.2 home, not the 9.0 one! HTH, Brian Wade Chy wrote: > > Hi All, > I am trying to upgrade an Oracle server running 9.0 on Win 2003. I do > not want to keep 2 Oracle Homes for 9.0 and 9.2. I would rather > uninstall 9.0 using oui. I will import the data from production > database from export files. What will be my best (easy, hassle free) > course of action: > > 1. Shutdown the current 9.0 instance > 2. Drop the current 9.0 db > 3. Uninstall the current 9.0 executibls using oui > 4. Install the 9.2 executibles &...

from oracle 9.2.04 to oracle 9.2.05
i'm a newbie, i'd like to guess if anybody knows how can I upgrade my oracle 9.2.04 to 9.2.05. My java_pool_size, shared_pool_size are under 150 MB. How can I set this value? Bye and thx a lot. jakko1982 wrote: > i'm a newbie, i'd like to guess if anybody knows how can I upgrade my > oracle 9.2.04 to 9.2.05. > My java_pool_size, shared_pool_size are under 150 MB. How can I set > this value? > > Bye and thx a lot. 1) Goto http://metalink.oracle.com and download the 9.2.0.5 patchset. You can also goto 9.2.0.6. Patch installation documentation comes with it. Make sure you review the documentation before applying the patchset. 2) Goto http://tahiti.oracle.com and review the "Initialization Parameter" section. If you are using spfile (Server Parameter File) then you can change these parameters online. Search for "spfile" keyword and goto "Administrator's Guide". If you are not using spfile then you need to locate the database init.ora file, modify the parameter values and bounce the database. Regards /Rauf sorry, but I use Spfile. I've searched Spfile keyword and I read the administrator's guide. and now? sorry but Im a newbye jakko1982 wrote: > sorry, but I use Spfile. I've searched Spfile keyword and I read the > administrator's guide. > > and now? sorry but Im a newbye Did you read under heading "Managing Initialization Parameters Using a Server Parameter File"...

Connection from Oracle Developer Suite 10g 9.0.4.0.1 to Oracle DB 10g Release 10.1.0.2.0
Hi, I have installed Oracle DB 10g Release 10.1.0.2.0 on Windows XP. START->ALL PROGS->oracle-OraDb10g_home3 Location of TNSNAMES FILE: C:\oracle\product\10.1.0\db_3\NETWORK\ADMIN\TNSNAMES.ORA with two alias: 1)ORCL3 2) EXTPROC_CONNECTION_DATA I can logon to database via SQL*PLUS and I can log on to EM on the web as well using ORCL3. After that I installed Oracle Developer Suite 10g 9.0.4.0.1 to my the same computer. During installation it was not allowing me to install this suite to the same ORACLE home. I installed this in the following home: START->ALL PROGS->...

Comparisons Oracle 11.1.0.7 to Oracle 10.2.0.4
I have made some performance comparison tests on test computers and it has turned out that the Oracle 11 databases are in general slower compared to the Oracle 10 databases by 10 to 30%. The databases are running on Windows Vista and Windows 2003 64 Bit. We hope that the release 2 of Oracle 11 gives some enhancements because in general there are not many advantages regarding new features useable for us. Has someone made similar comparison results? Arne Ortlinghaus ACS Data Systems On Oct 22, 5:37=A0am, "Arne Ortlinghaus" <Arne.Ortlingh...@acs.it> wrote: snip > I have made some performance comparison tests on test computers and it ha= s > turned out that the Oracle 11 databases are in general slower compared to > the Oracle 10 databases by 10 to 30%. The databases are running on Window= s > Vista and Windows 2003 64 Bit. We hope that the release 2 of Oracle 11 gi= ves > some enhancements because in general there are not many advantages regard= ing > new features useable for us. > > Has someone made similar comparison results? That has not been the case for us but we are running on Linux 64 bit systems. When you say "on test computers" that makes me nervous. One has to be very careful to get identical environments. One has to look very carefully at oracle settings between the environments. On Oct 22, 5:37=A0am, "Arne Ortlinghaus" <Arne.Ortlingh...@acs.it> wrote: > I have made some performance...

oracle 9i (9.2.0.1.0)
Hi! when I call the oracle performance manager I get the following errors: VTM-0002: error when displaying graph java.lang.null.pointerexception at oracle.sysman.vtd.VtdCartridge.lookupClass(VtdCartridge.java:1313) ..... what is my problem? Thanks! ...

upgrade from oracle 9.2.0.1.0 to 9.2.0.5.0
Hi, I have a 9.2.0.1.0 database that I want to upgrade to 9.2.0.5. for window version 32 bits, does anyone can provide the node document information of step by step doing it. many thanks leehi leehi wrote: > I have a 9.2.0.1.0 database that I want to upgrade to 9.2.0.5. for > window version 32 bits, Windows NT4? W2k? W2K3? W2K3 - Release 2? Why stop ot 9.2.0.5? > does anyone can provide the node document information of step by step > doing it. leehi wrote: > Hi, > > I have a 9.2.0.1.0 database that I want to upgrade to 9.2.0.5. for > window version 32 bits, > > does anyone can provide the node document information of step by step > doing it. > > many thanks > > leehi Go to metalink.oracle.com (registration and Oracle support CSI required). Click on Patches and Updates tab. Wait for the whole screen to load. Use one of the search functions to find your patch (note the Quick Links if you are getting something common, like 9206 or 9207). When you finally get to your patch download, click on the readme (the piece-of-paper icon next to the download icon). Read all the instructions. It's a good idea to read the instructions every time you do it, even (or perhaps especially) when you are comfortable doing it. The readme is usually also included with the patch. Download and unzip the patch. Look at what is there in the patch, perhaps there are additional release notes. Look around on metalink for addition...

Setting file permission error on Oracle 9.2 installation on RedHat 9.0 #2
Hi, On installing Oracle 9.2 on RedHat 9.0 and AS 2.1, I encounterd the same following error: Error in setting permissions on file/directory /opt/oracle/jre/1.1.8/LICENSE Could someone tell me why it happened and how to fix it? Your help is much appreciated. Thanks, Rob ...

Known problems with Oracle 9.2.0.1 and Windows Server 2003 ?
On the CD of Oracle Database 9.2.0.1 is not specified that it runs on Windows Server 2003, but i've tried and it works. Do you know bugs or problems with this configuration? I see that 9.2.0.3 version is Windows Server 2003 certified. Do you think that i've to upgrade to that version? (sorry for my english) MariMax wrote: > > On the CD of Oracle Database 9.2.0.1 is not specified that it runs on > Windows Server 2003, but i've tried and it works. > Do you know bugs or problems with this configuration? > > I see that 9.2.0.3 version is Windows Server 2003 certified. Do you think > that i've to upgrade to that version? > > (sorry for my english) It's worth your time to upgrade as there are many fixes. To see which, log on to metalink and review the 'Fixes by Release' note. Remember that if you have ANY problem, the first general response is to upgrade to the latest version and then investigate. "Why wait for spring - do it now!" (I suspect there is probably a good reason why Oracle posted a separate download for Windows2003 Server as compared to the download for NT/XP/2000 - make sure you have the right one.) /Hans Hans Forbrich <hforbric@yahoo.net> wrote in message news:<40339F99.48EB66EB@yahoo.net>... > MariMax wrote: > > > > On the CD of Oracle Database 9.2.0.1 is not specified that it runs on > > Windows Server 2003, but i've tried and it works. > > Do ...

DBLINK between Oracle 7 and Oracle 9
Hi, I'm trying to acces data on an Ora 7 DB from an Ora 9 DB. Using Enterprise manager I've created a db link which should provide this functionality. However, when I try to test it I get and error message "The Database link is not active". Can anyone assist. Thanks Abe The Oracle 7 database and the Oracle 9i database uses different network stacks. Connecting to an Oracle 7 database from Oracle 9i software (db link, etc) has been full of difficulties. Can you upgrade the Oracle 7 database to a much newer, and supported version? Otherwise, I know others who have gotten the whole thing to work by using an Oracle 8 database in the middle. Ugly, but it has worked. HTH, Brian Abe wrote: > > Hi, > > I'm trying to acces data on an Ora 7 DB from an Ora 9 DB. Using > Enterprise manager I've created a db link which should provide this > functionality. However, when I try to test it I get and error message > "The Database link is not active". Can anyone assist. > > Thanks > Abe -- =================================================================== Brian Peasland dba@remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" On Mon, 2 Feb 2004 18:23:45 +0100, Abe wrote (in message <5b4dae09.0402020923.3e766175@posting.google.com>): > Hi, > > I'm trying to acces da...

Oracle 10g 10.0.2 client, to connect oracle 8 server
Dear Group members, I am using Oracle 10 g 10.0.2 client software to connect 9i,10g and 8i it is working very good with the 9i and 10g.. when i trying to connect 8i server ./. it giving error <b> "ORA-03134: Connections to this server version are no longer supported." </b> Can i install, 2 or more version of oracle clients in same system, becoz .. currently using client software is well configured for some SQL server BI agents, if i un-install current 10g client, it will infect my software .. process.. if, it can be possible, what kind of things i take care, before installation .. What is the best oracle client software can suitable for most of the server's > I am using Oracle 10 g 10.0.2 client software to connect 9i,10g and > 8i > > it is working very good with the 9i and 10g.. > when i trying to connect 8i server ./. it giving error > > <b> "ORA-03134: Connections to this server version are no longer > supported." </b> > > > Can i install, 2 or more version of oracle clients in same system, > becoz .. currently using client software is well configured for some > SQL server BI agents, if i un-install current 10g client, it will > infect my software .. process.. Yes you can, I currently have 3 versions Oracle 8.0.4, Oracle 9.2 and Oracle 10.2 on my work PC. No problem. > > if, it can be possible, what kind of things i take care, before > installation .. If yo...

Oracle Optmizer does not use the right index (Oracle 9.2.0.6)
Hello, Not sure whether this problem has been discussed earlier in this forum. Can someone suggest a workaround to the following problem which can be replicated by following the sequence of detailed steps I have given below. In summary, if you have a table with two composite indexes, both with the same fields, but one of them has a field in descending order, then the Optimizer loses track of the correct index to use for a specific query. Thanks. A.J.Andrews See details below: ---------------- SQL*Plus: Release 9.2.0.6.0 - Production on Mon Feb 27 08:29:06 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production SQL> create table tab1 as select * from all_objects; Table created. SQL> set autotrace traceonly explain; SQL> create index tab1ind1 on tab1(owner, object_name); Index created. SQL> analyze table tab1 compute statistics; Table analyzed. SQL> alter session set optimizer_mode=first_rows; Session altered. SQL> select * from tab1 order by owner, object_name; Execution Plan ---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=FIRST_ROWS (Cost=172 Card=4899 Bytes=372324) 1 0 TABLE ACCESS (BY INDEX ROWID) OF 'TAB1' (Cost=172 Card=4899 Bytes=372324) 2 1 INDEX (FULL SCAN) OF 'TAB1...

Oracle 10g 10.0.2 client, to connect oracle 8 server
Dear Group members, I am using Oracle 10 g 10.0.2 client software to connect 9i,10g and 8i it is working very good with the 9i and 10g.. when i trying to connect 8i server ./. it giving error <b> "ORA-03134: Connections to this server version are no longer supported." </b> Can i install, 2 or more version of oracle clients in same system, becoz .. currently using client software is well configured for some SQL server BI agents, if i un-install current 10g client, it will infect my software .. process.. if, it can be possible, what kind of things i take care, before installation .. What is the best oracle client software can suitable for most of the server's On Jul 27, 11:58=A0pm, ranganadh <ranganadhkod...@gmail.com> wrote: > Dear Group members, > > =A0I am using Oracle 10 g 10.0.2 client software to connect 9i,10g and > 8i > > it is working very good with the 9i and 10g.. > when i trying to connect 8i server ./. it giving error > > <b> =A0"ORA-03134: Connections to this server version are no longer > supported." </b> > > Can i install, 2 or more =A0version of oracle clients in same system, > becoz .. currently using client software is well configured for some > SQL server BI agents, if i un-install current 10g client, it will > infect my software .. process.. > > if, it can be possible, what kind of things i take care, ...

ODMA_RBS Error while upgrade Oracle 8.1.7 to Oracle 9.2
Hi all, I am trying to upgrade Oracle 8.1.7 to Oracle 9.2 using database upgrade assistant and while doing that I am getting error at final Step 4 after clicking the Finish button error msg is "90MB of Free disk space not available at D:\ORACLE9\oradata\Datenbank to create the "ODMA_RBS" tablespace for rollback undo mode duting upgrade.Provide the required free disk space on the disk" Althoug there are 51 GB of disk space available. I don't know why is it giving this error! OS is Windows 2003. Can anyone help? Thanks in advance, Dirk Hmmm...Hard to say...Prove to use that you're not crazy: Go to a dos prompt, go to C:\ and D:\ and do a DIR command post results (bytes free) and we'll belive you. Dirk Schulz wrote: > Hi all, > > I am trying to upgrade Oracle 8.1.7 to Oracle 9.2 using database upgrade > assistant and while doing that I am getting error at final Step 4 after > clicking the Finish button error msg is > "90MB of Free disk space not available at D:\ORACLE9\oradata\Datenbank to > create the "ODMA_RBS" tablespace for rollback undo mode duting > upgrade.Provide the required free disk space on the disk" > > Althoug there are 51 GB of disk space available. I don't know why is it > giving this error! OS is Windows 2003. > > Can anyone help? > > Thanks in advance, > > Dirk > > The 51GB is on E, not on D? Just to give an example? -- Regards, ...

Patching Oracle 8.1.7.0.0 to Oracle 8.1.7.4.1
Hello, my configuration is Windows 2K Server SP4 and Oracle 8.1.7.0.0. Where can i find a patch to upgrade to Oracle 8.1.7.4.1 Many thanks for your attention -- Sitta many thanks!!!! Have a nice work "Rauf Sarwar" <rs_arwar@hotmail.com> ha scritto nel messaggio news:1106137485.286119.307110@f14g2000cwb.googlegroups.com... > > Sitta Davide wrote: >> Hello, >> my configuration is >> >> Windows 2K Server SP4 and Oracle 8.1.7.0.0. >> >> Where can i find a patch to upgrade to Oracle 8.1.7.4.1 >> >> >> Many thanks for your attention >> >> -- >> >> Sitta > > http://metalink.oracle.com > > Regards > /Rauf > ...

Question on Oracle Server 10g Install (.../oracle/oracle/.....
I am in the last stages of installing Oracle Server 10gR2 Enterprise Edition on a UNIX AIX server. When window "Execute Configuration Scripts" comes up it tells me to execute "/u01/app/oracle/oracle/product/10.2.0/db_1/root.sh". The ".../oracle/oracle/..." stops me cold. I look back in my notes and everything I wrote suggests I had entered ".../oracle/product/....." for my ORACLE_HOME. I look at the install log in /u01/app/oracle/oraInventory/logs and see: "INFO: Setting variable 'ORACLE_HOME' to '/u01/app/oracle/oracle/product/10.2.0/d b_1'. Received the value from the command line." Did I really key /oracle/oracle/ instead of /oracle/ or did the OUI change the path for some reason????? Thank you, Bill bfogarty@gaports.com wrote: > I am in the last stages of installing Oracle Server 10gR2 Enterprise > Edition on a UNIX AIX server. When window "Execute Configuration > Scripts" comes up it tells me to execute > "/u01/app/oracle/oracle/product/10.2.0/db_1/root.sh". > > The ".../oracle/oracle/..." stops me cold. I look back in my notes and > everything I wrote suggests I had entered ".../oracle/product/....." > for my ORACLE_HOME. I look at the install log in > /u01/app/oracle/oraInventory/logs and see: > "INFO: Setting variable 'ORACLE_HOME' to > '/u01/app/oracle/oracle/product/10.2.0/d > b_1'. Received the valu...

Web resources about - Oracle permissions issue Oracle 9.2.0.7/Win 2003 - comp.databases.oracle.server

Permission - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

Facebook Fixing Vulnerability That Would Prohibit Users From Revoking App Permissions
Facebook is working to remedy a vulnerability discovered by application security provider MyPermissions , which blocks users of the social network ...

Dwight Murphy - Ok, I now have permission to share the... - Facebook
Ok, I now have permission to share the news about Bowe Bergdahl..This in 2 emails... Here it is in Bob Bergdahls words to me! (1) You guys rock! ...

How-To: Handle Revoked Auth Permissions
This how-to document will help developers check a user's permissions and prompt that user for any missing permissions.

Facebook gives users more options for login, app permissions
Facebook CEO Mark Zuckerberg’s new mantra of “Move fast with stable infra,” might not be as sexy as “ Move fast and break things ,” but it reflects ...



Arafat's widow grants permission for Swiss lab to test poisoning theory
The Palestinian Authority also approved the probe, which was requested by Palestinian president Mahmoud Abbas after a media investigation found ...

'Give me the tooth': Pensioner fights for teeth 'taken without permission'
Perth pensioner Doreen Wilkes is fighting to get her front teeth back after they were allegedly removed by a student dentist without permission. ...

CSIRO moves toward industrial action: seeks Fair Work permission for protected action ballot
CSIRO's new chief executive Larry Marshall could soon be faced with disruptive staff.

Resources last updated: 3/19/2016 11:25:29 PM