DATABASE/ORACLE
2011. 7. 22. 11:32
오라클 계정 로그인 필
su - o~
[/oracle/app/oracle/product/920/network/admin]$vi tnsnames.ora
수정
/* 오라클 tns 중지*/
[/oracle/app/oracle/product/920/network/admin]$lsnrctl stop
/* 오라클 tns 시작*/
[/oracle/app/oracle/product/920/network/admin]$lsnrctl start
/* 오라클 tns 구동여부 체크*/
[/oracle/app/oracle/product/920/network/admin]$ps -ef | grep lsnr*
oracle xxxx 1 0 11:11:54 pts/2 0:00 /oracle/app/oracle/product/920/bin/tnslsnr LISTENER -inherit
oracle xxxx xxx 0 11:12:02 pts/2 0:00 grep lsnr*
su - o~
[/oracle/app/oracle/product/920/network/admin]$vi tnsnames.ora
수정
/* 오라클 tns 중지*/
[/oracle/app/oracle/product/920/network/admin]$lsnrctl stop
/* 오라클 tns 시작*/
[/oracle/app/oracle/product/920/network/admin]$lsnrctl start
/* 오라클 tns 구동여부 체크*/
[/oracle/app/oracle/product/920/network/admin]$ps -ef | grep lsnr*
oracle xxxx 1 0 11:11:54 pts/2 0:00 /oracle/app/oracle/product/920/bin/tnslsnr LISTENER -inherit
oracle xxxx xxx 0 11:12:02 pts/2 0:00 grep lsnr*