Installing Oracle 11g Enterprise Edition on Ubuntu 12.10

Required Software’s

VMware Player

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

Best tools

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

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

​Read​

 ​and Write Primary Document while implementing

​a ​

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;
    }

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

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>                                   

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/

Marketing concepts Explained...

40 Useful Websites

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

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

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. ​

12 Rules of Success

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

​ 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

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.

6.

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

7. Complete the following information and click OK.

1.  Name –
   ​Type a descriptive name for the application server.
2.  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:

1.  MESA Developer Studio (For Custom Service)
2. ​ ​
   Service SDK
3.  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.

eCommerce software Production Migration

Too many services interlinked to develop one complete eCommerce application :)

Sterling Integrator Active and DR Site Diagram

5 Nice Little Stories

SQL Developer Installation on Ubuntu 12.10

1. Download SQL Developer from the followng URL,
  

​ ​

http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
2. Accept License Agreement
3. Other Platforms and Download the file. File name will be sqldeveloper-3.2.20.09.87-no-jre.zip
4. unzip the file to your prefered location, Something like below,
   unzip /home/sirishg/Downloads/sqldeveloper-3.2.20.09.87-no-jre.zip -d /u02/app/
5. cd to /u02/app/sqldevloper
6. Need to add jdk directory in sqldeveloper.conf
7. cd to /u02/app/sqldeveloper/sqldeveloper/bin and edit qldeveloper.conf
8. gedit qldeveloper.conf and update SetJavaHome value to your java home directory location
   SetJavaHome /u02/app/ibm-java-i386-60
9. All done now just go to /u02/app/sqldeveloper and run sqldeveloper.sh

XPath Syntax if we have multiple Namespaces in ProcessData

Reading the XPath if we have multiple namespaces in ProcessData,

ProcessData

<ProcessData>
<RevealPanReply xmlns="http://w3schools.com/account/services/1.0/">
        <MessageHeader>
            <payment:CreateTimestamp xmlns:payment="http://w3schools.com/account/types/1.0/">2013-01-18T17:58:31.204Z</payment:CreateTimestamp>
        </MessageHeader>
        <PaymentAccountNumber>4111111111111111</PaymentAccountNumber>
</RevealPanReply>
</ProcessData>

XPath

/ProcessData//*[local-name()='PaymentAccountNumber']

MySQL Installation and Database creation on Ubuntu 12.10

1. Install mysql on Ubuntu 12.10. (Use apt-get install mysql-server)
2. Log on to mysql as a root user
     $ mysql -u root
     $ mysql -u root -p
       Enter password: ENTER ROOT PASSWORD
3. Create a Database for Sterling Integrator
     mysql> create database SI52;
            Query OK, 1 row affected (0.00 sec)
4. Add User called sterling to SI52 Database
    mysql> grant usage on *.* to sterling@localhost identified by 'password';
    Query OK, 0 rows affected (0.00 sec)
    mysql>GRANT ALL PRIVILEGES ON SI52.* TO sterling@localhost IDENTIFIED BY password WITH GRANT OPTION;
    mysql>FLUSH PRIVILEGES;
5. Grant all priviliges to sterling user on SI52 database
   mysql> grant all privileges on amarokdb.* to amarokuser@localhost ;
   Query OK, 0 rows affected (0.00 sec)
6. Login as sterling user and check the database access to SI52
$ mysql -u sterling -p'password' SI52
    Your MySQL connection id is 12
    Server version: 5.0.38-Ubuntu_0ubuntu1-log Ubuntu 7.04 distribution
    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
    mysql>

      

Sirish reddy sent you a SlideShare presentation

The world's largest community for sharing presentations. Start sharing!

Your colleague Sirish reddy sent you this SlideShare presentation "B2B" B2B Framework for IBM Sterling B2B Integrator   B2B Framework for IBM Sterling Integrator - Minimizes development and deployment time for new proje... 864 views 24 downloads View it now

How-to Install and Getting-Started on Oracle 11g R...

Install Climber: How-to Install and Getting-Started on Oracle 11g R...: This is an Easy and Step-by-Step Guide to Install the Oracle 11g R2 x64 Database on Linux Ubuntu 12.10 Quantal Quetzal 64bit Unity Desktop ....

Good Read

A good read...

addicted2success.com/success-advice/the-guideline-to-become-a-winner

LAST Life-Changing Seminar by Sandeep Maheshwari in Hindi - A Must Watch (Full Video)

A must watch one loved it and I started my new year in right direction.

http://www.youtube.com/watch?v=eDiA1p5DlLg

One Paragraph That explains Life...

ONE PARAGRAPH THAT EXPLAINS LIFE!

Arthur Ashe, the legendary Wimbledon player was dying of AIDS which he got due to infected blood he received during a heart surgery in 1983.

From world over, he received letters from his fans, one of which conveyed: "Why does GOD have to select you for such a bad disease"?

To this Arthur Ashe replied:

"The world over -- 50 million  children start playing tennis, 5 million learn to play tennis,

500,000 learn professional tennis, 50,000 come to the circuit, 5000 reach the  grand slam,

50 reach Wimbledon, 4 to semi final, 2 to the finals,

when I was holding a cup I never asked GOD 'Why me?'.

And today in pain I should not be asking GOD 'Why me?' "


"Happiness keeps you Sweet,
Trials keep you Strong,
Sorrow keeps you Human,
Failure keeps you humble and Success keeps you glowing, but only Faith & Attitude Keeps you going...

New Year Resolutions - 2013

I started working on below things, Let's see how long and how far I'll continue,

1. Be at work by sharp 9 AM.
2. Do regular work out.
3. Learn and get expertise in an additional Programming Language.
4. Getting good hands on Ubuntu OS.
5. Read, Read and Read.
6. Polish and enhance on Enterprise Integration skills.

 

XPath Builder Tool

A cool XPath builder tool, I liked it,
http://www.bubasoft.net/Product/XpathBuilder

Setup a SFTP Server on Ubuntu

Yet Another Computing Blog: Ubuntu - Setup a SFTP Server: This procedure will setup a SFTP server, thats FTP over SSH on Ubuntu Server. In this instance the FTP server will be for a group of people...

10 Creative Ways To Make Money Online | Addicted 2 Success

http://addicted2success.com/success-advice/10-creative-ways-to-make-money-online-right-now/