2022年11月21日月曜日

2022年11月17日木曜日

oracle lock 解除

$ sqlp / as sysdba

 SQL> alter system kill session '1345,21001';

                                                                 'sid, serial#'

2022年11月13日日曜日

tnsnames.ora

C:\ > sqlplus [username]/[passowrd]@[IP Addr]:[Port Number]/[Service Name]

tnsnames.ora利用の場合
C:\ > sqlplus [username]/[passowrd]@[net_service_name]

C:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora
net_service_name
(DESCRIPTION =  
      (ADDRESS_LIST = 
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.xx.xxx )(PORT = 1521))
     ) 
  (CONNECT_DATA = (SERVICE_NAME = service_name.world ) )
 )

net_service_name =
(DESCRIPTION =
(ADDRESS_LIST =
(FAILOVER = ON
(ADDRESS = (PROTOCOL = TCP)(HOST = server1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sevice_name.world)
)
)




シャットダウン時の後処理 (shutdown)

# vi /etc/systemd/system/drop.service [Unit] Description= stop httpgwd DefaultDependencies=no Before=shutdown.target RefuseManualStart=true ...