Increase the Size of Tablespace

If you want to increase the size of tablespace, its so simple. You can do this by enterprise manager console. Increase the size of datafile for particular tablespace.

OR

For Example

ALTER DATABASE
DATAFILE ‘/u03/oradata/ userdata02. dbf’
RESIZE 200M;

If you don’t have any free space on that partition of disk then you can add another datafile on the other partition  for particular tablespace.

For example

ALTER TABLESPACE app_data
ADD DATAFILE ‘/u01/oradata/ userdata03. dbf’
SIZE 200M;

Now you can insert data with in this tablespace.

Source: http://mhabib.wordpress.com/2007/03/31/increase-the-size-of-tablespace/

ORA-12162 TNS:net service name is incorrectly specified

"ORA-12162 TNS:net service name is incorrectly specified" misleads to verify the tnsnames.ora files for listener settings. But it's a issue with ORACLE_SID (environment variable) value.

Action: For windows: Add a environment value 'ORACLE_SID' and assign with your database name 

eg: set ORACLE_SID=orcl

For Linux: Run export ORACLE_SID=orcl or update the same in  ~/.bashrc file for permanent fix.

Note: You must also have ORACLE_HOME variable set to your Oracle database location.

Oracle Database Grant

conn sys/oracle as sysdba;

create user dummy identified by dummy;

grant ALL PRIVILEGES to dummy;

Source:http://ss64.com/ora/grant.html

Java Plugin Install for Linux

Linux Firefox configuration for Java plugin

1. cd to firefox folder (eg: cd /usr/lib/firefox-3.6)
2. create new folder called 'plugins' (eg: mkdir plugins, use sudo user if you don't have permissions)
3. cd plugins
4. create a symbolic link to java_home/jre/lib/i386/libnpjp2.so (eg: ln -s /usr/java/jdk1.6.0_26/jre/lib/i386 or amd64/libnpjp2.so
5. restart/start the firefox. ...thats it :-) 

Source: http://www.oracle.com/technetwork/java/javase/manual-plugin-install-linux-136395.html

USER_MEM_ARGS

export USER_MEM_ARGS="-Xms512m -Xmx1596m -XX:PermSize=512m -XX:MaxPermSize=1024m"

Adobe Installations in linux (redhat/fedora/oracle linux)

1. yum install flash-plugin - for adobe flash plugin
2. yum install AdobeReader_enu - for adobe reader
3. yum install RealPlayer - for Real Player

'service autofs start' is not working

It seems to be there is bug 193718 on autofs.
Resolution: update to latest version (autofs.i386 1:5.0.1-0.rc2.156.0.1.el5) using 'yum install autofs'