Compiled Messages: ------------------------------------------------------------ Message no. 3 Posted by Peter Ping Liu (TEC5363PL) on Monday, August 21, 2006 7:51am Subject: Participation is Required Every Week Please note that participation and response(s) from every student in the class are required every week. Due date policy applies to this "Community Solutions" as well. ------------------------------------------------------------ Message no. 20[Branch from no. 3] Posted by Rhonda Nichols (renichols2) on Wednesday, August 23, 2006 8:02pm Subject: Re: Participation is Required Every Week Has anyone had much experience installing and using 10g? I have used mainly 9i. I have installed 10g on Linux with no problems but my laptop has not been as easy ;-( -Rhonda ------------------------------------------------------------ Message no. 22[Branch from no. 20] Posted by Krishnamurth Ashwini (kashwini) on Wednesday, August 23, 2006 10:08pm Subject: Re: Participation is Required Every Week Hey Rhonda, Welcome back. Nice to talk to you again. I had installed 10g on to my laptop for our previous database class without any problem. I actually uninstalled it right after our final class. Now I installed it again for this class without any trouble. But I would like to mention that, it can significantly reduce your laptop's performance. Let me know if you have any problem installing it. I had actually saved the steps (with screen shots) for installation during our previous class. I can give it to you if you need. Bye Ash ------------------------------------------------------------ Message no. 23[Branch from no. 20] Posted by Daniel Thurston (dsthurston) on Wednesday, August 23, 2006 10:43pm Subject: Re: Participation is Required Every Week Howdy Rhonda What Operating system are you using on your laptop?? Dan ------------------------------------------------------------ Message no. 24[Branch from no. 23] Posted by Rhonda Nichols (renichols2) on Thursday, August 24, 2006 8:07am Subject: Re: Participation is Required Every Week 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[Branch from no. 24] Posted by Krishnamurth Ashwini (kashwini) on Thursday, August 24, 2006 8:44am Subject: Re: Participation is Required Every Week includes attachment 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 ------------------------------------------------------------ Message no. 26[Branch from no. 25] Posted by Rhonda Nichols (renichols2) on Thursday, August 24, 2006 8:59am Subject: Re: Participation is Required Every Week Thanks Ash...I will give it a try tonight. I saw these instructions but without knowing what it was doing I was a little leary of doing it but if it worked for you I'll give it a shot. -Rhonda ------------------------------------------------------------ Message no. 27[Branch from no. 26] Posted by Krishnamurth Ashwini (kashwini) on Thursday, August 24, 2006 9:32am Subject: Re: Participation is Required Every Week Sure...give it a try. Hope it works for you too. Ash ------------------------------------------------------------ Message no. 28[Branch from no. 27] Posted by Naziya Shaik (snaziya) on Thursday, August 24, 2006 3:11pm Subject: Re: Participation is Required Every Week I installed 10g on my laptop and my laptop started to slowing down...i wondering why.. now i get it... i hope i dun face any further problems... ------------------------------------------------------------ Message no. 29[Branch from no. 28] Posted by Naziya Shaik (snaziya) on Thursday, August 24, 2006 3:13pm Subject: Re: Participation is Required Every Week oops..so many typos... (started slowing)* ( i was wondering)* ------------------------------------------------------------ Message no. 31[Branch from no. 29] Posted by Venkat Munagala (vrmunagala) on Thursday, August 24, 2006 3:52pm Subject: Re: Participation is Required Every Week Hi all. I have installed Oracle 10g for the previous class. My laptop too became slower. But it works a bit faster when you manually start the service when required. we do it from Control Panel> Administrative tools> Services. just manually stop oracle and start it when required. Hope this helps. Rohit ------------------------------------------------------------ Message no. 32[Branch from no. 31] Posted by Suresh Methuku (smethuku) on Thursday, August 24, 2006 3:55pm Subject: Re: Participation is Required Every Week Hii rohit I will definetley give a try. thanks mate. ------------------------------------------------------------ Message no. 33[Branch from no. 31] Posted by Lakshmikar Padmaraju (lpadmaraju) on Thursday, August 24, 2006 4:13pm Subject: Re: Participation is Required Every Week Hello everybody, Yes, I agree with rohit. It is better to start process manually whenever you are working with Oracle, otherwise it will dead slow particularly on loptop, I have dual core processor with 1gb ram still i can't work if i wont stop oracle instance. Good tip rohit, keep it up. Raju ------------------------------------------------------------ Message no. 36[Branch from no. 31] Posted by Gnaneshwar Bukka (gbukka) on Thursday, August 24, 2006 4:47pm Subject: Re: Participation is Required Every Week Hey Rohit, How are you, I installed Oracle when I toke the Oracle class last Semester and I do the same thing, stop it while not using it. Cheers, Gnaneshwar Bukka. ------------------------------------------------------------ Message no. 38[Branch from no. 20] Posted by Paras Pradhan (ppradhan) on Thursday, August 24, 2006 9:15pm Subject: Re: Participation is Required Every Week Hi all: I came across this url http://www.debian-administration.org/articles/430 which guides to install oracle10g XE in Linux Distributions. It has steps to install oracle in Debian Linux but ony can get the idea for installion in other linux flavours as well. Paras. ------------------------------------------------------------ Message no. 40[Branch from no. 36] Posted by Eric Knuth (elknuth2) on Thursday, August 24, 2006 9:39pm Subject: Re: Participation is Required Every Week Good Evening The 9i and 10g installs of Oracle on windows automatically start the services at boot. I have in the past changed the startup type of the Oracle services (under control panel). Also you might change the registry key HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/ DATABASE_STARTUP to NOAUTO Let me know if that works for you. Thanks Eric ------------------------------------------------------------ Message no. 41[Branch from no. 3] Posted by Eric Knuth (elknuth2) on Thursday, August 24, 2006 9:48pm Subject: Suggestion for All I have a suggestion for all. Go to oai.oracle.com and register as as student. This will let you into the oracle users area and will let get the documents for all the installation types. Eric ------------------------------------------------------------ Message no. 42[Branch from no. 38] Posted by Eric Knuth (elknuth2) on Thursday, August 24, 2006 9:50pm Subject: Re: Participation is Required Every Week I have instructions for installing 9i on Redhat 8 and 9 if anyone needs them. I also have instructions for Redhat AS 3.0 and 4.0 Just let me know if you need them. Eric ------------------------------------------------------------ Message no. 43[Branch from no. 3] Posted by Eric Knuth (elknuth2) on Thursday, August 24, 2006 9:55pm Subject: For the Mac users If anyone is interested, I have done Oracle installations on Mac OSX and on dual boot redhat/OSX with 10g. I have also used the new intel macs with parallels virtual machine software to put Redhat AS 3.0 and 10g. I have also put Windows boot camp on it and put 10g on windows on the intel mac. Eric ------------------------------------------------------------ Message no. 44[Branch from no. 24] Posted by Daniel Thurston (dsthurston) on Thursday, August 24, 2006 9:55pm Subject: Re: Participation is Required Every Week I havent done the install yet, but I will probably run into the same thing. I am wondering if it may be easier to just set the IP to static for the install and back to DHCP when done with the install. I have done the same with hostnames (fully qualified vs short) I wonder if there would be any repercussions with this? I can see where it would be problematic for a live database to be DHCP (the same goes for most other servers on a network) but for the purposes of this class it would probably be fine. Dan ------------------------------------------------------------ Message no. 45[Branch from no. 3] Posted by Eric Knuth (elknuth2) on Thursday, August 24, 2006 10:02pm Subject: Linux Users 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 ------------------------------------------------------------ Message no. 47[Branch from no. 45] Posted by Naziya Shaik (snaziya) on Friday, August 25, 2006 12:47am Subject: Re: Linux Users I was trying to figure out the reasons of system's slowing down... i was looking at the requirements again(windows environment)...i found that system needs minimum 1GB. The thing is i dont have 1GB RAM, so am i supposed to uninstall in this system and try in another system which has 1GB RAM? ------------------------------------------------------------ Message no. 48[Branch from no. 47] Posted by Ravinder Gaur (rgaur) on Friday, August 25, 2006 7:37am Subject: Re: Linux Users 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 ------------------------------------------------------------ Message no. 49[Branch from no. 48] Posted by Ravinder Gaur (rgaur) on Friday, August 25, 2006 7:41am Subject: Re: Linux Users Looks like the html editor messed up with the pfile location I indicated earlier. Here is it again w/o the "less-than" and "greater-than" symbols -- ORACLE_HOME\ADMIN\DBNAME\PFILE (could be slightly different depending on what you chose during install). - Ravi ------------------------------------------------------------ Message no. 51[Branch from no. 43] Posted by Lakshmikar Padmaraju (lpadmaraju) on Friday, August 25, 2006 9:00am Subject: Re: For the Mac users Hi Eric, Welcome back to class, hope you enjoyed your summer. I am wondering all the time whether you going to install Oracle on Mac or you going to cross line to windows? Kudos to you for sticking with the line and installing it on MAC. see you Raju. ------------------------------------------------------------ Message no. 52[Branch from no. 47] Posted by Lakshmikar Padmaraju (lpadmaraju) on Friday, August 25, 2006 9:03am Subject: Re: Linux Users Nazia, I don't thing that is a good idea, it won't improve much, best thing is Start Oracle instance when required and stop after you done with your work. Raju. ------------------------------------------------------------ Message no. 53[Branch from no. 20] Posted by Sagun Piya (srpiya2) on Friday, August 25, 2006 12:19pm Subject: Re: Participation is Required Every Week I have installed the oracle 10g last semester. I got lot of problems during last semester. but I did not face any problems during this semester. yeah, after installing oracle, it makes your computer dead slow. So manually try to stop running oracle when you are not using it. Sagun ------------------------------------------------------------ Message no. 54[Branch from no. 41] Posted by Sagun Piya (srpiya2) on Friday, August 25, 2006 12:19pm Subject: Re: Suggestion for All Thanks Eric for your information. ------------------------------------------------------------ Message no. 56 Posted by Lakshmikar Padmaraju (lpadmaraju) on Friday, August 25, 2006 3:42pm Subject: computer Slowdown after oracle slowdown 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. ------------------------------------------------------------ Message no. 57[Branch from no. 56] Posted by Sagun Piya (srpiya2) on Friday, August 25, 2006 7:58pm Subject: Re: computer Slowdown after oracle slowdown thanks for your suggestion Sagun ------------------------------------------------------------ Message no. 58[Branch from no. 42] Posted by Sagun Piya (srpiya2) on Friday, August 25, 2006 7:59pm Subject: Re: Participation is Required Every Week Sure, I'm gonna let you know, if I need any help from you guys. Thanks Sagun ------------------------------------------------------------ Message no. 62[Branch from no. 56] Posted by Daniel Thurston (dsthurston) on Friday, August 25, 2006 9:00pm Subject: Re: computer Slowdown after oracle slowdown Has anyone tried to disect why their machines are slowing down? is it CPU? Memory? Network? other? all of the above? Cheers Dan ------------------------------------------------------------ Message no. 65[Branch from no. 47] Posted by Kelsey Pooley (kjpooley) on Friday, August 25, 2006 11:13pm Subject: Re: Linux Users When I loaded it on my laptop last semester, I had a lot of trouble with it. I removed some items from my hard drive to create more space because Oracle is such a space hog! The first time I tried to install (after waiting nearly two hours for it to download from Oracle's website) it would reach a certain point and then lock up my entire computer. I finally got it installed but it wasn't working properly. Eventually, I dumped it, downloaded it again and reinstalled it exactly the same way and it worked fine. My point is, if you're having trouble and you can't figure out why, it might not hurt to try starting over. It may end up saving you time in the long run. Good Luck! ------------------------------------------------------------ Message no. 67[Branch from no. 62] Posted by Naziya Shaik (snaziya) on Saturday, August 26, 2006 11:08am Subject: Re: computer Slowdown after oracle slowdown i think the reason is because of RAM. Its not at all related to Network. ------------------------------------------------------------ Message no. 68[Branch from no. 67] Posted by Naziya Shaik (snaziya) on Saturday, August 26, 2006 11:24am Subject: Re: computer Slowdown after oracle slowdown adding to previous msg.. computer has picked up its speed, after manually stopping oracle from HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE..... Thank you ------------------------------------------------------------ Message no. 70[Branch from no. 56] Posted by Gnaneshwar Bukka (gbukka) on Saturday, August 26, 2006 11:57am Subject: Re: computer Slowdown after oracle slowdown Hi, This one looks good, better to stop oracle from loading along with the computer. Thank you very much. Cheers, Gnaneshwar Bukka. ------------------------------------------------------------ Message no. 71 Posted by Naziya Shaik (snaziya) on Saturday, August 26, 2006 11:57am Subject: Diagnostic summary 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? ------------------------------------------------------------ Message no. 72[Branch from no. 26] Posted by Rhonda Nichols (renichols2) on Saturday, August 26, 2006 12:35pm Subject: Re: Participation is Required Every Week Worked like a charm...Thanks Ash. -Rhonda ------------------------------------------------------------ Message no. 73[Branch from no. 71] Posted by Ravinder Gaur (rgaur) on Saturday, August 26, 2006 1:30pm Subject: Re: Diagnostic summary 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 ------------------------------------------------------------ Message no. 76[Branch from no. 70] Posted by Ravinder Gaur (rgaur) on Saturday, August 26, 2006 3:08pm Subject: Re: computer Slowdown after oracle slowdown includes attachment 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 ------------------------------------------------------------ Message no. 77[Branch from no. 58] Posted by Anjana Divakar (adivakar) on Saturday, August 26, 2006 3:22pm Subject: Re: Participation is Required Every Week I found a nice quotation online so thought I would share it with all of you. "Technology is dominated by two types of people: those who understand what they do not manage, and those who manage what they do not understand." ------------------------------------------------------------ Message no. 78[Branch from no. 76] Posted by Naziya Shaik (snaziya) on Saturday, August 26, 2006 7:23pm Subject: Re: computer Slowdown after oracle slowdown while starting OracleService%ORASID% sometimes i am getting a warning like "could not start the OracleServiceORCL (where ORCL is my SID) service on Local Computer". the service did not return an error. it says that this could be an internal windows error or an internal service error. but i get this error while manually starting the service. Why do I get this kind of warning. if i try this twice or thrice, it works. Why so? ------------------------------------------------------------ Message no. 79[Branch from no. 73] Posted by Naziya Shaik (snaziya) on Saturday, August 26, 2006 7:43pm Subject: Re: Diagnostic summary But Ravi, ------------------------------------------------------------ Message no. 80[Branch from no. 78] Posted by Ravinder Gaur (rgaur) on Saturday, August 26, 2006 7:47pm Subject: Re: computer Slowdown after oracle slowdown Can you send a screenshot of the error? ------------------------------------------------------------ Message no. 81[Branch from no. 79] Posted by Naziya Shaik (snaziya) on Saturday, August 26, 2006 7:48pm Subject: Re: Diagnostic summary But Ravi, it says that I did not grant any kind of privileges to revoke...... ------------------------------------------------------------ Message no. 82[Branch from no. 81] Posted by Ravinder Gaur (rgaur) on Saturday, August 26, 2006 7:52pm Subject: Re: Diagnostic summary Naziya, I believe that execute priv on utl_file comes by default during a default database create via oui. What do you see from querying dba_tab_privs? Regardless, you should be able to revoke it logged in as sys or system. ------------------------------------------------------------ Message no. 83[Branch from no. 62] Posted by Anjana Divakar (adivakar) on Saturday, August 26, 2006 9:00pm Subject: Re: computer Slowdown after oracle slowdown yeah i also had the same problem! I think its the network as well as the cpu that slows down the system. Mine kept hanging a lot and i had to restart it many times. ------------------------------------------------------------ Message no. 84[Branch from no. 38] Posted by Sagun Piya (srpiya2) on Saturday, August 26, 2006 9:30pm Subject: Re: Participation is Required Every Week Thanks Paras for letting us know. Sagun ------------------------------------------------------------