Linux下通过SSH对Oracle关闭和启动的过程:
su oracle
export ORACLE_HOME=/oracle/product/11202
export ORACLE_SID=gps
sqlplus oracle/oracle@gps
conn /as sysdba
shutdown immediate;
startup
以下是查看和修改参数。
==============================================
select count(*) from v$session;
Select count(*) from v$session where status='ACTIVE';
show parameter sessions;
show parameter processes;
alter system set processes=300 scope=spfile;
alter system set sessions=300 scope=spfile;
shutdown immediate;
startup;
sudo shutdown -r now