Make TV as projecter with Google chromecast

With Google chromecast, we can remove HDMI, VGA cable to connect with any LCD TV has HDMI port.

– Requirement: LCD TV, Wireless Accesspoint.

1. Buy new google chromecast

2. Install Google Chrome browser on your PC, laptop.

3. Download & install Chromecast setup from https://cast.google.com/chromecast/setup

4. Configure Chromecast, very easy. Only open chromecast All Programs (Windows OS).

chromecast

After setup complete, Open Google chrome, we will see chromecast icon on right of addressbar.

Select Google cast and Choose Cast this tab to …

Select Cast entire screen (experimental).

chromecast2

Wow, Your desktop will send to TV. We can open any program such as Powerpoint, Slide, …

Restricted access SVN LDAP authorization.

Simple restricted access to SVN repository with LDAP authorization.

(On Ubuntu Server configure).

sudo /etc/apache2/mods-enabled/dav_svn.conf

Edit Repository which you want to restricted access with some users.

<Location /svn>
DAV svn
SVNParentPath /u02/svn
SVNListParentPath on
AuthType Basic
AuthName “SVN Server”
AuthBasicProvider ldap
AuthLDAPBindDN “cn=admin,dc=test,dc=mycompany,dc=com”
AuthLDAPBindPassword <admin password>
AuthLDAPURL “ldap://localhost/dc=test,dc=mycompany,dc=com?uid”
Require valid-user
</Location>

— Add Location for repository with users exist LDAP server.

<Location /svn/repo1>
Require ldap-user user1 user2 user3
</Location>

Restart Apache2 server

sudo service apache2 restart

 

Blankscreeen after enable OpenUI – siebel 8.1.11 innovation pack 2013.

We installed and running Siebel CRM 8.1.1.11 (Innovation Pack 2013) without OpenUI successfull.

But after enable OpenUI:

Siebel: 8.1.1.11 (Inovation Pack 2013 – Oct).
EnableOpenUI = True

After login only blank screen.
Debug tool in Firefox 25, IE10

[13:21:09.586] “[SetProtoAPIs] : Missing handler for type [ncm]”
[13:21:09.587] “[ContentLoader] Error -> SiebelAppFacade.PDQPresentationModel is not a constructor”

Resolved:
Download SRF files from eDelivery site:

Siebel Industry Applications Version 8.1.1.11 Siebel Repository Files

Download these files specific to your OS which your downloaded the jar files for 8.1.1.11 FP and extract the SRF files and replace the SRF for your language.

Copy this SRF in your server / OBJECTS / LANGUAGE folder by taking vanilla SRF as backup.

cp <SRF UNZIP DIRECTORY>/srf/8.2/patch/23030_srf/enu/siebel_sia.srf    $SIEBEL_HOME/ses/siebsrvr/objects/enu/siebel_sia.srf

And re-start server.

Install oracle siebel 8.1.1 on Linux x86_64

After install siebel 8.1.1, if cfgenv.sh missing.
The cfgenv.sh and cfgenv.csh files can be created as follows:
From SIEBEL_ROOT/gtwysrvr/install_script/install, run the following command:
$ ./CreateCfgEnvScript /SIEBEL_ROOT/gtwysrvr
From SIEBEL_ROOT/siebsrvr/install_script/install, run the following command:
$ ./CreateCfgEnvScript SIEBEL_ROOT/siebsrvr
From SIEBEL_ROOT/sweapp/install_script/install, run the following command:
$ ./CreateCfgEnvScript SIEBEL_ROOT/sweapp
Before configure gateway, please run command: 
$ export RESOLV_MULTI=off
Congfigure Gateway server:
$source cfgenv.sh
./config.sh -mode enterprise
Verify install success:
[oracle@server54 config]$ netstat -anp|grep 2320
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp        0      0 0.0.0.0:2320                0.0.0.0:*                   LISTEN      7669/siebsvc
[oracle@server54 config]$

Disable SSO Report Servers on iAS10g

1. Edit file rep_<server_name>_oracle_ias2.conf in directory: $ORACLE_HOME/reportsconf

Comment lines:
  <!– <security id=”rwSec”>
      <!property name=”securityUserid” value=”%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%” confidential=”yes” encrypted=”no”/>
      <property name=”oidEntity” value=”….”/>
   </security/–>
2. Restart Application Server
Set REPORT_PATH in $ORACLE_HOME/reports/conf/rep_<server_name>_oracle_ias2.conf
 <property name=”sourceDir” value=”/app/app10g/reports/samples/demo:<PATH>”/>

Install or Clone Oracle EBS R12.1.3 on Google Compute Cloud.

1. Create instance from Google cloud with CentOS kernel.

2. Install pre-requirement packages

From users, we can install packages use command sudo yum install <package_name> or switch to root user and install use command: $sudo su –

# yum install xterm xorg-x11-twm *xorg*font* tigervnc-server

#yum install firefox xhost xclock 

