Monthly Archives: October 2017

ORA-12519: TNS:no appropriate service handler found

The number of database processes that can run in Oracle DB is set to 150 as default which can be viewed from v$resource_limit. select * from v$resource_limit where resource_name = ‘processes’; RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE ————- ——————- ————— —————— … Continue reading

Posted in ARTICLES, HOWTO, SQL, TIPS & T RICS | Tagged , , | Leave a comment

pexpect alternative in python for remote connection

We generally use python pexpect module to connect system remotely with ssh and execute our tasks. But sometimes pexpect module is not found to be installed in remote systems which create problems. And this problem can be solved with the … Continue reading

Posted in ARTICLES, OperatingSystem, Operations, Programming, SCRIPTING | Tagged , , | Leave a comment