TM lock script

Python으로 TM lock을 걸 수 있도록 Script 작성

▶ 스크립트

import cx_Oracle
import sys


print ("TM락")

ip = input("ip : ")
port = input("port : ")
sid = input("SID : ")
id = input("ID : ")
pw = input ("PW : ")

if ip == '':
	print("IP 미입력")
	
elif port == '':
	print("Port 미입력")
	
elif sid == '':
	print("SID 미입력")
	
else:
	#TM락
	dsn = cx_Oracle.makedsn(ip,port,sid)
	db = cx_Oracle.connect(id, pw, dsn)
	
	cursor = db.cursor()
	print("connect success")
	#현재 session SID
	cursor.execute('Select SID from v$mystat where rownum=1')
	print(cursor.fetchall())
	
	cursor.execute('lock table lock_table in exclusive mode;')
	print("session1 success")
	
	dsn1 = cx_Oracle.makedsn(ip,port,sid)
	db1 = cx_Oracle.connect(id, pw, dsn)
	cursor1 = db1.cursor()
	
	cursor1.execute('Select SID from v$mystat where rownum=1')
	print(cursor1.fetchall())
 
	cursor1.execute('insert into lock_table values (1);')