DM Database Installation and Use

DM Database Installation and Use
1. Download from the official website

Select Download based on the computer operating system
Note: Linux kernel versions must be 2.6.32 or later, and rhel must be at least 6.0 (libdmutl. so cannot be found)

2. List content

# Chmod 777 DMInstall. bin graphical interface installation: #./DMInstall. bin // It is recommended to use the interface characters to install: #./DMInstall. bin-I

3. Copy the configuration file

# cp bin/dm_svc.conf /etc/dm_svc.conf

4. Generate a startup Item

# Script/root/rootServiceInstaller. sh or # cp/dmdbms/bin/DmServiceDMSERVER/etc/init. d/

5. Database Configuration

Database configuration assistant (DBCA)
See client> DBCA.

6. Start the Database Service

windows：# D:\dmdbms\tool\dmservice.exelinux:# sudo /etc/rc.d/init.d/DmServiceDMSERVER start# service DmServiceDMSERVER start# /home/dmdbms/bin/dmserver /home/dmdbms/data/DAMENG/dm.ini -noconso &SQL> shutdown immediate;

7. Connect to the database

Windows: # D: \ dmdbms \ tool \ manager.exe linux: disql interactive tool # disql [[<option>] [<logon> |/NOLOG] [<start>] <option> :: = HELP |-H |-S <logon >:=< username> [/<password>] [@ <server>] [: <port>] [# <sslpath>] <start >::= '<file_path> [<PARAMETER_VALUE>...] HELP |-H |-S: HELP or-H indicates that the DISQL version information and HELP information are displayed.-S indicates that the DISQL interface is set to the hidden mode, that is, the <SQL> identifier <username> [/<password>] of the hidden command: Specifies the username and password of the database. The password must be capitalized. When you connect to local data, you do not need to specify the user name and password. By default, You can <SERVER>: Specify the IP address of the SERVER or the service name/NOLOG configured in dm_svc.conf: it indicates that DISQL is started and not connected to the server. In this case, you can set the DISQL display and perform local variable Operations <file_path>: the absolute path to run the disql script file. You can save multiple SQL statements in a text file. to execute all SQL statements in this file, run the start command, which is similar to the batch processing in dos. It is worth noting that when the DISQL interface is successfully entered, '<file_path> usage is still valid. <PARAMETER_VALUE> the parameter value passed to the local variable in the <file_path> script file, which is only valid for the first command in the file. If you use it in a linux environment, you need to add a single quotation mark (such as: ''<file_path> ') Example: # disql-s sysdba/SYSDBA@192.168.0.80: 5236 'C: \. SQL

8. Remote Logon

SQL> CONNusername: SQL> loginserver: After you enter the disql interface, if you want to switch to another database. To connect to a remote database, you must use an IP address or network service name in the service name.

9. disql Environment Variables

You can use the set command to set the environment variables of the current disql. Run the show command to check the setting of environment variables in the current system.
Multiple sets can be set at the same time. For example, set heading on timing on. After a set error occurs, the subsequent set will no longer work.

SQL> help setSQL> help show

10. Commonly Used disql commands 12. Frequently Used commands

The disql interactive tool dmmdf is used to modify the db_magic of the target database and the db_magic of the archive file in the source database (archive restoration). The dmrestore restores the database dpc_new proc compilation.

13. text Data Type

'=' Is not allowed during operation, and link is used for searching.

14. mode operation

SQL> SELECT * FROM dba_segments; // query mode SQL> set schema "SYSDBA"; // case sensitive SQL> ALTER SESSION SET CURRENT_SCHEMA = "SYSDBA "; // a very safe method

Table operations in different modes must be switched to different modes.

15. Other queries

SQL> select * from dba_tables; // query table space SQL> select * from v $ database; // view archived SQL> SELECT TABLE_USED_SPACE ('sysdb', 'T '); // query tables in the table space, case sensitive

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.