How to start the database in single-user mode for maintenance? (DBMR2947)

~ 0 min
2020-04-22 11:36

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

Average rating 0 (0 Votes)

You cannot comment on this entry

Tags