DBA COMMANDS

ACCESS REMOTE DATABASE VIA COMMAND LINE(From Oracle Client PC)

sqlplus system/PASSWORD@172.17.111.35:1521/mi18c

sqlplus “system/PASSWORD@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=172.17.111.35)(Port=1521))(CONNECT_DATA=(SID=mi18c)))”

Download files to Linux From Oracle site

Download files to Linux From Oracle site

Get the url link you want to download from oracle portal and use wget command on linux with your oracle credentials, once password prompts enter and file start download

wget –http-user=mithun@******.com –ask-password “https://updates.oracle.com/Orion/Services/download/p13390677_112040_Linux-x86-64_1of7.zip?aru=16716375&patch_file=p13390677_112040_Linux-x86-64_1of7.zip” -O file_name

IMPDP command

Command to create a new db user and dump

impdp system dumpfile=fullexpdp.dmp logfile=fullexpdpimp.log directory=DBBACKUP schemas=scott remap_schema=scott:tiger REMAP_TABLESPACE=scottts:tigerts transform=oid:n

use below for meta data or data only import

CONTENT=METADATA_ONLY
CONTENT=DATA_ONLY