Tuesday 24 February 2015

Unix: Change VNC password

Use below command:

vncpasswd 

Saturday 21 February 2015

LRM-00116: syntax error at ')' following

Cause of The Problem:
------------------------------------------------
double quotes ("), single quotes (') parentheses () are termed as special character on unix system. To know the list of special character on unix please have a look at Special Character on Unix. In order to use specual character on unix you have to use escape characters. How you can use escape character are discussed on How does one escape special characters.
If you don't use escape characters while using special character above error will arise.

Solution of The problem:
---------------------------------
Use escape character before using special character. Like in stead of using
expdp system/manager DUMPFILE=PWR19JAN.dmp  LOGFILE=expPWR19JAN.log DIRECTORY=DUMPS INCLUDE=TABLE:"in(SELECT t FROM tlist)"

Use,
expdp system/manager DUMPFILE=PWR19JAN.dmp  LOGFILE=expPWR19JAN.log DIRECTORY=DUMPS INCLUDE=TABLE:\"in\(SELECT t FROM tlist\)\"

AIX chfs change filesystem size

chfs -a size=3G /home
chfs -a size=3000M /home
chfs -a size=+1G /home
chfs -a size=+500M /home

Tuesday 17 February 2015

Oracle: Grant view without execute permission on package source

1-  grant debug any procedure to scott; -- The user will be able to see all objects in all schemas

2- grant select on dba_source; 

Number of Visitors