Tuesday, May 14, 2013

Download and install VMware Player (Non-Commercial Software)

Ubuntu 12.10

Download and install Ubuntu 12.10 32 bit or 64 bit based on your Hardware.

XClock Problem

To setup $DISPLAY across the user try running this as root before you do "su - oracle" or other users.

$>xhost local:oracle

$>xhost local:sirishg

Oracle Installation Process

Follow the below link,

http://install-climber.blogspot.com/2012/10/InstallOracle11gR2DatabaseLinuxUbuntu1210Quantal64bit.html

Note:

About link works for Ubuntu 32 Bit as well.

Note: Just ignored all above missing packages.

Note: Run the above commands as root user.

Post Installation Errors

Error Message while starting sqlplus

sqlplus: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory.

Reason for the Problem

libclntsh.so.11.1 was missing.

Solution

Below solution solve this problem as well.

Error message while starting Net Manager

oracle@ubuntu:~/app/oracle/product/11.2.0/dbhome_1/bin$ ./netca

UnsatisfiedLinkError exception loading native library: njni11

java.lang.UnsatisfiedLinkError: /home/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libnjni11.so: libclntsh.so.11.1: cannot open shared object file: No such file or directory

java.lang.UnsatisfiedLinkError: jniGetOracleHome

at oracle.net.common.NetGetEnv.jniGetOracleHome(Native Method)

at oracle.net.common.NetGetEnv.getOracleHome(Unknown Source)

at oracle.net.ca.NetCALogger.getOracleHome(NetCALogger.java:230)

at oracle.net.ca.NetCALogger.initOracleParameters(NetCALogger.java:215)

at oracle.net.ca.NetCALogger.initLogger(NetCALogger.java:130)

at oracle.net.ca.NetCA.main(NetCA.java:404)

Error: jniGetOracleHome

Oracle Net Services configuration failed. The exit code is 1

Reason for the Problem

libclntsh.so.11.1 was missing.

Solution

Go to terminal and locate the missing file libclntsh.so.11.1 using below command,

Copy the above file to $ORACLE_HOME\lib (/home/oracle/app/oracle/product/11.2.0/dbhome_1/lib/)

Post Installation Configurations

Database Listener Configuration

If we need to configure database listener go to $ORACLE_HOME/lib and execute shell called netca

Create new Database

Exception while creating new Database

References

http://install-climber.blogspot.com/2012/10/GettingStartedInstallOracle11gR2DatabaseFedora17Lxde.html

http://thripal.blogspot.com/2011/07/oracle-11g-r2-on-ubuntu-1104.html

https://forums.oracle.com/forums/thread.jspa?messageID=9596361

This is Important One

http://www.makina-corpus.org/blog/howto-install-oracle-11g-ubuntu-linux-1204-precise-pangolin-64bits

Solving compilation/link errors

Some issues should appear during installation.
If you have not created the symbolic links above, you will have to solve error lib//libagtsh.so: undefined reference to `nnfyboot' in make: rdbms/lib/dg4odbc] Error 1. For this, create the symbolic links and execute the commands:

export ORACLE_HOME=/opt/oracle/Oracle11gee/product/11.2.0/dbhome_1

cd $ORACLE_HOME/lib

ln -s libclient11.a libagtsh.a

$ORACLE_HOME/bin/genagtsh $ORACLE_HOME/lib/libagtsh.so 1.0

Now we will encounter many errors due to indirect library linking:
To solve error # libnnz11.so: could not read symbols: Invalid operation /sysman/lib/ins_emagent.mk, enter the command:

export ORACLE_HOME=/opt/oracle/Oracle11gee/product/11.2.0/dbhome_1

sed -i 's/^\(\s*\$(MK_EMAGENT_NMECTL)\)\s*$/\1 -lnnz11/g' $ORACLE_HOME/sysman/lib/ins_emagent.mk

To solve error # nsglsn.c:(.text+0xc29): undefined reference to `ons_subscriber_close' /network/lib/ins_net_server.mk, enter the command:

sed -i 's/^\(TNSLSNR_LINKLINE.*\$(TNSLSNR_OFILES)\) \(\$(LINKTTLIBS)\)/\1 -Wl,--no-as-needed \2/g' $ORACLE_HOME/network/lib/env_network.mk

To solve error # libocrutl11.so: undefined reference to `lfifcp' rdbms/lib/ins_rdbms.mk, enter the commands:

sed -i 's/^\(ORACLE_LINKLINE.*\$(ORACLE_LINKER)\) \(\$(PL_FLAGS)\)/\1 -Wl,--no-as-needed \2/g' $ORACLE_HOME/rdbms/lib/env_rdbms.mk

