服务器java项目转移到另一个盘_项目迁移到另一台服务器

数据库迁移

查询数据库中的表中记录数

select s.table_name,s.num_rows,s.blocks,s.avg_row_len,s.sample_size from all_all_tables s where s.owner='UAT_xxx' order by s.num_rows desc;

删除无用的表数据(效率高)

truncate table XXXXX;

更新all_all_tables中能查到的信息

select 'analyze table ' || A.TABLE_NAME || ' compute statistics;' from all_tables A where A.OWNER='UAT_xxx';

analyze table xxx compute statistics;

导出数据库

exp UAT_xxx/abc@orcl file=c:/20200331.dmp owner=UAT_xxx

创建用户，赋权限

create user UAT_xxx identified by abc;

grant create session,create table,unlimited tablespace to UAT_xxx;

导入数据库

imp UAT_xxx/abc file=/xxx/deploy/20200331.dmp full=y

导入后发现索引并未成功，手动用sql插入索引

select 'create sequence '||sequence_name||

' minvalue '||min_value||

' maxvalue '||max_value||

' start with '||last_number||

' increment by '||increment_by||

(case when cache_size=0 then ' nocache' else ' cache '||cache_size end) ||';'

from all_sequences where sequence_owner='UAT_xxx';

项目迁移

安装jdk

chmod +x /xxx/deploy/jdk-6u45-linux-x64.bin

./jdk-6u45-linux-x64.bin

vim /etc/profile

i

export JAVA_HOME=/xxx/deploy/jdk1.6.0_45

export PATH=$JAVA_HOME/bin:$PATH

export CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar

export JRE_HOME=$JAVA_HOME/jre

Esc

:wq

source /etc/profile

java -version

配置tomcat

配置Nginx

启动服务

查端口

netstat -tunpl |grep 端口号

查进程

ps -ef|grep 进程ID

查看进程所在的目录

ll /proc/进程ID/cwd

杀死进程

kill -9 进程ID

查看tomcat服务所用端口

ps -ef|grep tomcat

授权

chmod +x *.sh

启动服务

sh startup.sh

查看磁盘空间

df -h