How to start the database in single-user mode for maintenance? (DBMR2947)
You can use dmSQL or JDBA tool to maintain database in single-user mode. Follow below step to start the database for maintenance. Take database DBSAMPLE5 for example.
1. Using dmSQL tool
a. Terminate the database.
b. Run dmSQL tool.
c. Start the database DBSAMPLE5.
dmSQL> start db DBSAMPLE5 sysadm;
d. Maintain the database.
e. Terminate the database.
dmSQL> terminate db;
2. Using JDBA tool in Windows
a. Terminate the database.
b. Open dmconfig.ini, comment DB_SVADR and DB_PTNUM, and save it.
c. Open JDBA tool, and connect the database DBSAMPLE5.
d. Maintain the database.
e. Terminate the database.
f. Open dmconfig.ini, uncomment DB_SVADR and DB_PTNUM, and save it.
Version: 5.4.1
Product: Normal/Bundle
Platform: Windows/Linux