Common Linux Oracle commands

# Login <br/> # login development machine <br/> # login <br/> SSH oa@192.168.1.9 <br/> # Database Export <br/> export nls_lang = american_america.zhs16gbk <br/> export F1 = 'date + % Y % m % d % H % M '. DMP <br/> expdp/'sys/pwd @ orcl as sysdba/'directory = data_pump_dir dumpfile = $ F1 schemas = hs_aws_sa3 reuse_dumpfiles = true <br/> # copy to dump to HS- DB <br/> SCP/home/OA/Oracle/admin/orcl/dpdump/$ F1 oa@192.168.1.13: /home/Oracle/admin/hsoa/dpdump/imp. DMP <br/> # log out of the development machine Ctrl + D <br/> # ----------------------------------------- <br/> # log on to the HS-Web <br/> # login <br/> SSH oa@192.168.1.14 <br/> br/> # Back up plugs <br/> tar-czvf/home/backup/plugs _ 'date + % Y % m % d % H % M '. tgz/home/hs_aws_system/bin/plugs/<br/> # copy the plugs Java package to HS-Web <br/> SCP-r oa@192.168.1.9: /home/OA/hs_aws_system/bin/plugs/home/hs_aws_system/bin/plugs <br/> # backup form <br/> tar-czvf/home/backup/eform_html 'date + % Y % m % d % H % M' _ Bak. tgz/home/hs_aws_system/template/eform/html <br/> # copy the form to HS-Web <br/> SCP-r oa@192.168.1.9: /home/OA/hs_aws_system/template/eform/html/home/hs_aws_system/template/eform/html <br/> # logout HS-web Ctrl + D <br/> # logout #------------------------------------------------- <br/> # log on to HS-DB <br/> # login <br/> SSH oa@192.168.1.13 <br/> # backup <br/> export nls_lang = american_america.zhs16gbk <br/> Export f2 = exp _ 'date + % Y % m % d % H % M '. bak <br/> expdp/'sys/pwd @ hsoa as sysdba/'directory = data_pump_dir dumpfile = $ F2 schemas = hs_aws_sa reuse_dumpfiles = true <br/> mV/home/Oracle/ admin/hsoa/dpdump/$ F2/home/Oracle/backup/<br/> # sqlplus log on to the database <br/> sqlplus sys/pwd @ hsoa as sysdba <br/> # delete tablespace <br/> drop tablespace hs_aws_ts including contents and datafiles; <br/> # create a tablespace <br/> Create smallfile tablespace "hs_aws_ts" datafile '/home/Oracle/oradata/hsoa/hs_aws_ts.dbf' size 100 m reuse autoextend on next 1024 K maxsize 32767 M logging extent management local segment space management auto; <br/> # import <br/> export nls_lang = american_america.zhs16gbk <br/> impdp/'sys/pwd @ hsoa as sysdba/'Directory = data_pump_dir dumpfile = imp. DMP schemas = hs_aws_sa3 remap_schema = hs_aws_sa3: hs_aws_sa <br/> 

 

Dbca command: Manage Oracle instances.

Delete an oracle instance. by deleting the corresponding installation directory, you should also delete the/etc/oratab file. Each installation instance will be recorded in this file.