O'Reilly Databases

oreilly.comSafari Books Online.Conferences.

We've expanded our coverage and improved our search! Search for all things Database across O'Reilly!

Search Search Tips

advertisement
AddThis Social Bookmark Button

Listen Print Discuss Subscribe to Databases Subscribe to Newsletters

Installing Oracle 9iR2 on Red Hat 9
Pages: 1, 2

Running the Installer

To install 9iR2 on Linux, Oracle recommends at least 512MB of RAM and at least 400MB of swap space. If you have less then 512MB of RAM and upgrading is not an option, you can resize your swap partition or create temporary swapping space. The later is a much more convenient option, as you will be needing this space only during the installation.



To set up a temporary Linux swap area, execute these lines as root:

% dd if=/dev/zero of=tmp_swap bs=1k count=900000
% chmod 600 tmp_swap
% mkswap tmp_swap
% swapon tmp_swap

After you finish installing, you can free this space:

% swapoff tmp_swap
% rm tmp_swap

Now that you have all the major obstacles out of the way, you can run the installer. Please remember that the Oracle installer must be run from X. You will need to allow the local oracle user to write to your X display:

$ xhost +127.0.0.1

Do not change to your CD-ROM mount directory (e.g., /mnt/cdrom), because you will not be able to unmount the first CD to insert others when asked. Start the installer from your home directory using:

$ su - oracle
$ /mnt/cdrom/install/linux/runInstaller

Installation

We will not describe the installation process in detail, as Oracle provides extensive documentation on that subject and it is way beyond the scope of this article. It is pretty much self-explanatory, but if you run into trouble, there's always a help button to assist you. If you need more help, check the docs directory on the Oracle CDs, the online Oracle Documentation, or Oracle Linux Center. During the installation, Oracle will ask you to insert other disks. When asked, open up a new console, unmount the current disk with umount /dev/cdrom (as root) and replace the disk. If Red Hat 9 does not mount it automagically, mount it yourself with mount /dev/cdrom and choose to continue with the installation wizard.

As you go along, your installation may produce three different errors:

  • You may see an error dialog informing about problems with ins_oemagent.mk. Ignore this one; we will fix it in post installation.

    Warning dialog screenshot
    Figure 1. ins_oemagent.mk errors

  • A dialog may inform you about an Error in invoking target install of makefile $ORACLE_HOME/ctx/lib/ins_ctx.mk.

    Warning dialog screenshot
    Figure 2. makefile error

    When this happens, open up a new X terminal and log in as the oracle user. Execute the following commands:

    [oracle@miniroko oracle]$ cd $ORACLE_HOME/install
    [oracle@miniroko install]$ tail make.log

    You will see a line like this:

    gcc -o ctxhx -L/opt/ora9/product/9.2/ctx/lib/ -L/opt/ora9/product/9.2/lib/
    -L/opt/ora9/product/9.2/lib/stubs/  /opt/ora9/product/9.2/ctx/lib/ctxhx.o
    -L/opt/ora9/product/9.2/ctx/lib/ -lm -lsc_ca -lsc_fa -lsc_ex -lsc_da -lsc_ut
    -lsc_ch -lsc_fi -lctxhx -lc -Wl,-rpath,/opt/ora9/product/9.2/ctx/lib -lnls9
    -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9

    Screenshot gnome terminal
    Figure 3. The make.log

    Copy this line, add -ldl at the end, and run it in $ORACLE_HOME/bin.

    [oracle@miniroko]$ cd $ORACLE_HOME/bin
    [oracle@miniroko bin]$ gcc -o ctxhx -L/opt/ora9/product/9.2/ctx/lib/ 
    -L/opt/ora9/product/9.2/lib/ -L/opt/ora9/product/9.2/lib/stubs/  
    /opt/ora9/product/9.2/ctx/lib/ctxhx.o -L/opt/ora9/product/9.2/ctx/lib/ 
    -lm -lsc_ca -lsc_fa -lsc_ex -lsc_da -lsc_ut -lsc_ch -lsc_fi -lctxhx -lc 
    -Wl,-rpath,/opt/ora9/product/9.2/ctx/lib -lnls9 -lcore9 -lnls9 -lcore9 
    -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 -ldl

    Now you have fixed the problem, so hit the ignore button on the dialog and the installation will continue.

  • The installation may inform you that agent failed to start. Choose ignore on this one; we will also fix it in post installation.

Do not create a database at the end of the installation. Not all things are operational at this point, and we still need to perform some minor fixes. Click on Software only and continue. Don't worry, you will be able to create your database later using dbca, the Oracle database configuration assistant.

Database Create Screenshot
Figure 4. Do not create a database

Post-Installation

Let's fix the issues Oracle had with ins_ctx.mk and starting the agent. Open a new terminal and log in as the oracle user. Execute these lines:

[oracle@miniroko oracle]$ cd $ORACLE_HOME/network/lib
[oracle@miniroko lib]$ make -f ins_net_client.mk install

Now edit the $ORACLE_HOME/ctx/lib/ins_ctx.mk file. Change lines 13-14 from:

ctxhx: $(CTXHXOBJ)
$(LINK) $(CTXHXOBJ) $(INSO_LINK)

to

ctxhx: $(CTXHXOBJ)
$(LINK) -ldl $(CTXHXOBJ) $(INSO_LINK)

You are now ready to retry making:

[oracle@miniroko lib]$ make -f $ORACLE_HOME/ctx/lib/ins_ctx.mk install

Voila, you now have a fully working installation of Oracle 9iR2 database server. If you wish, you can now create your Oracle database using dbca.

