Once I had a requirement to copy some files from APP sever to DB server of same instance on regular intervals. We can achieve this… Read More »SSH-KEYGEN Password Less Entry Setup to connect from one server to another server without Password
To run a unix based shell script as a concurrent program, the executable of the concurrent program should be registered as a ‘Host’ program. The… Read More »What is Host Program? How to create Host Program? and What is .Prog file?
Trace file is not in a understandable format, but to make it easier to understand and readable Oracle has provided a utility TKPROF. Syntaxt to… Read More »What is TKPROF? How to run TKPROF?
Normally, when you connect oracle via SQL*Plus you can specify a connect string such sqlplus apps/apps@DEV. If this is specified, oracle uses tnsnames entry which… Read More »Use $TWO_TASK environment variable to connect to Oracle Database from Unix