|
1. DHCP Issue:
Message no. 24 [Reply of: no. 23 ] |
| Author: Rhonda Nichols (renichols2) |
| Date: Thursday, August 24, 2006 8:07am |
Hey guys! I am using windows XP. Here is the actual error I am receiving: Checking Network Configuration requirements ... Check complete. The overall result of this check is: Failed <<<< Problem: The install has detected that the primary IP address of the system is DHCP- assigned. Recommendation: Oracle supports installations on systems with DHCP-assigned IP addresses; However, before you can do this, you must configure the Microsoft LoopBack Adapter to be the primary network adapter on the system. See the Installation Guide for more details on installing the software on systems configured with DHCP. =========================================================
I can install the DHCP software but I just don't know much about it. I really don't want to mess up my laptop. Any suggestions? It won't let me install until this is taken care of. -Rhonda |
| Message no. 25 [Reply of: no. 24 ] |
| Author: Krishnamurth Ashwini (kashwini) |
| Date: Thursday, August 24, 2006 8:44am |
| Hi Rhonda, I had encountered the exact problem while installing 10g for the first time. I have attached a file that has directions to solve this problem. Let me know if this helps. Ash |
| See Attached |
2. Linux Certification
Subject: Linux Users
|
| Message no. 45 [Reply of: no. 3 ] |
| Author: Eric Knuth (elknuth2) |
| Date: Thursday, August 24, 2006 10:02pm |
Hello all Oracle only certifies the following linux variations. Red Hat Enterprise Linux AS/ES 3.0 (Update 4 or later) Red Hat Linux 4.0 SUSE Linux Enterprise Server 9.0 with SP 2 or later Asianux 1.0 Asianux 2.0 You can make it work with other variations, but I suggest you be pretty comfortable with linux and scripts. Eric
3. System Requirements |
| Author: Ravinder Gaur (rgaur) |
| Date: Friday, August 25, 2006 7:37am |
Per the Oracle Universal Installer guide and OPatch User's guide (Windows and Unix), Chap 2 -- The minimum system requirements for Oracle Universal Installer are as follows:
* Java Runtime Environment (JRE). Automatically installed with Oracle Universal Installer on most platforms. Check the Release Notes or installation guide of the products that you are installing for the required version.
* Memory Requirements. Memory requirements vary depending on the number of components installed. Check the Release Notes or installation guide for the products that you are installing for details. 32 MB minimum recommended on all platforms.
* Disk Space Requirements. Oracle recommends atleast 60 MB for Oracle Universal Installer files on Windows platforms; 70 MB on UNIX. (UNIX requires more memory because of the difference in JRE sizes for the platforms.) You may need up to 1 MB for the related inventory files.
When you run Oracle Universal Installer from NFS mounted user home, especially for Linux, execute the quota command to check the space availability. Never perform an install on a user home for which space is allocated based on quota. Those minimums usually are on the very low end and I haven't tested the 10g install so far on my laptop (we do on much larger unix/linux boxes at work) but I would imagine 512M would suffice. I will try installing the 10G EE tonight and let you know how that goes. Also remember this only applies to the install part. Once installed, you need to worry about your db settings and ensure that you don't allow too much memory to be alloted to the different memory structures. Check the init file (usually under \ADMIN\ \PFILE. That would account for most of your memory usage. For 10g, if you've used a default starter database, it would show up just 1 parm there - sga_target. Otherwise, if you did manual settings, you would see shared_pool_size and cache_size init settings. Try reducing those numbers (set in bytes). Hopefully that should improve the system performance. - Ravi |
4. Subject: computer Slowdown after oracle slowdown
|
| Message no. 56 |
| Author: Lakshmikar Padmaraju (lpadmaraju) |
| Date: Friday, August 25, 2006 3:42pm |
| Hi, To avoid slow down of the computer when you are not using the computer like others suggested in the forum stop the oracle instance so that database is not running all the time. Another option I suggest is we only use database whenever we need to practice our class exercises, best option is all windows user go to "Administrative tools /services and select all Oracle services one by one right click and go to properties choose "Manual" option for "Start up Type:" from dropdown window. With this option Database will not start when you stat your computer and computer work normally. Whenever you plan to use Oracle database go to "Administrative tools /services select oracle and double click and click start button it will start Oracle instance, after you done using database either you can stop the service or you can shutdown the computer. Hope this helps Raju. |
Subject: Re: computer Slowdown after oracle slowdown
|
| Message no. 76 [Reply of: no. 70 ] |
| Author: Ravinder Gaur (rgaur) |
| Date: Saturday, August 26, 2006 3:08pm |
| I think most of it has been already been talked about, but here a couple other approaches to stop/start Oracle Services in Windows env (besides ofcourse the AdminTools - Services route) -- 1. Type "services.msc" in a command window (type "cmd" in the Start=>Run). This will take you directly to the services window. 2. In a command window, type 3 things -- i) set ORASID="sid_name" -- set the environment (most likely this is already set if you just have one db installed on your machine, so you may not need that) ii) net stop OracleService%ORASID% -- Stops Oracle Service iii) net start OracleService%ORASID% -- Starts Oracle Service You might want to bundle these together in a .bat file and store in your default home folder in which the command window opens up. Easy to execute. (see attached) - Ravi |
| See Attached |
5. Security Issue
Subject: Diagnostic summary
|
| Message no. 71 |
| Author: Naziya Shaik (snaziya) |
| Date: Saturday, August 26, 2006 11:57am |
| After logging in to database...in Enterprise Manager..I found Diagnostic summary giving 7 -ALL POLICY VIOLATIONS. Can anyone tell what does this means. POlicy rules like .. 1. Execute UTL_FILE privileges to PUBLIC. the impact to this violation is "privileges granted to the PUBLIC role automatically apply to all users. A knowledgeable and malicious user can read and write arbitrary files in the system when granted the URL_FILE privilege." Recommendation is "Oracle recommends that you revoke EXECUTE privileges on powerful packages from PUBLIC". Can anyone explain me, about this and what am i supposed to do to change the privileges...I dont know if we are supposed to discuss this or not, but I am not sure if you too got this kind of violations? why did we get this violation? |
Subject: Re: Diagnostic summary
|
| Message no. 73 [Reply of: no. 71 ] |
| Author: Ravinder Gaur (rgaur) |
| Date: Saturday, August 26, 2006 1:30pm |
Naziya, Oracle completely redesigned the EM tool in 10g. The EM has more diagnostics and performance tuning features than ever before (we use that quite a lot for monitoring/tuning our production database). The diagnostics summary does a quick (proactive) database analysis/health-check and checks for any potential problems (policy violations per best practices) and any database alerts logged in the alert log. The one that you've pasted below is because of the execute privs granted to public in the database and Oracle thinks that is a potential security hole. Try this -- At sql*plus prompt --
1) select * from dba_tab_privs where table_name='UTL_FILE'; => This will show the granted priv on the object (EXECUTE in this case)
2) revoke EXECUTE on SYS.UTL_FILE from PUBLIC; => Will revoke the priv from public
BTW, UTL_FILE is a package to write to external files (os) from inside the oracle engine. Hope this helps. - Ravi |
|