Starting and Stopping the Database

svrmgrl is no longer supported by Oracle, so use sqlplus for startup and shutdown operations. To start the server:

[root@miniroko]# su - oracle
[oracle@miniroko oracle]$ lsnrctl start
[oracle@miniroko oracle]$ sqlplus /nolog
 
SQL*Plus: Release 9.2.0.1.0 - Production on ?et Svi 29 13:52:34 2003
 
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
 
Total System Global Area   93393176 bytes
Fixed Size                   450840 bytes
Variable Size              75497472 bytes
Database Buffers           16777216 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

To shut down the server:

[root@miniroko]# su - oracle
[oracle@miniroko oracle]$ lsnrctl stop
[oracle@miniroko oracle]$ sqlplus /nolog
 
SQL*Plus: Release 9.2.0.1.0 - Production on ?et Svi 29 13:55:32 2003
 
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 
SQL> connect / as sysdba
Connected.
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

To integrate Oracle with Red Hat's SysV init process and make startup and shutdown automatic, you can use Gurulab's Oracle9i RHL Run Package. I do not recommend Oracle's native scripts $ORACLE_HOME/bin/dbstart and $ORACLE_HOME/bin/dbshut, as they do not always work as advertised and require some changes.

Conclusion

You now have a fully featured Oracle installation on your computer. Please remember that Oracle 9.2 is not certified for Red Hat 9, and that this combination is not endorsed in production and deployment environments. As a workstation, however, it is perfectly stable and usable.

Roko Roic currently works at Tis.kis, developing core and user-level GSM related systems.


Return to the Linux DevCenter.


Lost in the directions? Working for you? Let Roko know here.
You must be logged in to the O'Reilly Network to post a talkback.
Post Comment
Full Threads Oldest First