#yum install compat-db43 compat-db43-4.3.29-15.el6.i686

#yum install gcc gcc-c++ glibc-devel-2.12-1.107.el6_4.2.i686 

#yum install libstdc libstdc++-devel libstdc++-devel-4.4.7-3.el6.i686

#yum install libXp libXp-1.0.0-15.1.el6.i686

#yum install libaio libaio-0.3.107-10.el6.i686 make gdbm gdbm-1.8.0-36.el6.i686

#yum install sysstat util-linux-ng

#yum install compat-libstdc++-33 compat-libstdc++-296 compat-libcap1 

#yum install elfutils-libelf-devel libaio-devel

#yum install unixODBC unixODBC-2.2.14-12.el6_3.i686

#yum install unixODBC-devel unixODBC-devel-2.2.14-12.el6_3.i686

#yum install xorg-x11-utils ksh 

#yum install libICE-1.0.6-1.el6.i686 libSM-1.2.1-2.el6.i686 libXt-1.1.3-1.el6.i686

#yum install libXtst-1.2.1-2.el6.i686

Update to latest CentOS version with

#yum update

Remove unzip version 6.0 and replace with unzip v5.52

#yum remove unzip

#mkdir /install

#cd /install

#wget http://mirror.centos.org/centos/5/os/x86_64/CentOS/unzip-5.52-3.el5.x86_64.rpm

#rpm -ivh unzip-5.52-3.el5.x86_64.rpm

Download & install package from oracle requirement:

#wget https://oss.oracle.com/projects/compat-oracle/dist/files/Enterprise_Linux/openmotif21-2.1.30-11.EL6.i686.rpm

#wget https://oss.oracle.com/projects/compat-oracle/dist/files/Enterprise_Linux/xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm

#rpm -ivh openmotif21-2.1.30-11.EL6.i686.rpm xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm

Enable vncserver with xterm (please view in this post).

Reboot server

#reboot

3. Configure putty to connect vncserver over ssh

Default google compute cloud only open ssh port, vncserver is not encrypt data. To secure network, we will configure vncserver over ssh with putty tool.

3.1 Open putty

Enter public IP address to hostname (or IP address)

Enter port SSH (default is 22)

In Left windows, select Connection-> SSH -> X11

Check to Enable X11 forwarding

Enter localhost:0 to X display location.

In the left windows, click to Tunnels

In Add new forward port:

Enter Source port: 5901

Enter Destination: localhost:5901

Click to Session, Enter any name in Saved sessions, click to save button.

Open putty, connect to server.

Start vncviewer on your laptop or desktop, then connect to server vnc with:

localhost:1

Done.

3. Add swap for google cloud compute: Default google cloud compute instance does not enable swap. We will enable swap on.

$sudo dd if=/dev/zero of=/swapfile bs=1024 count=1024k

$sudo mkswap /swapfile

$sudo swapon /swapfile

$swapon -s

$sudo vi /etc/fstab

/swapfile               swap                    swap    defaults        0 0

Filename Type Size Used Priority
/swapfile file 1048572 0 -1

3. Edit hosts file, add more lines with same IP.

$sudo vi /etc/hosts

127.0.0.1 localhost
169.254.169.254 metadata.google.internal metadata
10.240.XXX.XX hostname.yourdomain #Line add
10.240.XXX.XX hostname default created by GG # Added by Google

4. Install Oracle database 11gR2 (11.2.0.3) or Clone database EBS R12 follow oracle guide.

New JVM JIT Feature in 11g May Cause ORA-29516 Error on Linux

Error:

ORA-29516: Aurora assertion failure: Assertion failure at joez.c:3311
Bulk load of method java/lang/Object.<init> failed; insufficient shm-object space

Cause:

You have set additional mount options on the shared memory device, /dev/shm, other than just the option named defaults.

Solution:

Examine the mount options in file /etc/fstab. If you see any addiitonal mount options after the word “defaults” for /dev/shm, such as nosuid, nodev, or noexec then this is likely the root cause.

For example:

none /dev/shm tmpfs defaults,nosuid,nodev,noexec 0 0

Remove these options from the entry in /etc/fstab:

none /dev/shm tmpfs defaults 0 0

Shut down the database instance, and reboot the system.  Restart the database instance.

Or

Disable the JIT compiler:

Alter system set JAVA_JIT_ENABLED=FALSE scope=both;

Fix error RC-00110 when clone ebs11i on windows

#############################################################
Started ApplyDBTier at Fri Jul 12 09:31:32 ICT 2013
Version:
ApplyDBTier.java     :      115.21
#############################################################
# Calling ApplyDBTechStack…
Executing runInstallDriver…
Started unzipping files…
#———————————————-
# $Header: CloneContext.java 115.203 2006/05/23 19:31:52 marderiu ship $
# Running CloneContext on machine – hrmstest
#———————————————-

Completed runInstallDriver.

