[PR]
Posted on Friday, Apr 25, 2025 01:24
[PR]上記の広告は3ヶ月以上新規記事投稿のないブログに表示されています。新しい記事を書く事で広告が消えます。
session確認スクリプト
Posted on Friday, Mar 28, 2008 17:32
alter session set nls_date_format='YYYY/MM/DD HH24:MI:SS';
set linesize 10000
set pagesize 10000
set trimspool on
set echo on
col USERNAME format a20
col OSUSER format a15
col MACHINE format a15
col PROGRAM format a30
col MODULE format a20
select SID , SERIAL# , USER# , USERNAME,
STATUS , OSUSER , MACHINE, PROGRAM,
MODULE , LOGON_TIME, STATE
from v$session
order by LOGON_TIME
/
DB起動・停止
Posted on Friday, Mar 28, 2008 17:05
--------------------------------------------------------------------------------------------
■OS
Linux XXXXXXXX 2.6.9-34.ELsmp #1 SMP Fri Feb 24 16:56:28 EST 2006 x86_64 x86_64 x86_64 GNU/Linux
--------------------------------------------------------------------------------------------
■ DB
oracle10g 10.1.0.X
--------------------------------------------------------------------------------------------
1. Clientからtelnet でDBサーバに接続( teraterm2.3 ) telnet port は23
2. sqplus 起動
#> sqlplus /NOLOG
3. sysdbaで接続
sqlplus> connect system/******* as sysdba
4. DB起動
sqlplus> startup [pfile=XXXXXXX.ora]
5. DB終了
sqlplus> shutdown [ normal | immediate | abort ]
--------------------------------------------------------------------------------------------