•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 374,019 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,706 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Oracle advertiser:
Views: 10454 | Replies: 11
 |
•
•
Join Date: May 2007
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
i had the same problem and realized this:
i had installed oracle while i was not connected to the network... later when i restarted it being connected to the network... the OracleService had the same issues while starting up.
so i tried disconnecting form the network and restarted my machine and the service seemed to startup fine.... maybe i need to reinstall oracle while being connected... will try this out
i had installed oracle while i was not connected to the network... later when i restarted it being connected to the network... the OracleService had the same issues while starting up.
so i tried disconnecting form the network and restarted my machine and the service seemed to startup fine.... maybe i need to reinstall oracle while being connected... will try this out
•
•
Join Date: May 2007
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
1. 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: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0
Note 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 ORA_<SID>_AUTOSTART.
Note: Replace <SID> with the name of the your 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.
2. Create the following batch file with the name StartupOracleORCL.sql:
connect internal/oracle
startup
3. 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 3:
svrmgrl @<Full path of startupOracleORCL.sql created in Step 2>
4. Restart your system properly
5. (Every time before starting SQL Plus) Run the Orastart.bat file at a command prompt
Note: 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.
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: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0
Note 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 ORA_<SID>_AUTOSTART.
Note: Replace <SID> with the name of the your 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.
2. Create the following batch file with the name StartupOracleORCL.sql:
connect internal/oracle
startup
3. 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 3:
svrmgrl @<Full path of startupOracleORCL.sql created in Step 2>
4. Restart your system properly
5. (Every time before starting SQL Plus) Run the Orastart.bat file at a command prompt
Note: 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.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
Linear Mode
- Previous Thread: ORA-12157 error when installing Oracle 10g on Fedora 5
- Next Thread: Migration from SQL Server Reporting Services to Oracle Reports 10g
