Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Multi Threaded Server(MTS)


sys>show parameter spfile;
sys>create pfile from spfile;
sys>shut immediate
sys>exit
oracle@venu1 dbs>ls
oralce@venu1 dbs>mv spfilevenu1.ora spfilevenu1.ora.bkp
oracle@venu1 dbs>vi initvenu1.ora
DISPATCHERS="(PROTOCOL=TCP)(DISP=2)"
MAX_DISPATCHERS=5
SHARED_SERVERS=2
MAX_SHARED_SERVERS=5
LOCAL_LISTENER="(ADDRESS=(PROTOCOL=TCP)(HOST=VENU1)(PORT=1521))"
:wq!
oracle@venu1>export ORACLE_SID=venu1
oracle@venu1>sqlplus / as sysdba
sys>startup
oracle@venu1>ps -ef|grep smon
oracle@venu1>ps -ef|grep ora
Related Posts Plugin for WordPress, Blogger...

Flag Counter