Executing adgetreg.exe…
Completed adgetreg.exe – RDBMS
Executing adgenhnm.exe…

StackTrace:
java.lang.NullPointerException
at oracle.apps.ad.clone.ApplyDBTechStack.runADGenHnm(ApplyDBTechStack.java:900)
at oracle.apps.ad.clone.ApplyDBTechStack.<init>(ApplyDBTechStack.java:380)
at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:149)
at java.lang.reflect.Constructor.newInstance(Native Method)
at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:68)
at java.lang.Thread.run(Unknown Source)

——————————————————
Steps to fix this errors:
1. Go to %Oracle_home%\appsutil\bin
2. Run command: adgenhnm.exe %oracle_home% or path which point to %oracle_home%
3. Check errors occur and fix it.
Example:  PATH not found in SOFTWARE ORACLE ID18
4. Open regedit: Start -> Run -> regedit
5. Find HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE -> ALL_HOMES -> ID18
6. Add New Strings value in right windows with PATH and value point to %oracle_home% (EX: D:\dev8\dev8db\9.2.0)
7. Re run adcfgclone.pl dbTier with command
     D:\dev8\dev8db\9.2.0\appsutil\clone\bin\perl adcfgclone.pl dbTier

Fix database errors in Oracle VM Manager 3.2.1

Steps to fix database errors  in Oracle VM Manager 3.2.1

Step 1: Run fixup from ovm_upgrades.sh
1. Go to directory
     #cd /u01/app/oracle/ovm-manager-3/bin

2. Run follow command:

     #./ovm_upgrade.sh –fixup –dbuser=ovs –dbpass=Y3502K1rWO –dbhost=localhost –dbsid=ovm –dbport=1522
3. If errors show
Using existing transform XSL files
Copying deleted classes files to patch path location
2013-05-15 22:49:45,767  INFO Oracle OVM Manager Upgrade Processor
2013-05-15 22:49:45,768  INFO
2013-05-15 22:49:45,769  INFO Upgrade Initialization Starting
2013-05-15 22:49:46,088  INFO Oracle Distributed Object Fabric (ODOF): Copyright (C) 2007, 2012 Oracle.  All rights reserved.
2013-05-15 22:49:46,088  INFO ODOF Version: 1.0.0.0
2013-05-15 22:49:46,088  INFO Initializing…
2013-05-15 22:49:46,822  INFO Initialization Complete!
2013-05-15 22:49:46,822  INFO Upgrade Initialization Complete
2013-05-15 22:49:46,822  INFO Database Fixup starting
2013-05-15 22:49:47,004  INFO Fixing up Exchange… (10461 objects)
2013-05-15 22:49:50,758 ERROR ObjectNotFoundException: ONF reference to object 117:, from object 116:
2013-05-15 22:49:50,758 ERROR Fixup cannot fix Foundry stale reference in Event Log!

2013-05-15 22:49:50,758 ERROR Please run Foundry.recreateMembers() in a running Manager to fix this problem.
2013-05-15 22:49:50,915  INFO Committing fixup changed object 116:

2013-05-15 22:49:52,067  INFO Fixup has processed 1000 of 10461 objects
2013-05-15 22:49:53,648  INFO Fixup has processed 2000 of 10461 objects
2013-05-15 22:49:55,518  INFO Fixup has processed 3000 of 10461 objects
2013-05-15 22:49:56,798  INFO Fixup has processed 4000 of 10461 objects
2013-05-15 22:49:57,749  INFO Fixup has processed 5000 of 10461 objects
2013-05-15 22:49:59,205  INFO Fixup has processed 6000 of 10461 objects
2013-05-15 22:50:00,174  INFO Fixup has processed 7000 of 10461 objects
2013-05-15 22:50:01,007  INFO Fixup has processed 8000 of 10461 objects
2013-05-15 22:50:01,856  INFO Fixup has processed 9000 of 10461 objects
2013-05-15 22:50:02,474  INFO Fixup has processed 10000 of 10461 objects
2013-05-15 22:50:02,708  INFO Fixup Complete! 1 objects were updated
2013-05-15 22:50:02,708  INFO Database Fixup completed in 15.88 sec

Step 2. Fix database using ovm_upgrade.sh
1. Export database to XML
     # ./ovm_upgrade.sh –export –dbuser=ovs –dbpass=Y3502K1rWO –dbhost=localhost –dbsid=ovm –dbport=1522
2. Delete database
     # ./ovm_upgrade.sh –deletedb –dbuser=ovs –dbpass=Y3502K1rWO –dbhost=localhost –dbsid=ovm –dbport=1522
3. start OVM Manager with blank database.
#service ovmm start
4. Shutdown OVM Manager
#service ovmm stop
3. Import database
      #./ovm_upgrade.sh –import –dbuser=ovs –dbpass=Y3502K1rWO –dbhost=localhost –dbsid=ovm –dbport=1522
4. Restart OVM Server.
5. Enjoy.