sqlplus connect oracle

find status and sid:

lsnrctl status
lsnrctl service

connect db

1
sqlplus apps/apps@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.5)(PORT=1521))(CONNECT_DATA=(SID=OAPROD)))"

运行本地命令

SQL> host dir

export prd

exp user/password tables=task, payment file=payment_task.dmp INDEXES=N CONSTRAINTS=N GRANTS=N ROWS=Y

bakcup uat

exp user/password tables=lic_app, company_cop , company , task, payment file=cop.dmp INDEXES=N CONSTRAINTS=N GRANTS=N ROWS=Y

import uat

imp user/password tables=case_legal_advice file=case_legal_advice.dmp IGNORE=Y
`imp user/ password full=y file=payment_task.dmp IGNORE=Y
``

# background job
`nohup java MyProg > /dev/null 2>&1 &`