sqlplus host命令

host与!等效。

均在sqlplus环境下，执行os（linux）系统命令。

 

 

SQL> host ls level*
level0arclog_GHSJDB_36851_1_vjps1lah.bak  level0arclog_GHSJDB_36861_1_vtps348v.bak  level0_GHSJDB_36864_1_00ps349r.bak
level0arclog_GHSJDB_36852_1_vkps1lah.bak  level0arclog_GHSJDB_36866_1_02ps35bp.bak  level0_GHSJDB_36865_1_01ps349r.bak
level0arclog_GHSJDB_36853_1_vlps1lah.bak  level0_GHSJDB_36862_1_vups349q.bak        level_cont_spfile_c-1438298054-20150107-04
level0arclog_GHSJDB_36858_1_vqps1mnj.bak  level0_GHSJDB_36863_1_vvps349q.bak

SQL> ! ls level*
level0arclog_GHSJDB_36851_1_vjps1lah.bak  level0arclog_GHSJDB_36861_1_vtps348v.bak  level0_GHSJDB_36864_1_00ps349r.bak
level0arclog_GHSJDB_36852_1_vkps1lah.bak  level0arclog_GHSJDB_36866_1_02ps35bp.bak  level0_GHSJDB_36865_1_01ps349r.bak
level0arclog_GHSJDB_36853_1_vlps1lah.bak  level0_GHSJDB_36862_1_vups349q.bak        level_cont_spfile_c-1438298054-20150107-04
level0arclog_GHSJDB_36858_1_vqps1mnj.bak  level0_GHSJDB_36863_1_vvps349q.bak

 

SQL> host cat $ORACLE_HOME/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /home/u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

GHSJDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.170.100.2)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = GHSJDB)
    )
  )

 

本文乃原创文章，请勿转载。如须转载请详细标明转载出处