on 11-24-2014 8:23 AM
Hello to all!
Oracle didn't want to startup automaticly after rebooting the Windows.
When I run sqlplus / as sysdba I see message:
connected to idle instance
If I make a startup - all ok and I can start the SAP system with the MMC console.
What should I do to start system only with MMC console and don't use sqlpluse before it ?
Thanks!
I'v found it ! To make oracle automatic database startup I should edit the following reg parameter:
HKLM\Software\Oracle\HomeX\ORA_<DBSID>_AUTOSTART
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Igor,
You need to create another service of oradim which will start your oracle system.
oradim -startup -sid <SID> –usrpwd manager -starttype SRVC,INST -pfile <installed Directory>:\<oracle_home>\dbs\<spfile location>
startup - It will start the database instance
sid - Database sid
usrpwd - Provide the password of the databse
starttype - Specifies whether to start the instance, the service, or both (SRVC, INST).
Also try with user password as well.
With Regards
Ashutosh Chaturvedi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
check the status of the oracle listener
lsnrctl status
start the listener if not started
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Make sure Oracle services are set to automatic on system startup.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Igor,
What you see in services.msc is only Oracle Listener and Oracle SID service which will start automatically. It will not start the oracle database instance. This needs to be started manually using sqlplus.
If you need to automate database instance start after reboot you may need to create a batch file and configure the same into scheduler.
Hope this helps.
Regards,
Deepak Kori
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.