神州通用数据库安装(单机)

环境:
OS:Centos 7
DB:V7

1.介质下载地址
http://www.shentongdata.com/old_bak/iso/wzsyx/ShenTong7.0_linux64.rar

2.安装rar
[root@localhost soft]# tar -xvf rarlinux-x64-5.3.0.tar.gz
[root@localhost soft]# cd rar
[root@localhost rar]# make install

3.解压数据库安装包
[root@localhost soft]#rar x ShenTong7.0_linux64.rar
[root@localhost soft]#cd ShenTong7.0_linux64/
[root@localhost ShenTong7.0_linux64]#chmod u+x setup
[root@localhost ShenTong7.0_linux64]#./setup -f auto-install.xml

软件安装在如下目录:
[root@localhost ShenTong]# pwd
/opt/ShenTong

4.启动

[root@localhost db]# cd /etc/init.d
[root@localhost init.d]# ./oscardb_OSRDBd start 
Starting oscar -o normal -d OSRDB:
/opt/ShenTong/bin/oscar -o normal -d OSRDB running at 8194:SYSMULTIUSER:170
Database OSRDB startup failed

查看端口:
[root@localhost ShenTong]# ss -nlp|grep 2003
u_str  LISTEN     0      4096   /tmp/.s.oscar.2003 504208                * 0                   users:(("oscar",pid=8194,fd=14))
tcp    LISTEN     0      4096      *:2003                  *:*                   users:(("oscar",pid=8194,fd=13))
 

默认端口 2003
初始用户名 SYSDBA
默认数据库实例名 OSRDB
对应密码 szoscar55 ##谐音"神州奥斯卡55"
默认部署路径 /opt/ShenTong

5.登录

[root@localhost bin]#cd /opt/ShenTong/bin
[root@localhost bin]# ./isql -h localhost -p 2003 -d osrdb sysdba
Password for user sysdba: 
Welcome to isql 7.1.20200811 the ShenTongDB interactive terminal.
Type:  COPYRIGHT for distribution terms
       HELP for help with SQL commands
       ? for help on internal commands
       ! to run system commands
       EXIT to quit
SQL> 

[root@localhost bin]# ./isql -l
Password for default user: 
     List of databases
 Name  | Owner  | Encoding 
-------+--------+----------
 OSRDB | SYSDBA | UTF8
(1 row)

查看数据库
SQL> SELECT DATNAME FROM sys_database;
 DATNAME 
---------
 OSRDB
(1 row)

查询所有模式
SQL> SELECT NSPNAME FROM sys_namespace;
     NSPNAME     
-----------------
 DIRECTORIES
 INFO_SCHEM
 PUBLIC
 REPLICATION
 STAGENT
 SYSAUDIT
 SYSDBA
 SYSFTSDBA
 SYSSECURE
 SYS_GLOBAL_TEMP
 WMSYS
(11 rows)