Toad for oracle over ssh with putty Hint

Download & Install putty https://www.putty.org/   Putty Configuration Connection > SSH > Tunnels  Check [Local ports ....] Check [Remote ports ....] Source Port : 15219 Destination : yourdb.server.com:1521 Click [Add] Do not click Open button, You must save this configure...   Session : Input your Host, ssh Port, Saved Session name, and Click [Save]   […]

Read More

oracle : use dblink by command line

must be added tnsnames [DB Links] object not enough ~     # vi /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora   REMOTETNS1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.10)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = XE)))   # su - oracle -c "expdp dbuser/xxxxxx@REMOTETNS1 dumpfile=file.dmp logfile= file.log directory=BACKUP_DIR reuse_dumpfiles=y"    

Read More

centos 7 : oracle listener config & log Hint with /etc/hosts

# vi /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora ----------------------- LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))       (ADDRESS = (PROTOCOL = TCP)(HOST = owl)(PORT = 1521))     )   )   ADR_BASE_LISTENER = /home/oracle/app/oracle -----------------------   # vi /etc/hosts ----------------------- 127.0.0.1    owl -----------------------   […]

Read More