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
Friday, September 9, 2011
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
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;
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.
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 ~]#
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 ~]#
Subscribe to:
Posts (Atom)