linux下ORACLE的操作

一.linux下启动oracle

首选启动数据库
su - oracle
sqlplus /nolog
conn /as sysdba
startup

然后启动监听:
进入/opt/oracle/product/9.2.0/bin/
lsnrctl start

二.linux下配置SID

进入$ORACLE_HOME/network/admin/,编辑tnsnames.ora

AITEST.LOCALDOMAIN =

  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 220.194.56.182)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = AITEST)
    )
  )

加入上面的内容