项目迁移到另一台服务器

 

 数据库迁移

查询数据库中的表中记录数
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