Cloud Admin Club

Operating system crashes are one of the issues that might face you especially if your server is using windows. This article explains how backup oracle database from windows safe mode. and by example, I will explain the steps to start oracle in windows safe mode and backup it up.

Unfortunately, If you try to start the Oracle database while your Windows OS was in safe mode, It will fail giving an error message

Error 1058: The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.

Start DB Service Error

Also, if you tried to use the command line by starting the instances or listener you will get the Listner error

TNS-12500 TNS: protocol adapter error.
 TNS-00530: Protocol adapter error

Enable Oracle Service.

Change the Oracle service status, This will enable you to start the oracle database in safe mode. In this example Oracle database instance is ORCL, and as a result, the service name is Oracle ServiceORCL.

You can use either Command line interface, execute the following command

sc config OracleServiceORCL start=auto

Or if you prefer using Windows graphical interface, then follow these steps to enable Oracle services in Windows services

Right-click on start windows then click on Computer Management.

In the right-side panel expand Service and Applications, then click Service Link.

On the left side, make sure that the Oracle database and listener services are not disabled. To enable the services, double-click to open OracleServicesORCL properties then select manual from the startup type drop-down menu.

Repeat the process for the listener service.

Configure the service to run on windows safe mode.

add the following entries to the windows registry, allowing the Oracle services to run in Operating system safe mode.

REG ADD "HKLM\SYSTEM\CurrentControlSet\Control\SafeBoot\Network\OracleServiceORCL" /VE /T REG_SZ /F /D "Service"

REG ADD "HKLM\SYSTEM\CurrentControlSet\Control\SafeBoot\Minimal\OracleServiceORCL" /VE /T REG_SZ /F /D "Service"

Start oracle database

It’s essential to have your oracle database running to take a backup of the data you can start the service from the Computer management graphical interface. Just right-click on the service name then choose start.

or execute the following command from the Command prompt

net start OracleServiceORCL

To confirm that oracle is started. try to log in using sqlplus

sqlplus / as sysdba

Backup oracle database in safe mode:

To export the full database execute the following command

expdp directory=dump full=Y dumpfile=lastbackup_YYYYMMDD.dmp logfile=lastbackup_YYYYMMDD.log

This command used the database object directory named dump to save the database dump.

To create a directory using the following SQL statement.

SQL> CREATE DIRECTORY dump AS 'd:\dump_dir';

In Conclusion, If you were able to log in to your system in “Windows” safe mode, you will be able to back up the Oracle database from windows safe mode and recover your data from the database. follow the simple instruction mentioned earlier.

Confusing issue!

Today’s adventure, We have an ADF application installed on Weblogic. That application is running behind an IIS reverse proxy. Though the application is working normally and its pages are loading normally, there are certain pages that fail to open showing error ERR_CONNECTION_RESET.

The developers are saying “It’s working on my PC”

Tracing error ERR_CONNECTION_RESET.

As a good administrator, I will investigate using the deduction process. hence, what I will do.

Initially, I will open the application directly using the URL of Web-logic deployment URL, that means, I opted out reverse proxy. Surprisingly, application pages including those pages work normally. That means the application has some requirements and ISS can’t fulfill them. Causing, connection to reset.

Solving ERR_CONNECTION_RESET

To solve that error, We need to increase the Response buffer cache and Response buffer threshold in IIS Server. By following steps

Firstly, Open IIS Administration console. Then, Click on the root structure on the left panel to view IIS icons. Secondly, click on the Application Request Routing icon.

IIS reverse proxy ERR_CONNECTION_RESET IIS main page

After that, Click Cache Configuration settings located on the upper right side.

In the Cache configuration setting window navigate into the buffer settings section, then, Increase the value of the Response buffer cache and Response buffer threshold.

Conclusion, IIS ARR buffer cache causes the ERR_CONNECTION_RESET due to insufficient buffer cache size. Therefore, Increasing the values will solve the issue.

Troubleshoot

Start Oracle database in Windows safe mode