Junior Member1. Change the startup setting of the instance of Oracle database such that the instance of Oracle database does not automatically start when the Oracle database service is started. To do so, follow these steps.Warning If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system.
Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.a. Click Start, and then click Run.b. In the Open box, type regedit, and then click OK.c. In Registry Editor, locate the following registry key: HKEYLOCALMACHINESOFTWAREORACLEHOME0Note The name of this registry key ends with the number zero (0), not the letter o.d. In the right pane of Registry Editor, double click ORAAUTOSTART.Note: Replace with the name of the Oracle database service.e. In the Edit String dialog box, type FALSE in the Value data box, and then click OK.f.
Close Registry Editor.Alternate for Step 2 and 3:Copy the given files, StartupOracleORCL.sql and Orastart.bat to C: drive )2. Create the following batch file with the name StartupOracleORCL.sql:connect internal/oraclestartup3.Create the following Windows batch file with the name Orastart.bat in the same folder where you created the StartupOracleORCL.sql batch file in step 2:svrmgrl @4.
Restart your system properly5.(Every time before starting SQL Plus) Run the Orastart.bat file at a command promptNote: a) You may notice that the instance of Oracle database starts successfully.b) Now you can start SQL plus from Program files and login with system/manager or scott/tiger. Attachment:(Size: 4.75KB, Downloaded 490 times). This is Solution for run Oracle in Windows XP1.Change the startup setting of the instance of Oracle database such that the instance of Oracle database does not automatically start when the Oracle database service is started.To do so, follow these steps.Warning If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.a. Click Start, and then click Run.b.
Re: Oracle 8i on Windows Server 2008 Standard Edition Installation Problem InoL Jul 18, 2011 12:45 PM ( in response to 822422 ) This is the Forms forum.
In the Open box, type regedit, and then click OK.c. In Registry Editor, locate the following registry key: HKEYLOCALMACHINESOFTWAREORACLEHOME0Note The name of this registry key ends with the number zero (0), not the letter o.d. In the right pane of Registry Editor, double click ORAAUTOSTART.Note: Replace with the name of the Oracle database service.e. In the Edit String dialog box, type FALSE in the Value data box, and then click OK.f. Close Registry Editor.Alternate for Step 2 and 3:Copy the given files, StartupOracleORCL.sql and Orastart.bat to C: drive )2.Create the following batch file with the name StartupOracleORCL.sql:connect internal/oraclestartup3.Create the following Windows batch file with the name Orastart.bat in the same folder where you created the StartupOracleORCL.sql batch file in step 2:svrmgrl @4. Restart your system properly5. (Every time before starting SQL Plus) Run the Orastart.bat file at a command promptNote: a) You may notice that the instance of Oracle database starts successfully.b) Now you can start SQL plus from Program files and login with system/manager or scott/tiger.Try to solve your problem.Thank you,Rameshkumar.G.
Attachment:(Size: 4.75KB, Downloaded 464 times). Installation of Oracle8i on Windows XPThis is a work around to Install Oracle 8i on Windows XP:1 - Copy the content of your Oracle CD into hard disk in yourmachine.
For example Copy from oracle8i CD into D:Oracle.2 - Search the file Symcjit.dll on the D drive (where you havecopied Oracle8i. You can found it in:- For Oracle8i 1.7:D:OraclestageComponentsoracle.swd.jre1.1.7.301DataFilesExpandedjrewin32binsymcjit.dll- For Oracle8i 1.6:D:OraclestageComponentsoracle.swd.jre1.1.7.241DataFilesExpandedjrewin32binsymcjit.dll3 - Rename this file (Example): symcjitback.dll4 - Execute the Oracle setup.exe from D:Oraclesetup.exe.Ramez.
Senior Memberi have installed oracle 8i on my windows xp system. It has not given me any problems during installation. I could log on to oracle and work on it without any problems.
But when i restarted my system, my system has failed to start the oracle service, and i could no longer logon to sql. plus. I've got messages 'oracle not available'. I've even tried to start the service from adminstrative tools-services, but of no use.
Then i created a new database and log on to sql. plus. But when i rebooted my system, the problem continued. Junior MemberPrasad:Unfortunately, I will tell you that Oracle does not have plans at this time to certify the 8i version of the database for Windows XP.
Oracle9i Release 1 is the first version to be offically tested and supported on XP, and this is on Windows XP Professional (the home edition is not certified).Oracle will likely anounce certification of the 8i CLIENT software ONLY, starting in June. This means that the 8i version of the database is not tested on XP at all, and you may encounter problems.Having said that, the symptoms you describe do sound similar to a known bug with Oracle 8.1.6 on Windows 2000. BUG#1266248 results in the Service for the instance being stuck in a 'Starting' status after a reboot. You do not mention the version of database that you are running. This bug only affects 8.1.6.
If you are running this version, you should obtain and apply the 8.1.6.3.0 patchset, followed by the 8.1.6.3.8 patchset (You must apply these patches in that order, as 8.1.6.3.8 has the fix, but it can only be applied over the top of 8.1.6.3.0). These patches are available from Metalink as Path#1650087 and Patch#2102378, respectively.Ultimately, if this is just for personal use, you may want to consider dowloading Oracle9i and using that release, since it is certified for XP Professional Edition.Hope that helps.Scott.
Junior MemberHi Prasad,I have recently installed Oracle 8i on my xp system and ran into the same trouble. Since Im a new user to Oracle itself, the solution that im giving here may not be the right one. But it works for me.Here are the things to do.After the system reboot, most of the Oracle servers willbe running bcos of the 'Automatic' setting in the system services startup. Change the start-up options to 'Manual' for all the 5 services (OracleOraHome81TNSListener, OracleOraHome81DataGatherer,OracleOraHome81ClientCache,OracleOraHome81Agent and OracleWebAssistant0).
Also change the (Assume your instance name is Prasad) OracleServicePRASAD service to Manual.Then once the system restarts, start the services one by one in the above listed order (I got some problems when I changed the order. But Im not sure abt that).
Then start your OracleServicePRASAD. It will come out with a dialouge box saying that 'Unable to start' and the status will be 'Starting'.Go to the Task Manager, Kill the one and only ORACLE process running.
Come back again and restart the OracleServicePRASAD service. Eventhough the status shown will be 'Starting' you will be able to start the service.If you find any problem with this sequence, mail me back.
Or of you got any easy steps for the same, just update me.thanks,John. Junior MemberI installed Oracle8.1.5.0 on Win XP and could use SQL with oracle and everything worked fine but only till i hadn't rebooted my system And I also tried to start the DB from the 'Administration Assistant for Win NT'. It gave me the error message 'failed to start service. Error 0x80070420'.It gives me an error saying Oracle Not available and also No listener.Have also copied the tnsnames.ora file from networkadmin but it doesnt seem to work.With a different name and password it says connected to idle instance.I am a new to oracle. If the problem is very simple sorry abaout that.Your help will be appreciated.ThanksRegards,KrupaliNow, what should I do?
Please reply. Junior MemberRespected Sir/Mam,I have faceing a problem in windows xp at the time of installation of oracle 8i server. Install oracle 8i server 02 services has been started:1)Listner2)Instantbut after re-boot the system,windows-xp has been on,but only one service has started Listner service and another service(Instant service) not started only message showing 'STARTING' but services not started.But I have one another trial for INSTANT SERVICE started, I have goen through dos command: 1) Svrmgrl2) connect oracle3) start serviceservice has started showing in oracle status but after the re-boot the system or shutdown the system after the re-start the system service(Instant Service) has been again stop. Why Instant Service not automatically started.Please reply as soon as possible in my yahoo email address.Thanking youRanjan.
Junior MemberYeh this problem exists with win xp. However I tried to get the remedy from net and landed here to know that this problem is being faced by others and their seems to be no solution. However after trying everything, I have just today created one more database alongwith the existing database through startProgramsOracle-oraHome8idatabase administration database configuration assistant. And to my pleasure and happiness I found the second database running quite effeciently and I have since then turned off and on my system at least five times and database is now starting efficiently without any errors such as ORA-01034 and error (0x80070420)Hope this will help you, if not previously set right.Raj B GanjooJammu. Junior Memberhi Bill,I have been running Oracle 8i on my Windows XP machine.exactly. as you describe, i.e., killing oradim.exe which is actually the bone of contempt and gets stuck, and then restarting both OracleDefaultPOTNSListener and OracleServiceSam services; for nearly a month!But today a wonderful thing happened!
As i sat to work and tried to start Oracle, it did not start by this method! Even this method has seized to work! One of my projects has gone half way and things are stuckRegards,Sam.xxxxxxxxx.
Junior MemberHi,Am new to Oracle.I found a solution for Oracle 8i with XP. Please try it.Open SQL Plus from start/all programs/Oracle-Ora81/Application Development/SQL Plus. It will prompt for username and password. Just press OK without typing anything. Now in SQL Plus, it will ask for 'Enter Username:'.
Type CONNECT INTERNAL/ORACLE and press enter.It will connect to idle instance. Then in SQL Prompt, type STARTUP OPEN and press enter. It will start the database showing the below'Total System Global AreaFixed SizeVariable SizeDatabase BuffersRedo BuffersDatabase mounted.Database opened.' Then in sql Prompt, type CONNECT SCOTT/TIGER (or CONNECT SCOTT/TIGER@databasename (where databasename is the name of your database you have given while installing oracle 8i)It will be connected.Try it and give me a reply. ORA-01031: insufficient privileges.Cause: An attempt was made to change the current username or passwordwithout the appropriate privilege. Junior MemberDear Prasad Ji,Try the following stepsGo to start menu-Run-type CMD press enterMSDOS command prompt will openType SVRMGRL press enterType CONNECT INTERNAL/ORACLE press enterType STARTUP press enterThis will start the oracle.Now close the MSDOS window.On windows XP oracle does not start automatically on system startup. It can be started manually as above on every system startup.
Trying to start Oracle from the services option does not work.Hope this solves your problem.RegardsApoorva.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |