Thalai Muthu Oracle Apps DBA: September 2010

30 September 2010

Step by Step Oracle Database 11.2.0 installation on linux OEL5.5 64bit

kernel version :-
ernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6853600
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=4194304
net.core.wmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_max=1048576

Operating System Pakage:-
glibc-2.3.4-2.41
glibc-common-2.3.4-2.41

create oracle user and DBA group
#groupadd dba
#useradd oracle -g dba
$cd /oracleldatabase
$./runinstaller

java.io.IOException: ORA-01691: unable to extend lob segment

Start uploading...
Target file: FAS444_XML.rtf
Creating a new record in XDO_LOBS: FAS444_XML.rtf
java.io.IOException: ORA-01691: unable to extend lob segment XDO.SYS_LOB0000332070C00010$$ by 16 in tablespace APPS_TS_TX_DATA

        at oracle.jdbc.driver.DatabaseError.SQLToIOException(DatabaseError.java:517)
        at oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(OracleBlobOutputStream.java:214)
        at oracle.jdbc.driver.OracleBlobOutputStream.write(OracleBlobOutputStream.java:144)
        at java.io.BufferedOutputStream.write(BufferedOutputStream.java:105)
        at oracle.apps.xdo.oa.schema.server.LobHelper.updateLob(LobHelper.java:133)
        at oracle.apps.xdo.oa.schema.server.LobHelper.updateLob(LobHelper.java:291)
        at oracle.apps.xdo.oa.schema.server.LobHelper.createLob(LobHelper.java:778)
        at oracle.apps.xdo.oa.schema.server.LobHelper.createLob(LobHelper.java:730)
        at oracle.apps.xdo.oa.util.XDOLoader.processUpload(XDOLoader.java:1163)
        at oracle.apps.xdo.oa.util.XDOLoader.process(XDOLoader.java:1003)
        at oracle.apps.xdo.oa.util.XDOLoader.main(XDOLoader.java:2251)

AD Worker error:
The above program failed. See the error messages listed
above, if any, or see the log and output files for the program.

Time when worker failed: Thu Sep 30 2010 20:10:10

Manager says to quit.

Time when worker quit: Thu Sep 30 2010 20:13:12

Connecting to APPS......Connected successfully.

AD Worker is complete.

solution :-

conn as system user

SQL>alter database datafile '/oracle/PROD/db/apps_st/data/a_txn_data01.dbf' resize 4000M

Howto : Install Canon LBP2900 printer on Linux

Howto : Install Canon LBP2900 printer on Linux
Features

    * 12 ppm mono printing
    * Zero warm-up time from sleep mode
    * First Print Out Time in only 9.3 seconds
    * Up to 2400 x 600dpi print resolution
    * Energy efficient and quiet operation
    * Easy to use All-in-One cartridg

This tutorial will show you how to install Canon LPB2900 on Linux, tested also on Canon LBP3100 and is working, and should work on all

the Canon laser printers LBP XXXX Series.

Before to begin we have to see if all the necessary dependencies are installed, if not we have to install them, check the ones below if already

are installed :

1/6: printer-testpages

2/6: dynamic
3/6: libopenslp1
4/6: cups-common
5/6: portreserve
6/6: cups

If all is installed then we go with the installation :

1- Download the driver from here, or from :

http://downloads.unixmen.com/drivers/CANONLBP2900/CAPTDRV180.tar.gz

2- change to root :

su - (root)

3- change to the folder where you download the driver and extract it, in my case :

cd /home/zinovsky/Desktop

tar -xvf Driver.tar.gz change Driver with the name and version of your driver in my case i downloaded CAPTDRV180.tar.gz

output :

[root@localhost Desktop]# tar xvf CAPTDRV180.tar.gz

CANON_UK/
CANON_UK/Src/
CANON_UK/Driver/
CANON_UK/Doc/
CANON_UK/Src/cndrvcups-capt-1.80-1.tar.gz
CANON_UK/Src/cndrvcups-common-1.80-1.tar.gz
CANON_UK/Driver/RPM/
CANON_UK/Driver/Debian/
CANON_UK/Driver/RPM/cndrvcups-common-1.80-1.i386.rpm
CANON_UK/Driver/RPM/cndrvcups-capt-1.80-1.i386.rpm
CANON_UK/Driver/Debian/cndrvcups-common_1.80-1_i386.deb
CANON_UK/Driver/Debian/cndrvcups-capt_1.80-1_i386.deb
CANON_UK/Doc/README-capt-1.8xE.txt
CANON_UK/Doc/LICENSE-captdrv-1.80E.txt
CANON_UK/Doc/README-capt-1.8xE.pdf
CANON_UK/Doc/guide-capt-1.8xE.tar.gz

so now if we want to install in debian ( ubuntu for exmple) we have to choose :

CANON_UK/Driver/Debian/cndrvcups-common_1.80-1_i386.deb
CANON_UK/Driver/Debian/cndrvcups-capt_1.80-1_i386.deb

if We have to install the driver on red-hat based distribution like in my case will choose

CANON_UK/Driver/RPM/cndrvcups-common-1.80-1.i386.rpm
CANON_UK/Driver/RPM/cndrvcups-capt-1.80-1.i386.rpm

like this :

[root@localhost Desktop]# cd CANON_UK/

[root@localhost CANON_UK]# ls
Doc/ Driver/ Src/
[root@localhost CANON_UK]# cd Driver/
[root@localhost Driver]# ls
Debian/ RPM/

in my case i will install in red-hat based distribution so is a RPM package ( fedora,Mandriva, Linpus )

[root@localhost Driver]# cd RPM/

[root@localhost RPM]# rpm -ivh cndrvcups-common-1.80-1.i386.rpm

Preparing... ########################################### [100%]
1:cndrvcups-common ########################################### [100%]
[root@localhost RPM]# rpm -ivh cndrvcups-capt-1.80-1.i386.rpm
Preparing... ########################################### [100%]
1:cndrvcups-capt ########################################### [100%]

Driver is installed .

4- Now we have to restart CUPS :

/etc/init.d/cups restart

5-Now type tail /var/log/messages

[root@localhost ~]# tail /var/log/messages

Jan 24 18:37:51 localhost perl: [RPM] cups-1.3.9-0.2mdv2009.0 installed
Jan 24 18:40:25 localhost kernel: usb 1-1: new high speed USB device using ehci_hcd and address 6
Jan 24 18:40:25 localhost kernel: usb 1-1: configuration #1 chosen from 1 choice
Jan 24 18:40:25 localhost kernel: usb 1-1: New USB device found, idVendor=04a9, idProduct=2676
Jan 24 18:40:25 localhost kernel: usb 1-1: New USB device strings: Mfr=1, Product=2, SerialNumber=3
Jan 24 18:40:25 localhost kernel: usb 1-1: Product: Canon CAPT USB Device
Jan 24 18:40:25 localhost kernel: usb 1-1: Manufacturer: Canon
Jan 24 18:40:25 localhost kernel: usb 1-1: SerialNumber: 0000A376H8Jd
Jan 24 18:40:25 localhost kernel: usblp0: USB Bidirectional printer dev 6 if 0 alt 0 proto 2 vid 0x04A9 pid 0x2676
Jan 24 18:40:25 localhost kernel: usbcore: registered new interface driver usblp

6- Now type :

/usr/sbin/lpadmin -p LBP2900 -m CNCUPSLBP2900CAPTK.ppd -v ccp:/var/ccpd/fifo0 -E

N.B : If you are trying to install another LBP printer other than LBP2900 then use the command bellow and choose the CNCUPSLBPxxxxCAPTK.ppd

that correspond to your printer model and replace it in the the command above.

ls /usr/share/cups/model/ |grep CNCUPS

7-and then

/usr/sbin/ccpdadmin -p LBP2900 -o /dev/usb/lp0

N.B : If you are trying to install another LBP printer other than LBP2900 then change LBP2900 in the command above with your LBPxxxx printer

output :

CUPS_ConfigPath = /etc/cups/

LOG Path = None

UI Port = 59787

Entry Num : Spooler : Backend : FIFO path : Device Path : Status

----------------------------------------------------------------------------

[0] : LBP2900 : ccp : /var/ccpd/fifo0 : /dev/usb/lp0 : New!!

8- /etc/initd/ccpd start :

/etc/init.d/ccpd start

9- Now Set ccpd to start when you startup your computer:

For debian use :

sudo update-rc.d ccpd defaults 20

for other distributions i prefer this methode :

gedit /etc/rc.local

and add at the end :

/etc/init.d/ccpd start

save and close

10- Printer is ready to print :)

24 September 2010

ons-connect] Passive connection 127.0.0.1,6101 missing connect

Summary

After starting up Oracle SOA Suite 10g, the following two behaviors are experienced:

An incredibly large amount of TIME_WAITs on port 6100.

Endless loops of the following error in opmn.log:

08/06/25 12:24:38 [ons-connect] Passive connection 127.0.0.1,6101 missing connect
08/06/25 12:24:38 [ons-connect] Passive connection 127.0.0.1,6101 missing connect

In other cases, you may get Local connection 0,127.0.0.1,6100 missing form factor.

This usually happens when Oracle Database 10g is installed on the same physical server as Oracle SOA Suite 10g.

Details

On the Oracle Database 10g ORACLE_HOME, edit the file $ORACLE_HOME/opmn/conf/ons.conf:
Current values:

localport=6100
remoteport=6200
loglevel=3

Change them to these values (make sure these ports aren't taken):

localport=7100
remoteport=7200
loglevel=3

These ports are conflicting with the values found in the SOA Suite opmn.xml file. These values default to:
<port local="6100" remote="6200" request="6003">

Restart the database listener:

lsnrctl stop
lsnrctl start

Applicable Versions

Oracle SOA Suite 10g (10.1.3.3)
Oracle Database 10g (10.2.0.2)

Step by Step Installation on Oracle Database10g Linux 32bit Server

First enter the kernel parameter

#vi /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6553600
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=4194304
net.core.wmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_max=262144
#cd /oracle/10g
$./runinstaller

Select Advanced Installation click next

Select your inventory location and Group

Select Enterprise edition

Provide Oracle_Home and Oracle Home Directory

Select Create database

Provide Service name then change the Character set

Provide Oradata location

Provide user password

Run below script on root user .

Step by Step Installation SOA suite 101310 on linux

First Install the Oracle Database 10.2.0.4

If you have 10.2.0.1 please upgrade the Database version .

Download soa_linux_x86_101310_disk1.cpio
#cpio -idmv < soa_linux_x86_101310_disk1.cpio
#cd /oracle/SOA
export ORACLE_HOME
#sh /oracle/SOA/install/soa_schemas/irca/./irca.sh
Enter the username and password for same.

#./runInstaller

Select Advanced installation ans place the Installation Directory

After installation start the services
#cd /oracle/OBIEE/OracleAS_1/opmn/bin/
$opmnctl startall
$opmnctl status