Showing messages 1 through 54 of 54.

  • Oracle9iR2 postinstallation procedure in a shrink-wrapped Red Hat 9 and the freely downloadable version.
    2004-07-21 01:28:40  infxdba [Reply | View]

    Just follow [1]:

    1.Download from from redhat.com required version of src.rpm for glibc, supposedly glibc-2.3.2-11.9.src.rpm

    2. rpm -i glibc-2.3.2-11.9.src.rpm

    3. cd /usr/src/redhat/SOURCES

    4 bzip2 -dc glibc-2.3.2-20030313.tar.bz2 | tar xf - -C /tmp

    5.cd /tmp/glibc-2.3.2-20030313/locale

    6. Comment out all compat_symbols lines in file lc-ctype.c

    7. cd ../ctype

    8. Comment out all compat_symbols lines in file ctype-info.c

    9. cd ..;cd ..;pwd
    /tmp

    10. tar cvf glibc-2.3.2-20030313.tar glibc-2.3.2-20030313

    11. bzip2 glibc-2.3.2-20030313.tar

    12. cp glibc-2.3.2-20030313.tar.bz2 /usr/src/redhat/SOURCES

    13. cd /usr/src/redhat/SPECS

    14. vi glbc-9.spec

    15. Add to the end of glibcrelease line (line 1) .oracle.
    (11.9 now looks as 11.9.oracle)
    and save

    15. rpmbuild ûba /usr/src/redhat/SPECS/glbc-9.spec

    In my case at the end rpms were written to /usr/src/redhat/RPMS/i386 folder

    16.Download from [1]:

    Updated i386 RPMS

    glibc-2.3.2-27.9.7.oracle.i386.rpm
    glibc-common-2.3.2-27.9.7.oracle.i386.rpm
    glibc-debug-2.3.2-27.9.7.oracle.i386.rpm
    glibc-debuginfo-2.3.2-27.9.7.oracle.i386.rpm
    glibc-debuginfo-common-2.3.2-27.9.7.oracle.i386.rpm
    glibc-devel-2.3.2-27.9.7.oracle.i386.rpm
    glibc-profile-2.3.2-27.9.7.oracle.i386.rpm
    glibc-utils-2.3.2-27.9.7.oracle.i386.rpm
    nscd-2.3.2-27.9.7.oracle.i386.rpm

    AND

    Updated i686 RPMS
    glibc-2.3.2-27.9.7.oracle.i686.rpm

    Start rmps upgrade:

    [root@ServerDBS inst_patch]# rpm -Uvh glibc-2.3.2-27.9.7.oracle.i686.rpm \
    > glibc-common-2.3.2-27.9.7.oracle.i386.rpm \
    > glibc-utils-2.3.2-27.9.7.oracle.i386.rpm \
    > glibc-debug-2.3.2-27.9.7.oracle.i386.rpm \
    > glibc-devel-2.3.2-27.9.7.oracle.i386.rpm

    Preparing... ########################################### [100%]
    1:glibc-common ########################################### [ 20%]
    2:glibc ########################################### [ 40%]
    Stopping sshd:[ OK ]
    Starting sshd:[ OK ]
    3:glibc-devel ########################################### [ 60%]
    4:glibc-utils ########################################### [ 80%]
    5:glibc-debug ########################################### [100%]

    [root@ServerDBS inst_patch]# rpm -Uvh glibc-debuginfo-2.3.2-27.9.7.oracle.i386.rpm \
    > glibc-debuginfo-common-2.3.2-27.9.7.oracle.i386.rpm

    Preparing... ########################################### [100%]
    1:glibc-debuginfo-common ########################################### [ 50%]
    2:glibc-debuginfo ########################################### [100%]

    [root@ServerDBS inst_patch]# rpm -Uvh glibc-profile-2.3.2-27.9.7.oracle.i386.rpm \
    > nscd-2.3.2-27.9.7.oracle.i386.rpm

    Preparing... ########################################### [100%]
    1:nscd ########################################### [ 50%]
    2:glibc-profile ########################################### [100%]

    At this point run as oracle:
    make -f ORACLE_HOME/network/lib/ins_oemagent.mk install

    This time you will be succeed due patched rpms installed.

    Then grap from $ORACLE_HOME/root.sh all commands required
    to install right permissions for dbsnmp and dependent directories and
    run them as root.
    Next steps:
    $agentctl start
    $oemctl start oms

    You are ready to run OEM console.

    References:

    1. http://mlug.missouri.edu/~jmcintosh/computers/oracle/redhat/9/rpms/
  • Oracle 9iR2 Install on Red Hat Linux 9
    2004-06-04 13:05:53  Scrapper [Reply | View]

    I've followed these instructions and they worked great for me!
    However, I think I found two missing elements. What about the Oracle Apache and Java considerations?
    Also, the link to the Red Hat Oracle manual dowsn't go there. It goes to the virtual file system manual.
  • according to problem (dbca)
    2004-05-11 04:11:03  matheus [Reply | View]

    hi Erick, thanks! for the aid I made this, but my problem now is another one, when start to execute dbca, in the option creating and initiating the instancia oracle it stops in 46%, what I make. please it helps me.

    Matheus
    • according to problem (dbca)
      2005-03-19 10:09:24  najeebuddinsyed [Reply | View]

      error is /oraeng/jre/1.1.8/bin ../lib/i686/native-threads/libzib.so:symbol
    • according to problem (dbca)
      2005-03-19 10:07:58  najeebuddinsyed [Reply | View]

      • according to problem (dbca)
        2005-03-23 22:15:56  Installing-Oracle-9iR2-on-Red-Hat-9 [Reply | View]

        Hi,
        I am Trying Oracle 9.2.0.1.0 on Linux Red Hat 9
        I am following instruction on puschitz.com.

        Things went fine during installtion as i proceed as per puschitz's instructions
        However at the i faced some problem.
        and i badly seek your advice and help on that

        Below is list of activities i done for this..

        Checked Memory
        grep MemTotal /proc/meminfo : found proper

        Checked Swap space
        cat /proc/swaps : found proper

        set Shared Memory
        echo "kernel.shmmax=2147483648" >> /etc/sysctl.conf

        checked the space in /tmp
        $ df /tmp : found adequate

        Oracle Disk Space
        /oradir mount point with 3GB space

        checked Development Packages
        rpm -q gcc cpp compat-libstdc++ glibc-devel glibc-kernheaders binutils

        Created Oracle user Account
        su - root
        groupadd dba # group of users to be granted with SYSDBA system privilege
        groupadd oinstall # group owner of Oracle files
        useradd -c "Oracle software owner" -g oinstall -G dba oracle
        passwd oracle

        Created Oracle Directories
        su - root
        mkdir /oradir/oracle
        mkdir /oradir/oracle/product
        mkdir /oradir/oracle/product/9.2.0
        chown -R oracle.oinstall /oradir/oracle

        Following not created as i was not having /var mount point
        mkdir /var/opt/oracle
        chown oracle.dba /var/opt/oracle
        chmod 755 /var/opt/oracle


        Added Following Environment variables in .bash_profiles of oracle user and confirmed by relogging and 'set' as well as echo
        export LD_ASSUME_KERNEL=2.4.1

        export ORACLE_BASE=/oradir/oracle
        export ORACLE_HOME=/oradir/oracle/product/9.2.0
        export ORACLE_SID=SAKET
        export ORACLE_TERM=xterm
        export NLS_LANG=AMERICAN;
        export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
        LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
        LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
        export LD_LIBRARY_PATH
        export PATH=$PATH:$ORACLE_HOME/bin

        CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
        CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib
        export CLASSPATH

        Now, i relogged in and checked environment variables are proper

        put CD 1 Of 3 ->the OUI started Properly
        ORacle Home Name : j
        Oracle Home Path : /oradir/oracle/product/9.2.0.1.0 (was selected by default)

        Privileged Operating System Groups :dba (i kept the default)
        Oracle Managent Server Repository: New i selected
        Create database : No


        The Error1 (resolved finally)
        "Error in invoking target install of makefile /opt/oracle/product/9.2.0/ctx/lib/ins_ctx.mk"
        adding "`cat $(LIBHOME)/sysliblist`" string to $ORACLE_HOME/ctx/lib/env_ctx.mk and clicking 'Retry' resolved it
        INSO_LINK = -L$(CTXLIB) $(LDLIBFLAG)m `cat $(LIBHOME)/sysliblist` $(LDLIBFLAG)sc_ca $(LDLIBFLAG)sc_fa $(LDLIBFLAG)sc_ex $(LDLIBFLAG)sc_da $(LDLIBFLAG)sc_ut $(LDLIBFLAG)sc_ch $(LDLIBFLAG)sc_fi $(LLIBCTXHX) $(LDLIBFLAG)c -Wl,-rpath,$(CTXHOME)lib $(CORELIBS) $(COMPEOBJS)

        Then
        Database Creation complete successful
        Link Successful
        Network Services Successful

        Then Error2 (unresolved)
        the attemp to create a database for the enterprise manager repository failed, because:
        The command:
        "/oradir/oracle/product/9.2.0.1.0/bin/dbca -
        progress_only -emca_interrnal -createDatabase -
        templateName Transaction_Processing.dbc -
        gdbName OEMREP.localdomain -sid OEMREP"
        RETURNED STATUS: 137


        Here i finished installation thinking that i will go for OEM stuff later point of time.

        Then Error3 (unresolved)
        then tried to start dbca
        dbca
        SIGSEGV 11* segmentation violation
        stackbase stackpointer
        Full thread:
        ..
        ..
        ..
        /oradir/oracle/product/9.2.0.1.0/bin/dbca: line 124: 3170 killed $JRE_DIR/bin/jre -DORACLE_HOME=$OH -DJDBC_PROTOCOL=thin -mx64m -classpath $CLASSPATH..........
        oracle.sysman.assistants.dbca.Dbca $ARGUMENTS

        I executed the ipcs command to get the address of the shared memory segments that have been allocated by Oracle:
        $ su - root
        # ipcs

        But there was no entry with 'oracle' as owner name.

        Then Error4 (unresolved)

        Then Tried lsnrctl
        lsnrctl status
        .. Got an error
        According to puschitz.com

        su - root
        mkdir /var/tmp/.oracle
        chown oracle:dba /var/tmp/.oracle
        Now try to run lsnrctl start as oracle again.
        But i do not have /var
        What tyo do here?


        Here i am stuck up, i struggled a lot last few days.
        success seems closer but how to get it.

        Here again i need your advice
        puschitz.com asks for patches for RH As not for RH. so how to proceed are any patches required for RH 9 also or same as RH AS.
        if yes can you help me in getting URL, i am trying at home, no metalink registration available.

        Thanks in advance
        Pratap

  • Problems in the installation
    2004-05-06 06:55:22  matheus [Reply | View]

    I am from Brazil,I don´t write well English, necessary of help:
    after executing the command /mnt/cdrom/install/linux/runInstaller
    it initiates the execution of the installation, but it stops in the following archive :
    README...does not execute more nothing, it is in 0 %...necessary of its aid... please
    • Problems in the installation
      2004-05-07 06:58:20  erik45 [Reply | View]

      Matheus,

      Setting the environment variable LD_ASSUME_KERNEL to 2.4.1 should fix it. The following link was very helpful during my installs of Oracle on Linux:

      http://www.puschitz.com/OracleOnLinux.shtml

      -Erik
  • post installation problem
    2004-04-15 23:27:28  mateenma [Reply | View]

    Hi Roko,
    thaks for this article its really helpful.
    After installation i try to start agnetctl its giving me error .i have serach other sites i have found that i have to install patch P3238244
    but i don't have memgership of metalink is there any other solution . i have startted the instance ater giving spfile parameter on startup nomount and started dbca and its giving error saying character set not supported .
    if any one know the solution please mail me .
    thanks
    mateen
  • problems with LSSV
    2004-03-08 14:09:25  danstraw [Reply | View]

    Hi,

    Great install guide - saved my life

    I had another couple of problems installing on red hat 9, and thought I'd share my solutions here.

    It came at the end of the install, when the insaller prompts you to run $ORACLE_HOME/root.sh

    All progresses nicely until I get an error when it gets to installing the LSSV product:

    Starting RPM to install the Legato Single Server Version (LSSV) product.
    Form more information, please refer to the Linux installation section
    in the LSSV Installation Guide at http://www.legato.com/LSSV

    error: Failed dependencies:
    libncurses.so.4 is needed by orclclnt-nw_lssv.Build.71-1

    which was solved by downloading ncurses4-5.0-11.i386.rpm and installing:
    rpm -Uvh ncurses4-5.0-11.i386.rpm

    I tried re-running, and then get another error:
    LSSV successfully installed on [snip]!
    error: Failed dependencies:
    /bin/ksh is needed by orclserv-nw_lssv.Build.71-1

    which was solved by downloading pdksh-5.2.14-13.i386.rpm and installing :
    rpm -Uvh pdksh-5.2.14-13.i386.rpm

    Thanks to the article here:
    http://www.puschitz.com/InstallingOracle9iRAC.shtml

    • problems with LSSV
      2004-05-06 07:04:38  matheus [Reply | View]

  • Unable to Install 8.1.7 NOT 9i on Redhat 9
    2004-02-20 20:23:38  km1 [Reply | View]

    I cannot get 8.1.7 installation done on my pc. I downloaded the whole installation file from the oracle 8.1.7 download site under /usr/local/downloads/Oracle8iLinux/ and extracted Disk1 contents under
    /usr/local/downloads/Oracle8iLinux/Disk1
    and the linux81701.tar is under /usr/local/downloads/Oracle8iLinux/

    I did the export LD_ASSUME_KERNEL=2.4.1 and I get the message

    [oracle@localhost Disk1]$ ./runInstaller
    Initializing Java Virtual Machine from ../stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/bin/jre. Please wait...

    I get a blank gray screen which seems to mean that the jre is trying to load but nothing happens beyond that.

    Is there something specific for 8.1.7 which is different for 9i because most docs I see refer to 9i not 8.1.7 and I do need 8.1.7 because thats the database we need to use.

    The pc I am trying to install this on has 384MB RAM which is not a lot but I I doubt that that is the cause of the hangup because I have other even more resource intensive software which I have been able to install without problems.

    I have tried to install this for a long time and really need to get this going asap. Please help soon.

    Thanks
  • host undetermined error? help! anyone??
    2004-02-16 05:09:34  raquelli [Reply | View]



    IP host undetermined??? what's wrong? pls help.

    thanks!
  • excellent article
    2004-02-06 13:31:34  ioc0023 [Reply | View]

    Roko,
    As a newbie to Linux, this article helped me install Oracle 9iR2 on RH9 the very first time I tried. Thanks for a well written and detailed instructions that was enough for me to have a succesful install.


    Many Thanks!
  • Error : LRM-00109
    2004-01-16 07:51:32  anonymous2 [Reply | View]

    SQL*Plus: Release 9.2.0.1.0 - Production on Pet Sij 16 23:48:27 2004
    Hi Roko,

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    SQL> connect / as sysdba
    Connected to an idle instance.
    SQL> startup
    ORA-01078: failure in processing system parameters
    LRM-00109: could not open parameter file '/opt/ora9/product/9.2/dbs/initora9i.ora'
    SQL>

    I get the above error when running startup. I followed very closely to your article and did the install many times. Do u have any idea what went wrong? Thanks.
    • Error : LRM-00109
      2004-01-20 07:14:35  anonymous2 [Reply | View]

      I got exactly the same problem how did your solve this problem?
      alain.margeride@wanadoo.fr
  • Thanks Roko !
    2004-01-14 08:16:56  jejik [Reply | View]

    I first struggled (with the also very good tips) from Werner Puschitz at http://www.puschitz.com/InstallingOracle9i.shtml.

    But I still couldn't get it to work. Then I tried your amazing tips and it all worked like a charm.

    Thanks a lot Roko!

    /Jan-Erik
  • Problem with national characters
    2004-01-12 04:56:51  anonymous2 [Reply | View]

    Hi,
    I've installed Oracle 9.2.0.1.0 on Mandrake9 Linux 2.4.22 as in your article - very good;o)
    I can connect to an idle instance:
    #su - oracle
    #lsnrctl start
    #sqlplus /nolog
    SQL>connect / as sysdba
    SQL>startup nomount pfile="/opt/ora9/product/9.2/USOS/pfile/initUSOS.ora
    ...Instance started... ok
    SQL>CREATE DATABASE "USOS"
    maxdatafiles 254
    maxinstances 8
    maxlogfiles 32
    character set ee8iso8859p2
    national character set ee8iso8859p2
    DATAFILE '$ORACLE_BASE/oradata/USOS/USOS_system01.dbf' SIZE 512M
    etc....
    and after pressing enter I get the following message:
    "You gave an incorrect national set of characters"

    I really tried to modify these varriables but I cannot coome to the correct solution ;o(
    I've enclosed some files that could help you.
    COULD YOU HELP ME PLEASE!
    Best regards

    Tomasz Rykala
    Computer Scientist at Politechnika Czestochowska (University)
    trykala@adm.pcz.czest.pl
  • /tmp/orainstaRoot.sh. Unable to continue install.
    2003-12-21 19:10:46  anonymous2 [Reply | View]

    At Step 3, it request me to input UNIX Group Name
    afte inputing dba,the following Error appears:

    Unable to generate temporary script: (0)
    Unable to continue install

    Teminal display:
    Unable to generate temporary script:
    /tmp/orainstaRoot.sh. Unable to continue install.
  • Order of installation
    2003-12-11 04:58:51  kebam [Reply | View]

    I was wondering if anyone could point me to a source or two where I could understand the general processes of working with Oracle databases. I found your above article invaluable in installing the DBMS. My problem now is the steps needed to create a database and get it talking to the application that needs it.

    Do I for example, configure the Enterprise Manager then build the database, then add it to the EM, then configure and build the listener? What order do I need to do things and what tools do I use. I have found dbca, emca under the Linux install and the oemapp console commands. I think I understand that my application needs to be told which listener to use, and this is somehow done with the network configuration tools.

    This is all very confusing. I would appreciate any pointers to similar articles as the one above or other sources of information.

    Thanks
  • installer hangs on RH 2.4.20-20.8 upgraded to 2.4.20-20.9
    2003-12-08 07:29:47  anonymous2 [Reply | View]

    hi Roko-

    I am trying to install Oracle 9ir2 on a red hat 9 box. Wanted to see if I could seek your help on a dead end I am running up against.

    I downloaded the iso images for 2.4.20-20.8 from RH website and upgraded kernel to 2.4.20-20.9.

    I was following the Roko's instructions on O'Reilly and installed the folowing packages from the cds:
    gcc-3.2.2-5
    cpp-3.2.2-5
    glibc-devel-2.3.2-11.9
    binutils-2.13.90.0.18-9
    compat-gcc-7.3-2.96.118.i386.rpm
    compat-libgcj-7.3-2.96.118.i386.rpm
    compat-libgcj-devel-7.3-2.96.118.i386.rpm
    nss_db-compat-2.2-20.i386.rpm

    Roko mentioned that I should install the following precompiled packages from Jason's website (got the i686 packages wherever possible):
    glibc-2.3.2-27.9.oracle.i386.rpm
    glibc-2.3.2-27.9.oracle.i686.rpm
    glibc-common-2.3.2-27.9.oracle.i386.rpm
    glibc-debug-2.3.2-27.9.oracle.i386.rpm
    glibc-debuginfo-2.3.2-27.9.oracle.i386.rpm
    glibc-debuginfo-2.3.2-27.9.oracle.i686.rpm
    glibc-debuginfo-common-2.3.2-27.9.oracle.i386.rpm
    glibc-devel-2.3.2-27.9.oracle.i386.rpm
    glibc-profile-2.3.2-27.9.oracle.i386.rpm
    glibc-utils-2.3.2-27.9.oracle.i386.rpm
    nptl-devel-2.3.2-27.9.oracle.i686.rpm
    nscd-2.3.2-27.9.oracle.i386.rpm

    I was able to install most packages except:
    glibc-2.3.2-27.9.oracle.i686.rpm
    glibc-common-2.3.2-27.9.oracle.i386.rpm
    glibc-utils-2.3.2-27.9.oracle.i386.rpm
    glibc-debug-2.3.2-27.9.oracle.i386.rpm

    glibc-utils-2.3.2-27.9.oracle.i386.rpm AND glibc-debug-2.3.2-27.9.oracle.i386.rpm ARE DEPENDENT ON glibc-2.3.2-27.9.oracle.i686.rpm DEPENDENT ON glibc-common-2.3.2-27.9.oracle.i386.rpm.

    So far so good.

    When I try to install glibc-common-2.3.2-27.9.oracle.i386.rpm it says glibc-common-2.3.2-11.9 required by glibc-2.3.2-11.9 (installed). So I am at a dead end as both those packages are installed.

    So finally I tried the runinstaller w/o the 4 packages:
    glibc-2.3.2-27.9.oracle.i686.rpm
    glibc-common-2.3.2-27.9.oracle.i386.rpm
    glibc-utils-2.3.2-27.9.oracle.i386.rpm
    glibc-debug-2.3.2-27.9.oracle.i386.rpm


    The installer ran but got stuck immmediately at 'Installing Java Runtime Environment' and did not proceed anymore. Would there be any suggestions you might be able to offer on how I need to proceed or do differently.

    Would it help to try and install this on the Fedora disto. Would it be essentially similar procedures?

    Really your help in pointing me in the right direction. Not a hard core user of Linux yet. Trying to get there.

    Thanks a lot and really appreciate your help.

    monosij
    • installer hangs on RH 2.4.20-20.8 upgraded to 2.4.20-20.9
      2004-07-20 12:59:35  infxdba [Reply | View]

      When RPMS install is done run as oracle:
      $make -f $ORACLE_HOME/network/lib/ins_oemagent \
      install
      This time it's going to be OK.
      $agentctl start
      won't fail anymore
    • installer hangs on RH 2.4.20-20.8 upgraded to 2.4.20-20.9
      2004-07-20 07:18:26  infxdba [Reply | View]

      Sorry Sir, your stuff works:

      [root@ServerDBS inst_patch]# rpm -Uvh glibc-2.3.2-27.9.7.oracle.i686.rpm \
      > glibc-common-2.3.2-27.9.7.oracle.i386.rpm \
      > glibc-utils-2.3.2-27.9.7.oracle.i386.rpm \
      > glibc-debug-2.3.2-27.9.7.oracle.i386.rpm \
      > glibc-devel-2.3.2-27.9.7.oracle.i386.rpm
      Preparing... ########################################### [100%]
      1:glibc-common ########################################### [ 20%]
      2:glibc ########################################### [ 40%]
      Stopping sshd:[ OK ]
      Starting sshd:[ OK ]
      3:glibc-devel ########################################### [ 60%]
      4:glibc-utils ########################################### [ 80%]
      5:glibc-debug ########################################### [100%]
      [root@ServerDBS inst_patch]# rpm -Uvh glibc-debuginfo-2.3.2-27.9.7.oracle.i386.rpm \
      > glibc-debuginfo-common-2.3.2-27.9.7.oracle.i386.rpm
      Preparing... ########################################### [100%]
      1:glibc-debuginfo-common ########################################### [ 50%]
      2:glibc-debuginfo ########################################### [100%]
      [root@ServerDBS inst_patch]# rpm -Uvh glibc-profile-2.3.2-27.9.7.oracle.i386.rpm \
      > nscd-2.3.2-27.9.7.oracle.i386.rpm
      Preparing... ########################################### [100%]
      1:nscd ########################################### [ 50%]
      2:glibc-profile ########################################### [100%]

      But intelligent agent still failes to start:
      $agentctl start
      Should this patching be applied only before runIstaller ?




    • installer hangs on RH 2.4.20-20.8 upgraded to 2.4.20-20.9
      2004-07-20 00:38:49  infxdba [Reply | View]

      I guess reference regarding Jason's website may be ignored. Through my experience,time consuming successful rpmbuild step won't help any way due to version of glibc: 2.3.2-11.9
      If I am wrong about this, please advise.
      Mixing i386 and i686 rpms in one upgrade
      doesn't look for me as the right way to go,regardless it could be a solution.
      The final drawback will be: missing "Intelligent agent" up and running
      What will affect Events&Jobs in manually configured OEM console. However, cron facility and shell scripting will be still available :)
    • installer hangs on RH 2.4.20-20.8 upgraded to 2.4.20-20.9
      2004-05-06 07:07:12  matheus [Reply | View]

    • installer hangs on RH 2.4.20-20.8 upgraded to 2.4.20-20.9
      2003-12-22 15:52:08  anonymous2 [Reply | View]

      I was having the same problem, but it worked when I installed the 4 packages in one command:

      rpm -Uvh glibc-2.3.2-27.9.oracle.i686.rpm \
      glibc-common-2.3.2-27.9.oracle.i386.rpm \
      glibc-utils-2.3.2-27.9.oracle.i386.rpm \
      glibc-debug-2.3.2-27.9.oracle.i386.rpm

      Hope that helps
    • installer hangs on RH 2.4.20-20.8 upgraded to 2.4.20-20.9
      2003-12-10 23:40:16  anonymous2 [Reply | View]

      Any idea how to fix this issue. I am up against the same thing

      Arvind
  • Oracle installation problem on dbsnmp
    2003-11-13 14:37:55  franklincsng [Reply | View]

    I have installed Oracle 9i into RedHat Linux 9 by using the procedures of webpage 'Installing Oracle 9iR2 on Red Hat 9'. When I start the Oracle Intelligent Agent, I get nothing response, and find the agent cannot be started.

    I find the error message in dbsnmp.nohup which is showed below:

    /opt/ora9/product/9.2/bin/dbsnmp: error while loading shared libraries: libvppdc.so: cannot open shared object file: No such file or directory
    Agent exited at Thu Nov 13 23:20:31 HKT 2003 with return value 127
    Agent thrashing. Exiting dbsnmpwd at Thu Nov 13 23:20:31 HKT 2003

    I found the library object is existed.

    [oracle@localhost lib]$ ll libvpp*
    -rw-r--r-- 1 oracle oinstall 552036 Apr 26 2002 libvppdc.so

    Someone tell me that dbsnmp is not compiled during installation.

    I find that 'collect2: ld returned 1 exit status
    make: *** [dbsnmp] Error 1' in $ORACLE_HOME/install/make.log


    Can anyone help me to solve the problem? Is that a post-installation step?


    Thank you.

    Regards,
    Franklin
    • Oracle installation problem on dbsnmp (libvppdc.so)
      2005-11-29 22:49:55  screen2000 [Reply | View]

      Hope u solved ur problem because u faced the problem a couple of years back. Please mail me how do u able to overcome this problem

      Best Regards
      balakrishna_p2000@yahoo.com
    • Oracle installation problem on dbsnmp
      2005-01-31 05:14:26  cmih1@yahoo.com [Reply | View]

      Hi,
      I have the same problem.
      Have you find any solutions?

      Best regards,
      Miky
  • installer hangs with 1.1.8.1 linking to README
    2003-11-07 12:29:18  anonymous2 [Reply | View]

    Hey Roko,
    My install process hangs looking for 1.1.8.1 README
    during 9i install on RH 9 . Files that are there under /opt/oracle/oracle.swd.jre/jre are /bin/jre

    Any clues?

    • installer hangs with 1.1.8.1 linking to README
      2003-11-19 04:38:57  anonymous2 [Reply | View]

      Hello Roko,

      I am facing the same problem. Can you please help.
      It is rather urgent.

      Best regards.
      • installer hangs with 1.1.8.1 linking to README
        2003-11-19 19:45:41  anonymous2 [Reply | View]

        Hello,

        I figured that I had not set LD_ASSUME_KERNEL=2.4.1 properly.

        Just check the value once again before you run the Installer. Also try 2.2.5 if 2.4.1 does not work.

        I am atleast past that error...
        Best regards.
        • installer hangs with 1.1.8.1 linking to README
          2003-12-11 04:06:08  anonymous2 [Reply | View]

          Hello

          Greetings..

          Where do i set this parameter?
          LD_ASSUME_KERNEL=2.4.1

          which file I should edit to give this parameter?
          I am using Linux 9 kernel-2.4.20-8

          please tell me.
          I am also blocked while installation copies the README file.it hangs there.

          Waiting for an early response

          Best Regards

          Shabu
          • installer hangs with 1.1.8.1 linking to README
            2003-12-31 03:15:57  anonymous2 [Reply | View]

            hi ..

            you can set this parameter in terminal itself
            follow these...
            1) login as Oracle
            2) set the enviornment variables like OracleHome etc.
            3) give this command
            export LD_ASSUME_KERNEL=2.4.19
            4) start runInstaller

            revert if u face any problems

            nageshnn@rediffmail.com
  • help can't run the installation
    2003-11-04 06:10:00  anonymous2 [Reply | View]

    when i run the installation,i got a error message:
    $./runInstaller: line 58: ./runInstaller: cannot execute binary file
    • help can't run the installation
      2003-11-06 22:51:28  anonymous2 [Reply | View]

      There is an answer for this problem at http://www.puschitz.com/InstallingOracle9i.html

      * /runInstaller: line 58: ./runInstaller: cannot execute binary file.

      You are probably trying to run a 64-bit Oracle version on a 32-bit Linux system. Make sure you downloaded the right Oracle version for your Linux system.

      To check if runInstaller is a 32-bit binary or a 64-bit binary, run the following command:

      $ cd /mnt/cdrom
      $ file install/linux/runInstaller
      install/linux/runInstaller: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.0.0, dynamically linked (uses shared libs), not stripped

      To check if your Linux system is 32-bit system or a 64-bit system, run e.g. the following command:

      $ file /sbin/init
      /sbin/init: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.2.5, dynamically linked (uses shared libs), not stripped

  • getting oracle & RH 9 to work with PHP
    2003-10-24 00:31:05  netnerdau [Reply | View]

    I've been having trouble getting the RPM installation of php to work with oracle once its installed. i can connect with sqlplus to my database (remote AIX box) but can't get it to work with PHP. I dont really want to have to re-compile PHP to get it working with oracle, as i like using up2date for patching things.

    php has an ODBC extension with redhat, does anyone know how to get this to work with oracle?
    • getting oracle & RH 9 to work with PHP
      2004-09-06 01:44:43  liuguohui [Reply | View]

    • getting oracle & RH 9 to work with PHP
      2004-01-06 07:42:12  jmcintosh [Reply | View]

      There's some open source Oracle ODBC drivers that I've gotten to work with Oracle. Look here:
      http://fndapl.fnal.gov/~dbox/oracle/odbc/
      The only trick is make sure your tnsnames.ora file and your /etc/odbc.ini file are in conjunction.
      Regards,
      Jason
      • getting oracle & RH 9 to work with PHP
        2004-09-06 01:29:31  liuguohui [Reply | View]

  • can you help me??
    2003-10-14 01:44:19  jsl1 [Reply | View]

    i get this error when i start the installer:

    Initializing Java Virtual Machine from /tmp/OraInstall/jre/bin/jre. Please wait...
    /tmp/OraInstall/jre/bin/../lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference (libzip.so)
    Unable to initialize threads: cannot find class java/lang/Thread
    Could not create Java VM

    what to do??
    thanks a lot!!
    • can you help me??
      2003-11-16 05:56:53  anonymous2 [Reply | View]

      i get this error when i start the installer:
      Initializing Java Virtual Machine from /tmp/OraInstall/jre/bin/jre. Please wait...
      /tmp/OraInstall/jre/bin/../lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference (libzip.so)
      Unable to initialize threads: cannot find class java/lang/Thread
      Could not create Java VM

      what to do??

      email: wimpysharma@hotmail.com
    • can you help me??
      2003-10-17 11:06:32  anonymous2 [Reply | View]

      try:
      export LD_ASSUME_KERNEL=2.4.1

      then start the installer.

      this is from:
      http://www.puschitz.com/InstallingOracle9i.html
  • /etc/sysctl.conf
    2003-10-09 01:15:38  anonymous2 [Reply | View]

    after placing new values in the /etc/sysctl.conf file you can just run the following command to read the file again:

    sysctl -p

    instead of rebooting or echoing to the /proc system manually.
  • Library dependencies
    2003-10-07 07:51:40  anonymous2 [Reply | View]

    I installed the libraries mentioned in this article. However, the installer JVM would not start without libraries provided by compat-libstdc++-7.3-2.96.118. To be sure, I installed the devel package as well.

    The machine is a single-processor HP Netserver LPr running Red Hat 9.0.
  • help can't complete intallation
    2003-10-06 16:04:58  anonymous2 [Reply | View]

    during the manager config assistant, what values do i enter when it asks me for this:

    service:<host><port><service>

    i tried service: localhost.1521.orcl

    but those values closed the installer on me.

    please help.
  • Oracle 9i install on Redhat 9
    2003-10-03 05:36:15  anonymous2 [Reply | View]

    Finally this was the only way to have Oracle 9 installed succesfully on Linux Redhat 9.
    • Oracle 9i install on Redhat 9 --> patch 9.2.0.4
      2003-10-06 06:12:28  anonymous2 [Reply | View]

      This article also helped me to install Oi9 on Rh9. To install the patch I had to downgrade to 2.3.3-5 for glibc, glibc-common and glibc-devel and after the installation I upgraded again. Now everything works.
      Thanks.
      • Oracle 9i install on Redhat 9 --> patch 9.2.0.4
        2003-11-08 21:19:40  anonymous2 [Reply | View]

        Please let me what exact glibc version you use. 2.3.2-5 OR 2.3.2-11 as the article suggested. I downgraded to 2.3.2-11 it is not working
  • A startup script - WORKS - on one condition
    2003-09-30 20:19:32  anonymous2 [Reply | View]

    The startup script listed at:

    http://www.tldp.org/HOWTO/Oracle-9i-RH8-and-RH9-HOWTO-5.html#ss5.2

    works, provided that you hard- or soft-link a new entry:

    ${ORACLE_HOME}/dbs/init${ORACLE_SID}.ora

    to the existing file:

    ${ORACLE_HOME}/dbs/spfile${ORACLE_SID}.ora

    It looks like Oracle has chosen to use "spfile.ora" as the replacement for old "init.ora". Strangely, the script works find with ye old "init.ora" files.
  • Creating the Oracle database
    2003-09-27 23:55:58  anonymous2 [Reply | View]

    I found this article extremely helpful - thanks a lot!
    I have just one question though:
    How do I create the default Oracle database with the dbca?

    Thanks,
    Paul
  • fetch the i686 packages
    2003-09-23 10:06:23  anonymous2 [Reply | View]

    Could you please be more explicit when you say "fetch the i686 packages"? I'm just starting out with Linux.
    • fetch the i686 packages
      2003-10-01 04:06:45  anonymous2 [Reply | View]


      "If your system contains a non-empty /lib/i686 directory, fetch the i686 packages. Otherwise, you may run into trouble with misplaced libraries."

      This sentence is misplaced in the article, it should be in the "Important notice" box on the right. The comment about i686 actually applies to Jason McIntosh's libraries.

      Cheers
      Roko Roic


Tagged Articles

Be the first to post this article to del.icio.us

Sponsored Resources

  • Inside Lightroom

Related to this Article

Understanding Oracle Clinical Understanding Oracle Clinical
by Joan M. Johnson
May 2007
$9.99 USD

Inside SQLite Inside SQLite
by Sibsankar Haldar
April 2007
$9.99 USD

Advertisement
O'Reilly Media

©2010, O'Reilly Media, Inc.
(707) 827-7000 / (800) 998-9938
All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners.
About O'Reilly
Academic Solutions
Authors
Contacts
Customer Service
Jobs
Newsletters
O'Reilly Labs
Press Room
Privacy Policy
RSS Feeds
Terms of Service
User Groups
Writing for O'Reilly
Content Archive
Business Technology
Computer Technology
Google
Microsoft
Mobile
Network
Operating System
Digital Photography
Programming
Software
Web
Web Design
More O'Reilly Sites
O'Reilly Radar
Ignite
Tools of Change for Publishing
Digital Media
Inside iPhone
makezine.com
craftzine.com
hackszine.com
perl.com
xml.com

Partner Sites
InsideRIA
java.net
O'Reilly Insights on Forbes.com