oracle command for linux

*$TNS_ADMIN/listener.ora

1. LISTENER=(DESCRIPTION_LIST =
   
            (DESCRIPTION =
   
                (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.132.140.8)(PORT = 1521)(SERVICE_NAME=ORCL)))
   
            ))
   
   SID_LIST_LISTENER=
   
      (SID_LIST=
   
       (SID_DESC=
   
            (GLOBAL_DBNAME=ORCL.seochoen.komipo.net)
   
             (SID_NAME=ORCL)           
   
             (ORACLE_HOME=/oracle/9i)
   
           (PRESPAWN_MAX=20)
   
         (PRESPAWN_LIST=
   
              (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
   
            )
   
           )
   
          )

*db startup

1.TNS listener start/stop

./lsnrctl start

./lsnrctl stop

./lsnrctl stat

2.DB start/stop

sqlplus /nolog

conn /as sysdba

 

startup

shutdown

 

#Oracle processes

ps ax|grep ora

이 글은 스프링노트에서 작성되었습니다.