You also need to execute the following commands to prevent from later errors:

sed -i 's/^\(\$LD \$LD_RUNTIME\) \(\$LD_OPT\)/\1 -Wl,--no-as-needed \2/g' $ORACLE_HOME/bin/genorasdksh

sed -i 's/^\(\s*\)\(\$(OCRLIBS_DEFAULT)\)/\1 -Wl,--no-as-needed \2/g' $ORACLE_HOME/srvm/lib/ins_srvm.mk

Starting up the database

Once your server have been restarted, your database may not start. To solve this issue, first check in /etc/oratab that it has the 'Y' flag, if not, set it.

sudo gedit /etc/oratab

And replace N by Y

orcl:/opt/oracle/Oracle11gee/product/11.2.0/dbhome_1:Y

Manually starting up the database

Finally, to manually start Oracle, run these commands as oracle user

dbstart $ORACLE_HOME

Manually shutting down the database

dbshut $ORACLE_HOME

Monday, April 29, 2013

Best tools

archive.aweber.com/tmnmailinglist/7SOlU/h/5_Apps_To_Help_You.htm

Tuesday, March 19, 2013

Read and Write Primary Document in IBM B2B Sterling Integrator using MESA

Read

and Write Primary Document while implementing

Custom Service in

IBM B2B Sterling Integrator

using MESA Studio

public WorkFlowContext processData(WorkFlowContext wfc)
            throws WorkFlowException {
        Document outputDocument;
        String codeListOutputXML = null;
        OutputStream outputStream;
        BufferedOutputStream bos;
        String svcName = wfc.getServiceName();
        XLogger log = new XLogger("SI_Auto_DeployImpl", svcName);
        wfc.harnessRegister();
        wfc.setBasicStatus(WorkFlowContext.SUCCESS);
        try {
            CodeListDeployer codeListDeployer = new CodeListDeployer();
            // Read the input from PrimaryDocument
            Document srcDoc = wfc.getPrimaryDocument();
            codeListOutputXML = codeListDeployer.readCodeListExcel(srcDoc.getInputStream());
            //Write output to new PrimaryDocument
            outputDocument = wfc.newDocument();
            outputStream = outputDocument.getOutputStream();
            bos = new BufferedOutputStream(outputStream);
            bos.write(codeListOutputXML.getBytes());
            wfc.setAdvancedStatus("CodeList Created Successfully!!");
            bos.close();
             wfc.putPrimaryDocument(outputDocument);
        } catch (Exception e) {
            handleError(log, wfc, SI_Auto_DeployMessages.Global_Exception,
                    new Object[] { SI_Auto_DeployImpl.class.getName() }, e);
        } finally {
            wfc.unregisterThread();
        }
        return wfc;
    }

Sunday, March 17, 2013

Oracle Documentation Links

Few good oracle documentation links we can learn pretty much oracle by self,

Oracle® Server Concepts
http://docs.oracle.com/cd/E11882_01/server.112/e25789/toc.htm

Oracle® 2-Day Developers Guide
http://docs.oracle.com/cd/E11882_01/appdev.112/e10766/toc.htm

Oracle® Database 2 Day DBA
http://docs.oracle.com/cd/E11882_01/server.112/e10897/toc.htm

Oracle® Database 2 Day + Performance Tuning Guide

http://docs.oracle.com/cd/E11882_01/server.112/e10822/toc.htm

Friday, March 15, 2013

File Compress Service in IBM B2B Sterling Integrator


<operation name="Compress"> 

 <participant name="CompressionService"/>

 <output message="outputMessage">

 <assign to="." from="*"/>

 <assign to="compression_action">Compress</assign>

 <assign to="compressed_filename" from="concat('FileName__','.gz')"/>

 <assign to="compression_level">1</assign> <!-- 1 Cost Less CPU cycles -->

 <assign to="file_name">string(OriginalFileName)</assign>

 <assign to="doc_to_compress">primary_doc</assign>

</output>

 <input message="inputMessage">

 <assign to="." from="*"/>

</input>

 </operation>

Thursday, March 14, 2013

How to Launch Your Business While Working Full Time – QA with Tai Goodwin

http://succeedasyourownboss.com/06/2011/how-to-launch-your-business-while-working-full-time-qa-with-tai-goodwin/

http://launchwhileworking.com/

Tuesday, March 5, 2013

Marketing concepts Explained...

Saturday, March 2, 2013

40 Useful Websites

www.marcandangel.com/2010/05/24/top-40-useful-sites-to-learn-new-skills

