Friday, September 9, 2011

How to install JServer JAVA Virtual Machine

It allows to write Java stored procedures.

if JServer JAVA VM is not installed You will get error follwoing error
ERROR at line 1:
ORA-29538: Java not installed

Connect as sys user


SQL> @?/javavm/install/initjvm

SQL> select comp_name,status from dba_registry;

COMP_NAME STATUS
------------------------------------------------------------ -----------
Oracle Text VALID
Oracle XML Database VALID
Oracle Enterprise Manager VALID
Oracle Database Catalog Views VALID
Oracle Database Packages and Types VALID
JServer JAVA Virtual Machine VALID




Remove JVM:

SQL> @?/javavm/install/jvmrm.sql

How to install oracle text

SQL> @?/ctx/admin/catctx.sql oracle SYSAUX TEMP NOLOCK


sql> connect CTXSYS/oracle


SQL> @?/ctx/admin/defaults/dr0defin.sql "AMERICAN";

SQL> connect /as sysdba

SQL> alter user ctxsys account lock password expire;


SQL> select comp_name,version,status from dba_registry;

COMP_NAME VERSION STATUS
------------------------------------------------------------ ------------------------------ -----------
Oracle Text 10.2.0.5.0 VALID
Oracle XML Database 10.2.0.5.0 VALID
Oracle Enterprise Manager 10.2.0.5.0 VALID
Oracle Database Catalog Views 10.2.0.5.0 VALID
Oracle Database Packages and Types 10.2.0.5.0 VALID

SQL> select * from ctxsys.ctx_version;

VER_DICT VER_CODE
---------- ----------
10.2.0.5.0 10.2.0.5.0


SQL> select substr(ctxsys.dri_version,1,10) VER_CODE from dual;

VER_CODE
----------
10.2.0.5.0

SQL> select count(*) from dba_objects where owner='CTXSYS';

COUNT(*)
----------
339

SQL> select object_name, object_type, status from dba_objects where owner='CTXSYS' and status != 'VALID' order by object_name;

no rows selected

How to install XML DB

How to install XML DB

1. create tablespace for XDB

create tablespace xdb datafile '/u01/oradata/xdb.dbf' size 100m

2. Make sure sufficient Shared pool size

alter system set shared_pool_size = 180M scope=spfile;


3.Run script

@?/rdbms/admin/catqm password xdb temp

4. select comp_name,version,status from dba_registry;

5.Re install XML DB

@?/rdbms/admin/catnoqm
drop tablespace xdb including contents and datafiles;

TNS-12547: TNS:lost contact,Linux Error: 104: Connection reset by peer

Error:

TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 104: Connection reset by peer

Solution:

Make sure the loopback entry in /etc/hosts is not missing when you start the listener:
127.0.0.1 localhost.localdomain localhost
Now try to run lsnrctl start as oracle again.

Tuesday, September 6, 2011

Increase space on Linux thru VMware

How to increase space on VM Machine?

C:\Program Files\VMware\VMware Workstation>vmware-vdiskmanager.exe -x 20g "G:\Virtual Machines\TEST1\Red Hat Enterprise Linux 4.vmdk"


Below steps To increase disk size on Linux

[root@vm6 ~]# fdisk -l

Disk /dev/sda: 26.8 GB, 26843545600 bytes
255 heads, 63 sectors/track, 3263 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sda1 * 1 13 104391 83 Linux
/dev/sda2 14 2610 20860402+ 8e Linux LVM


Disk /dev/sdb: 536 MB, 536870912 bytes
64 heads, 32 sectors/track, 512 cylinders
Units = cylinders of 2048 * 512 = 1048576 bytes

Device Boot Start End Blocks Id System
/dev/sdb1 1 512 524272 83 Linux

Disk /dev/sdc: 536 MB, 536870912 bytes
64 heads, 32 sectors/track, 512 cylinders
Units = cylinders of 2048 * 512 = 1048576 bytes

Device Boot Start End Blocks Id System
/dev/sdc1 1 512 524272 83 Linux

Disk /dev/sdd: 2147 MB, 2147483648 bytes
255 heads, 63 sectors/track, 261 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sdd1 1 261 2096451 83 Linux


$fdisk /dev/sda -----create primary partiotion

[root@vm6 ~]# fdisk -l

Disk /dev/sda: 26.8 GB, 26843545600 bytes
255 heads, 63 sectors/track, 3263 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sda1 * 1 13 104391 83 Linux
/dev/sda2 14 2610 20860402+ 8e Linux LVM
/dev/sda3 2611 3263 5245222+ 83 Linux

Disk /dev/sdb: 536 MB, 536870912 bytes
64 heads, 32 sectors/track, 512 cylinders
Units = cylinders of 2048 * 512 = 1048576 bytes

Device Boot Start End Blocks Id System
/dev/sdb1 1 512 524272 83 Linux

Disk /dev/sdc: 536 MB, 536870912 bytes
64 heads, 32 sectors/track, 512 cylinders
Units = cylinders of 2048 * 512 = 1048576 bytes

Device Boot Start End Blocks Id System
/dev/sdc1 1 512 524272 83 Linux

Disk /dev/sdd: 2147 MB, 2147483648 bytes
255 heads, 63 sectors/track, 261 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sdd1 1 261 2096451 83 Linux


*******************************************



[root@test1 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
14G 9.8G 3.4G 75% /
/dev/sda1 99M 9.0M 85M 10% /boot
none 512M 98M 415M 20% /dev/shm
/dev/sdc1 380M 32M 329M 9% /backup
/dev/sdc3 304M 11M 279M 4% /tape
/dev/sdd1 5.0G 3.7G 1009M 79% /ora
shmfs 512M 98M 415M 20% /dev/shm
[root@test1 ~]# pvcreate /dev/sda3
Physical volume "/dev/sda3" successfully created
[root@test1 ~]# vgextend VolGroup00 /dev/sda3
Volume group "VolGroup00" successfully extended
[root@test1 ~]# lvextend -L+5G /dev/VolGroup00/LogVol00
Extending logical volume LogVol00 to 19.03 GB
Logical volume LogVol00 successfully resized
[root@test1 ~]# ext2online /dev/mapper/VolGroup00-LogVol00 ----->Linux 4

Note: # resize2fs /dev/mapper/VolGroup00-LogVol00 ----------->Linux 5

ext2online v1.1.18 - 2001/03/18 for EXT2FS 0.5b
[root@test1 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
19G 9.8G 8.1G 56% /
/dev/sda1 99M 9.0M 85M 10% /boot
none 512M 98M 415M 20% /dev/shm
/dev/sdc1 380M 32M 329M 9% /backup
/dev/sdc3 304M 11M 279M 4% /tape
/dev/sdd1 5.0G 3.7G 1009M 79% /ora
shmfs 512M 98M 415M 20% /dev/shm
[root@test1 ~]#