Rocky4.2 Installing the Kanakura V7 Database (kingbasees)

1. Preparing the operating system1.1 System Login Interface

1.2 Operating system version information

jdbh:~ # uname-2.6. 27.54-rocky4. 2-x86_64 #1: £ ºx86_64 gnu/  LINUXJDBH:~ # cat/etc/4.2.  x86_64 Security (-

2. Install the Dream database2.2 Configuring the user environment

Creating a user as an installation user for a database is generally not recommended for root user installation, based on security considerations.

jdbh:/# Groupadd JINSTALLJDBH:/# mkdir/home/JCDBAJDBH:/# Useradd-g jinstall-d/home/jcdba jcdbayour passwd isUF84BAYZJDBH:/home/DMDBA # passwd jcdba new UNIX Password: Re-enter the new UNIX password: passwd: The password was successfully updated JDBH:/# mkdir/KINGBASEJDBH:/# ls-ld/kingbase/drwxr-xr-x2Root root4096March4  -: $/kingbase/JDBH:/# Chown-r jcdba.jinstall/kingbase/JDBH:/# ls-ld/dmdbms/drwxr-xr-x2JCDBA Jinstall4096March4  -: $/kingbase/

2.2 Uploading the installation package

The

Linux system requires the use of FTP tools to upload the installation package to the system, you can use the third-party tools also can take advantage of the system itself with the FTP service, using commands to upload files.

 [email protected]:~ > ls-l total usage   2  jcdba Jinstall 4096  July 2014   Desktop -rwxr-xr-x 1  jcdba Jinstall 179266489  July 2  2014  kdb-7.1 . 2.0020 -release-linux-x86_64-installer- Build0003 (for_grid). zip -rw-r--r--1  jcdba jinstall 4096  July 2  2014  license.dat 

2.2 Performing a database software installation

[Email protected]:~ > Unzip kdb-7.1.2.0020-release-linux-x86_64-installer-build0003\ (for_grid\). zip archive:kdb-7.1.2.0020-release-linux-x86_64-installer-build0003 (for_grid). zip Creating:setup/inflating:setup.sh Inflating:setup/Install.bin Inflating:setup/installer.properties Extracting:setup/MD5 [email protected]:~ > LS-L Total Dosage175264drwx------2JCDBA Jinstall4096July2  theDesktop-rwxr-xr-x1JCDBA Jinstall179266489July2  thekdb-7.1.2.0020-release-linux-x86_64-installer-build0003 (for_grid). zip-rw-r--r--1JCDBA Jinstall4096July2  theLICENSE.DATDRWXR-xr-x2JCDBA Jinstall4096August3  -Setup-rw-r--r--1JCDBA Jinstall2762August2  -SETUP.SHDRWXR-xr-x3JCDBA Jinstall4096March9 Ten: theTest

Unzip (unzip) the installation package, which will generate the Setup folder and the setup.sh file. When installing, we need to perform setup.sh to install. When performing a database installation, you need to check whether the installation file setup.sh has execute permissions. If you do not have Execute permissions, you can add execution permissions to the installation package through the chmod +x setup.sh command, and the KDE interface of the rocky system can be installed directly via the graphical interface (directly executed./setup.sh), and can of course be installed via the character interface. It is important to note that the current user must have read and write access to the database's installation directory. Below we execute directly./setup.sh Install the Gold Silo database under the graphical interface.

1. Execute the./setup.sh file

2. The Installation Start screen appears

3. Launch to the Installation Wizard Welcome screen, click Next

4. Accept the license agreement and click Next

5. Select the installation mode

6. Installation Environment Check

7. Select an authorization file

8. Select the installation location (the current user must have read and write access to the installation location)

9. Installation General overview Information

10. Performing the installation

11. Configure the remote management account

12. Installation Configuration Tips

13.initdb re-initializing the database

When we click Finish, we find that the system does not automatically call us to initialize the database interface, then we will use a manual way to perform a database creation. (In fact, the initialization database option here can be considered as a parameter, check this parameter, in the subsequent initialization of the database will automatically initialize a template library, it does not actively invoke the initialization database Tools)

14. Execute root.sh script as root user

jdbh:~ #/kingbase/es/v7/install/root.sh installing ODBC driver ... ODBC Driver isInstalled successfully!Installing krms7d ... The Krms service was successfully installed. krms7d isInstalled successfully!krms7d isStarting...krms already running. [OK] successfully started the Krms service. krms7d Start successfully!Installing kingbase7d...kingbase7d isInstalled successfully!Installing jobmgmt7d...jobmgmt7d isInstalled successfully!Installing kdbws7d...kdbws7d isInstalled successfully!kdbws7d isstarting...kdbws7d has already started.kdbws7d start successfully!starting to initialize database ... Starting System initialization failed or error (s) occurred whileinitializing database. Can see/kingbase/es/v7/install/root.log forDetails.complete.

From the Red Word section above we can see the error when initializing the database!

View the error log report for the following:

starting to initialize database ... ExceptioninchThread"Main"java.lang.ExceptionInInitializerErrorCaused by:java.awt.HeadlessException:No X11 DISPLAY variable wasSet, but ThisProgram performed an operation which requires it. At Java.awt.GraphicsEnvironment.checkHeadless (Graphicsenvironment.java:159) at Java.awt.Window.<init> (Window.java:432) at Java.awt.Frame.<init> (Frame.java:403) at Java.awt.Frame.<init> (Frame.java:368) at Javax.swing.JFrame.<init> (Jframe.java:158) at Com.kingbase.jinitdb.JInitdb.<clinit>(Unknown Source) Could not find the mainclass: Com.kingbase.jinitdb.JInitdb. Program would exit. Starting System initialization failed or error (s) occurred whileInitializing database.

In the following chapters we will try to initialize the database manually.

2.3 Initializing the database manually

Manually perform/kingbase/es/v7/bin/javatools.sh Jinitdb to bring up the graphical initial tool.

1. Start the Initialization Wizard (javatools.sh jinitdb)

2. Specify the Data directory (note that disk space is sufficient)

3. Specify the administrator user password

4. Specify the database name and note the setting of the character set

5. Specify database application scenario configuration information

6. Specify database Memory parameters

Note that this configuration is very important, and the impact on subsequent system performance is very large. Where the page size is to be configured according to the system type (OLTP/OLAP), the maximum number of links is determined by the license file. The configuration of the memory parameters is to be configured appropriately with the maximum number of links.

7. Summary of database parameter information

8. Registering an instance

9. Perform initialization operations

10. The master user executes the script and completes the initialization.

Executes the specified script:

[Email protected]:/kingbase/es/v7 >/kingbase/es/v7/data/instancereg.sh Successful instance 'kingbasees_ Instance1" is set to system service. Successfully added the instance to "instance.conf" . Can't source/kingbase/vs/v7/bin/functions start service "kdbkingbasees_instance1d  " failed. [Email protected]:/kingbase/es/v7 > source/kingbase/vs/v7/bin/functions-bash:/kingbase/vs/v7/ Bin/functions: No file or directory

Can be found above to start the service failure, we can start manually!

For the above initialization of the database using the graphical tools, we can also use another tool to initialize the data, in the absence of graphical tools in the environment can be used:

2.4 Starting the database service

The kingbase process can be seen through the Pstree command

2.5 jsql Login Test

Rocky4.2 Installing the Kanakura V7 Database (kingbasees)