Thursday, February 28, 2013

IBM B2B Sterling Integrator (SI) and Sterling File Gateway Installation Procedure

1. Install and Configure Sterling Integrator DB. Follow the below link to create and configure database,
         http://sirishg.blogspot.com/2012/12/sterling-integrator-oracle-user-and.html

2. Update License Set.
   Need to update the License Set because while installing SI it will take the out of box license file which needs to be overriden after post installation. Below command will update the Sterling Integrator license,
         InstallDirectory/bin$ AddLicenseSet.sh

3. Start SI and go to Operations --> System --> Licenses and do List All and check all carefully that we have got license for all
   required SI components for instance File Gateway Core
   Note: Check under InstallDirectory/properties/licensefiles for SI and SFG License.

4. Shutdown Sterling Integrator and proceed for Sterling File Gateway Installation
   InstallDirectory/bin$ InstallService.sh
   Note: We will find SFG under InstallDirectory/packages/filegateway_XXX.jar

5. After installation start SI we will be automatically pointed to filegateway URL.

Note: Only important factor here is before we trigger SFG installation we need to make sure we have valid licese for SFG, Otherwise your installation will be semi completed.

Telugu Devotional Song

Wednesday, February 27, 2013

Uninstall IBM Sterling File Gateway (SFG) from IBM B2B Sterling Integrator (SI) Installation

Below process explains how to remove IBM Sterling File Gateway (SFG) from IBM B2B Sterling Integrator(SI) Installations. Please do not consider this as an official procedure, This is a just a WORK AROUND to remove SFG from SI.

1. Shutdown all Sterling Integrator nodes and perform below tasks on all nodes.

2. Go to installFolder/container/Applications - Remove filegateway exploded folder and filegateway.war.

3. Go to installFolder/noapp/deploy - Remove filegateway exploded folder and filegateway.war.

4. Go to installFolder/jar/ - Remove filegateway folder.

5. Go to installFolder/properties/dynamicclasspath.cfg.in - Remove entries for FileGateway-ui.jar and filegateway.jar.

6. Run setupfiles.cmd/sh

7. Run deployer.cmd/sh

8. Bring up Sterling Integrator.

Note: Please note that above process will not clean database and it will leave few database tables related to SFG but they don't harm any of the SI processes.

Monday, February 25, 2013

12 Rules of Success

addicted2success.com/success-advice/apples-ceo-steve-jobs-shares-his-12-rules-of-success

Saturday, February 23, 2013

Oracle 11g R2 32 bit Installation on Ubuntu 12.10 32 Bit

Finally oracle up and running on on my Ubuntu 12.10

VM. Followed the below posts,

http://www.makina-corpus.org/blog/howto-install-oracle-11g-ubuntu-linux-1204-precise-pangolin-64bits

http://install-climber.blogspot.com/2012/10/GettingStartedInstallOracle11gR2DatabaseFedora17Lxde.html

Wednesday, February 20, 2013

Excellent article on Ubuntu 12.10 tips and tricks

http://www.techsupportalert.com/content/tips-and-tricks-ubuntu-after-installation-ubuntu-1204.htm

Install MESA Developer Studio on IBM B2B Sterling Integrator

To install MESA Developer Studio

on Eclipse (Europa) follow the below steps, Below screen shot shows the eclipse version details,

1. Open Eclipse.

2. Select a default workspace folder location. You can add additional workspace folder locations at anytime. The Package View in the lower left area of the MESA Developer Studio workspace displays a local explorer view of your project folders. This enables you to store files that you check out.

3. From the Eclipse Help menu,

Navigate to Software Updates > Find and install.

4. Select Search for new features to install.

5. Click Next.

Now need to add new Remote Site so click on New Remote Site.

7. Complete the following information and click OK.

Name –
Type a descriptive name for the application server.
URL –
Type the IP address or name of your server. Format is

http://<servername>:<WebDAVportnumber>/eclipse.

http://HOST:17046/eclipse

Note: In this case my base port was 17000.

Note: The WebDAVportnumber can be found in webdav.log under <GIS_install_dir>\SterlingCommerce\SI\logs

Your new site will appear in the list of sites to include in the search.

8. Select the check-box to the left of the new site. Click Finish.

The system verifies the selected site and displays the results. On the search results page, expand the update site node and select from the following plug-ins, according to your licenses:

MESA Developer Studio (For Custom Service)
Service SDK
Skin Editor

9. Click Next. Accept the terms of the license and click Next.

10. Click Finish.

11. Click Install All to accept the feature verification.

You must restart Eclipse for the changes to take affect.