CHAR、NCHAR、VARCHAR2、NVARCHAR2、NUMBER、FLOAT、INT、INTEGER、SMALLINT、DEC、NUMBERIC、DECIMAL、DOUBLE PRECISION、DATE、TIMESTAMP、TIMESTAMP WITH TIME ZONE、TIMESTAMP WITH LOCAL TIME ZONE、INTERVAL YEAR TO MONTH、INTERVAL DAY TO SECOND、LONG、RAW、LONG RAW、CLOB、NCLOB、BLOB、JSON
TINYINT、SMALLINT、INT、INTEGER、BIGINT、DEC、DECIMAL、REAL、FLOAT、DOUBLE、DOUBLE PRECISION、NUMBER、NUMERIC、CHAR、CHARACTER、VARCHAR、VARCHAR2、NVARCHAR、NVARCHAR2、NCHAR、DATE、TIME、DATETIME、TIMESTAMP、TIME WITH TIME ZONE、TIMESTAMP WITH LOCAL TIME ZONE、TIMESTAMP WITH TIME ZONE、DATETIME WITH TIME ZONE、INTERVAL DAY TO SECOND、INTERVAL YEAR TO MONTH、BINARY、BLOB、CLOB、IMAGE、LONG、VARBINARY、LONGVARBINARY、LONGVARCHAR、RAW、TEXT
Flags: -h,--help Show detailed help information -v,--version Show Yashan-migrate-platform version information
Commonly used commands: install Initialize YMP with the built-in database and start --db <package path> new yashandb and yasldr package path [ --path <oci path> ] absolute path of the OCI installation restart Restart YMP with the built-in database status View status of YMP and built-in database uninstall Uninstall the built-in database [ -f ] force clean the environment upgrade Upgrade old version of YMP to new version --from <ymp path> path of old version of YMP [ --db <package path> ] new yashandb and yasldr package path [ --path <oci path> ] absolute path of the OCI installation password Change the password of YMP --sys <password> change sys password of built-in database in db.properties | --user <password> change user password of database in application.properties connection Change url、username、password of YMP --url <url path> change url in application.properties --username <username> change username in application.properties --password <password> change password in application.properties
Other commands: start Start YMP with the built-in database stop Stop YMP with the built-in database startnodb Start YMP with external database stopnodb Stop YMP with external database restartnodb Restart YMP with external database replace Replace yasldr version, need to restart ymp --yasldr <package path> new yasldr package path installnodb Initialize YMP with external database and start --db <package path> new yasldr package path [ --path <oci path> ] absolute path of the OCI installation
# （Oracle 做数据源的推荐方案）：安装内置库和 OCI 客户端并启动 YMP [ymp@ymp ~]$ cd /home/ymp/yashan-migrate-platform/bin/ [ymp@ymp bin]$ ./ymp.sh install --db /home/ymp/yashandb-personal-23.2.3.100-linux-x86_64.tar.gz --path /home/ymp/instantclient_19_19 2024-09-19 22:44:43 INFO --- [main] com.sics.command.YmpCommandMain : 指令入参：["--operation","install","--db","/home/ymp/yashandb-personal-23.2.3.100-linux-x86_64.tar.gz","--path","/home/ymp/instantclient_19_19","--ip","192.168.6.167","--memory","4G"] 2024-09-19 22:44:46 INFO --- [main] com.sics.command.serviceimpl.CheckServiceImpl : Check forenv before install is successfully! 2024-09-19 22:44:51 INFO --- [main] com.sics.command.serviceimpl.PackageServiceImpl : Db package unpackage successfully! 2024-09-19 22:44:51 INFO --- [main] com.sics.command.serviceimpl.CheckServiceImpl : OCI version is 19.19.0.0.0! 2024-09-19 22:44:56 INFO --- [main] com.sics.command.serviceimpl.PackageServiceImpl : Yasldr package unpackage successfully! 2024-09-19 22:44:56 INFO --- [main] com.sics.command.util.CommandUtil : host host0001 openssl version: OpenSSL 1.1.1l 24 Aug 2021 2024-09-19 22:44:56 INFO --- [main] com.sics.command.util.CommandUtil : OpenSSL version is 1.1.1 or greater 2024-09-19 22:44:56 INFO --- [main] com.sics.command.util.CommandUtil : host host0001 openssl version: OpenSSL 1.1.1l 24 Aug 2021 2024-09-19 22:44:56 INFO --- [main] com.sics.command.util.CommandUtil : OpenSSL version is 1.1.1 or greater 2024-09-19 22:44:56 INFO --- [main] com.sics.command.util.CommandUtil : hostid | group | node_type | node_name | listen_addr | replication_addr | data_path 2024-09-19 22:44:56 INFO --- [main] com.sics.command.util.CommandUtil : ---------------------------------------------------------------------------------------------------------------------------- 2024-09-19 22:44:56 INFO --- [main] com.sics.command.util.CommandUtil : host0001 | dbg1 | db | 1-1 | 0.0.0.0:8091 | 127.0.0.1:8092 | /home/ymp/yashan-migrate-platform/db/data/ymp 2024-09-19 22:44:56 INFO --- [main] com.sics.command.util.CommandUtil : ----------+-------+-----------+-----------+--------------+------------------+----------------------------------------------- 2024-09-19 22:44:56 INFO --- [main] com.sics.command.util.CommandUtil : 2024-09-19 22:44:56 INFO --- [main] com.sics.command.util.CommandUtil : Generate config success 2024-09-19 22:45:05 INFO --- [main] com.sics.command.util.CommandUtil : host host0001 openssl version: OpenSSL 1.1.1l 24 Aug 2021 2024-09-19 22:45:05 INFO --- [main] com.sics.command.util.CommandUtil : OpenSSL version is 1.1.1 or greater 2024-09-19 22:45:05 INFO --- [main] com.sics.command.util.CommandUtil : checking install profile.toml... 2024-09-19 22:45:05 INFO --- [main] com.sics.command.util.CommandUtil : install version: yashandb 23.2.3.100 2024-09-19 22:45:05 INFO --- [main] com.sics.command.util.CommandUtil : update host to yasom... type | uuid | name | hostid | index | status | return_code | progress | cost 2024-09-19 22:45:41 INFO --- [main] com.sics.command.util.CommandUtil : --------------------------------------------------------------------------------------------------------- 2024-09-19 22:45:41 INFO --- [main] com.sics.command.util.CommandUtil : task | 23c4a3c120ffbc68 | DeployYasdbCluster | - | ymp | SUCCESS | 0 | 100 | 33 2024-09-19 22:45:41 INFO --- [main] com.sics.command.util.CommandUtil : ------+------------------+--------------------+--------+-------+---------+-------------+----------+------ 2024-09-19 22:45:41 INFO --- [main] com.sics.command.util.CommandUtil : task completed, status: SUCCESS type | uuid | name | hostid | index | status | return_code | progress | cost 2024-09-19 22:45:45 INFO --- [main] com.sics.command.util.CommandUtil : ------------------------------------------------------------------------------------------------------- 2024-09-19 22:45:45 INFO --- [main] com.sics.command.util.CommandUtil : task | 3aae570c40510c80 | StopYasdbCluster | - | ymp | SUCCESS | 0 | 100 | 3 2024-09-19 22:45:45 INFO --- [main] com.sics.command.util.CommandUtil : ------+------------------+------------------+--------+-------+---------+-------------+----------+------ 2024-09-19 22:45:45 INFO --- [main] com.sics.command.util.CommandUtil : task completed, status: SUCCESS 2024-09-19 22:45:45 INFO --- [main] com.sics.command.util.CommandUtil : YashanDB Loader Personal Edition Release 23.2.3.100 x86_64 f3452be type | uuid | name | hostid | index | status | return_code | progress | cost 2024-09-19 22:45:51 INFO --- [main] com.sics.command.util.CommandUtil : -------------------------------------------------------------------------------------------------------- 2024-09-19 22:45:51 INFO --- [main] com.sics.command.util.CommandUtil : task | 47a4a6ef3b670c73 | StartYasdbCluster | - | ymp | SUCCESS | 0 | 100 | 4 2024-09-19 22:45:51 INFO --- [main] com.sics.command.util.CommandUtil : ------+------------------+-------------------+--------+-------+---------+-------------+----------+------ 2024-09-19 22:45:51 INFO --- [main] com.sics.command.util.CommandUtil : task completed, status: SUCCESS [Mem:, 7981, 2902, 969, 13, 4109, 4985] 2024-09-19 22:45:51 INFO --- [main] com.sics.command.util.CommandUtil : Sep 19, 2024 10:45:51 PM com.sics.migrate.port.common.jna.CallDts dtscInitLog 2024-09-19 22:45:51 INFO --- [main] com.sics.command.util.CommandUtil : INFO: ### call dtscInitLog! 2024-09-19 22:45:51 INFO --- [main] com.sics.command.util.CommandUtil : Sep 19, 2024 10:45:51 PM com.sics.migrate.port.common.jna.CallDts dtscInitLog 2024-09-19 22:45:51 INFO --- [main] com.sics.command.util.CommandUtil : INFO: ### finished dtscInitLog! 2024-09-19 22:45:51 INFO --- [main] com.sics.command.serviceimpl.CheckServiceImpl : Yasdts environment check successfully! 2024-09-19 22:45:52 INFO --- [main] com.sics.command.serviceimpl.PasswordServiceImpl : Update sys password and salt successfully! YMP started successfully!
查看运行状态
查看运行状态，检查是否安装成功：
1 2 3 4 5
[ymp@ymp ~]$ cd /home/ymp/yashan-migrate-platform/bin/ [ymp@ymp bin]$ ./ymp.sh status 2024-09-19 22:46:52 INFO --- [main] com.sics.command.YmpCommandMain : 指令入参：["--operation","status"] 2024-09-19 22:46:52 INFO --- [main] com.sics.command.serviceimpl.StatusServiceImpl : YMP is running, pid is 3349. 2024-09-19 22:46:52 INFO --- [main] com.sics.command.serviceimpl.StatusServiceImpl : Built-in database is used, pid is 3349.
