Hello, In my last company i was using oracle 9i on windows 7-64 bit OS environment (just 3-month back). But now i am facing this problem "jrew.exe has stopped working". And everybody is saying its not supported to this environment but when how it was working on my last experience. I want to install this db in any case and it will use for very basic requirements.Please guide me
Instant Client ODBC requires the Oracle Instant Client Basic or Basic Light package (depending on your locale requirements) also be installed. Download the desired package from OTN for your operating system and follow the installation instructions on the download page. For example, unzip the package to C:\instantclient_19_3 on Windows, unzip to /opt/oracle/instantclient_19_3 on Linux or other platforms, or use yum to install the RPM packages on Linux.
oracle 9i database free download for windows 7 64 bit
DOWNLOAD: https://shurll.com/2vzu7u
To speed up downloads, get the base installation ( jdev9032_base.zip). I am using Oracle Support provides customers with access to more than one million knowledge articles as well as an active support community made up of friends along with Oracle experts. For the user named ora32, I was unable to join the database using an error like this. Get More Softwares From Getintopc
I am trying since 3 days to install an oracle database on my windows machine running windows 7 64bit enterprise and then using "SQL developer" to manage and query local databases. AT latesr stage maybe I will get Toad.
If you downloaded Power BI Desktop from the Microsoft Store, you might be unable to connect to Oracle databases because of an Oracle driver issue. If you encounter this issue, the error message returned is: Object reference not set. This is an issue with how Oracle driver works in Windows UWP Apps. To address the issue, you have to do the following:
Note: For 9.2.0.4 patchset installation, you will run into the problem described above. The solution does not work in 9.2.0.4 installation. You need to run the runInstaller that came with the 9.2.0.4 patchset then you should be able to install the oui 2.2.0.18.0 and the 9.2.0.4 patchset. This apply to the 9.2.0.4 client installation as well. Requires kernel parameter changes:
Merge the following entries into the /etc/sysctl.conf file then run /sbin/sysctl -p to apply them to the running kernel. fs.file-max = 65536 kernel.sem = 250 320000 100 1024 kernel.shmmax = 2147483648 kernel.shmmni = 4096 kernel.shmall = 2097152 net.ipv4.ip_local_port_range = 1024 65000 Set the File Handles limit and the process limit:
ulimit -n 65536 ulimit -u 16384 For RedHat AS3 and Oracle 9.2.0.x:
Install the following RPMs if they're not already installed (Oracle Note:252217.1): compat-db-4.0.14-5.i386.rpm compat-gcc-7.3-2.96.122.i386.rpm compat-gcc-c++-7.3-2.96.122.i386.rpm compat-libstdc++-7.3-2.96.122.i386.rpm compat-libstdc++-devel-7.3-2.96.122.i386.rpm openmotif21-2.1.30-8.i386.rpm setarch-1.3-1.i386.rpm tcl-8.3.5-92.i386.rpm Relink gcc and g++ so that version 2.96 will be used for during installation (Oracle Note:252217.1) mv /usr/bin/gcc /usr/bin/gcc.orig mv /usr/bin/g++ /usr/bin/g++.orig ln -s /usr/bin/gcc296 /usr/bin/gcc ln -s /usr/bin/g++296 /usr/bin/g++ Apply patch p3006854_9204_LINUX.zip from the repository: cd /tmp unzip /repos1/Lnx/ora-patch-lnx-9.2.0.4-RHAS3/p3006854_9204_LINUX.zip cd 3006854 sh rhel3_pre_install.sh This is a hack to make the installer work: export LD_ASSUME_KERNEL=2.4.1 Install 9.2.0.2 from the CDs as documented below. You will encounter two link failures during the install. Just click ignore, they will be corrected by applying the 9.2.0.4 patch. Unpack and install the 9.2.0.4 patchset: cd /tmp unzip /repos1/Lnx/ora-patch-lnx-9.2.0.4-RHAS3/p3095277_9204_LINUX.zip cpio -idmv su - oracle export LD_ASSUME_KERNEL=2.4.1 cd /tmp/Disk1 ./runInstaller Select Oracle Universal Installer 2.2.0.18.0 as the product to be installed. When complete, exit the installer. cd $ORACLE_HOME/bin ./runInstaller Now select Oracle9iR2 Patch Set 3 9.2.0.4.0 as the product to be installed. You will encounter yet another link failure. Click ignore. Unpack the following two patches: su - oracle cd /tmp unzip /repos1/Lnx/ora-patch-lnx-9.2.0.4-RHAS3/p2617419_210_GENERIC.zip unzip /repos1/Lnx/ora-patch-lnx-9.2.0.4-RHAS3/p3119415_9204_LINUX.zip cd 3119415 export PATH=$PATH:/sbin:/tmp/OPatch opatch apply Set gcc and g++ back to what they were: mv /usr/bin/gcc.org /usr/bin/gcc mv /usr/bin/g++.orig /usr/bin/g++ Now you can use dbca to create a test database INSTALLATION INSTRUCTIONS:
Also note: At this point you should have already copied Default_Oracle 9i_Psoft_Template.dpt to the $ORACLE_HOME/assistants/dbca/templates directory (done just prior to running root.sh). Use this template to create the database: Select Create a Database (1 of 8). Pick Template (2 of 8). Use the "Default_Oracle 9i_Psoft_Template", copied from the repository. Check Global Database and SID (3 of 8). Global Database should be txxxx.peoplesoft.com (where txxxx is test901 or ts90164). SID should be test901 (32bit) or ts90164 (64bit). Check Database Options (4 of 8). Check Database Features (5 of 8). Be sure the following is de-selected: Oracle Ultra Search Example Schemas First unclick HR, Sales History. For "Delete tablespace?", answer "yes". There are currently no custom scripts. For Additional Database Configurations, be sure the following is de-selected: Oracle JVM Oracle Intermedia For "Delete tablespace?", answer "yes". Check Server Mode (6 of 8). It should be Dedicated Server Mode. Check Initialization Parameters (7 of 8). Leave memory, archive, and db sizing (8 k) as is. The Database Character Set (on DB Sizing screen) should be WE8ISO8859P1; National character set should be "AL16UTF16". And don't change file locations. For Oracle 9.2.0 - Click on 'All Initialization Parameters' box and change the value for compatibles from 9.0.0 to 9.2.0, and close screen. For Database Storage (8 of 8), update the File Location Variables to include mountpoints where the test database will reside. For example: ORACLE_MNT1 /ds1 ORACLE_MNT2 /ds2 . . (etc.) For Control files, change locations to ORACLE_MNT#/oradata/..... For Tablespaces (doubleclick on what you want to change): For CWMLITE: Change size to 100 K; change directory location from ORACLE_BASE to ORACLE_MNT#/oradata/.... For UNDOTBS: Change size to 300 MB; change directory location from ORACLE_BASE to ORACLE_MNT#/oradata/.... For the other tablespaces, change directory location from ORACLE_BASE to ORACLE_MNT#/oradata/.... Leave the sizing as is. For Datafiles you may have duplicate entries of datafiles under 2 different locations. Highlight & remove the entries that begin with file location variable of ORACLE_BASE. Keep those entries which use ORACLE_MNT#. . IMPORTANT: If you highlight an ORACLE_BASE-located datafile and it really shows it to be ORACLE_MNT# in the details section on the right, then don't delete it. Talk to Jerry. For Redo Log Groups (1.2 & 3) change location from ORACLE_BASE to ORACLE_MNT#/oradata/.... Enter "Finish". Click "o.k." to create the database. If you get an error "don't have enough disk space to create database under /", be sure you have an "oradata" directory (with oracle:dba as owner:group) created under /data#, or wherever the test database will reside.
Be aware that this script is a bit buggy. If the kernel extension is already loaded into the kernel, this script will unload it without notifying you and the install will fail. cd /jukebox1/oracle 9i version ./rootpre.sh A couple useful commands on IBM (see the Oracle Installation Guide for IBM): /etc/loadext -r (to find version currently loaded) /etc/loadext -v /etc/pw-syscall (to determine version of the kernel extension) /etc/loadext -q /etc/pw-syscall (to determine whether the kernel extension is loaded) /etc/loadext -l /etc/pw-syscall (to manually load the kernel extension into the kernel....sometimes the "rootpre.sh" script doesn't do this, so it may need to be done manually) /etc/loadext -u /etc/pw-syscall ( to verify if the kernel extension is loaded. If not then run the above command to manually load it). For all platforms, as oracle: cd /jukebox1/oracle 9i version ./runInstaller Choose the following during the install process: At the Welcome screen, click next. At the File Location screen, make sure Destination? is from $ORACLE_HOME and click next. At the Available Products screen, select Oracle 9i Client 9.0.1.0.0 and click next. At the Installation Types screen, select Custom and click next. At the Available Products Components screen: Expand Oracle Programmer and deselect the following options under it: Object Type Translator Pro*C Pro*Cobol Pro*Fortran Sql*Module Ada Deselect Oracle Enterprise Manager Products (everything underneath it should be deselected). Deselect the following options: Oracle Advanced Security (be sure this is deselected!) Oracle Universal Installer Oracle 9i for Unix Documentation Oracle HTTP Server Oracle Ultra Search Middle-Tier At the Summary screen, review as necessary, click install. For Oracle 9.0.1, you'll be prompted for the location of the next CDs. Enter the full pathname of jukebox location... (for example: "/jukebox1/ora-svr-platform-version-cd2of3") You will be prompted to run root.sh. ** NOTE: During the client installation (9.0.1 32-bit), if an error message window displays with "Error in Writing file $ORACLE_HOME/ldap/odi/conf/exportLdif.map.master", do the following workaround as this is a known bug from Oracle: open a new window session and cd to $ORACLE_HOME/ldap/odi/conf directory chmod +w * back to the installation window and "Retry" repeat the same steps if the problem persists. Leaving the installer running, open another window and do the following: Log into the server as root. Set the ORACLE_HOME variable. Then cd $ORACLE_HOME. ./root.sh Put scripts in /usr/lbin. Once root.sh finishes, click on o.k. on the installer screen. Next the Configuration Tools screen appears. This automatically brings up the Net 8 Configuration Assistant screen. Enter the following for Net 8 Configuration: Click next. Click No to defer configuration of a directory service. For Naming Methods, use the default of Local (don't select hostname). For the version of Oracle database for which Net Service Name will be used, answer: Oracle 8 release 8.0 database or service. For Database SID: ts90164 For Protocol, use TCP/IP and click next. For hostname, enter pt-ibm08. Also use the standard port of 1521. Answer Yes to perform a test. You should get "test did not succeed". Click on "Change Login" and use system/manager. It should now say "Connecting....test successful." For Net Service Name, enter PT815P02 and click next. For Configure another net service name?, answer NO. Click next at least 3 times. Click finish (to finish the Net8 Configuration) and exit the Client installation. After the Connectivity installation, be sure to modify the sqlnet.ora file, as follows: cd $ORACLE_HOME/network/admin/sqlnet.ora cp sqlnet.ora sqlnet.ora.orig vi sqlnet.ora and comment out the entry specifying the domain, as shown below: # NAMES.DEFAULT_DOMAIN = peoplesoft.com Special links that need to be done at end of install: One last step to do is to make the following 32bit link in order for the PeopleSoft Applications to work properly:
SUN cd $ORACLE_HOME/lib32 ln -s $ORACLE_HOME/lib32/libclntsh.so.9.0 libclntsh.so.8.0 HP cd $ORACLE_HOME/lib32 ln -s $ORACLE_HOME/lib32/libclntsh.sl.9.0 libclntsh.sl.8.0 Compaq Tru64 cd $ORACLE_HOME/lib ln -s $ORACLE_HOME/lib/libclntsh.so.9.0 libclntsh.so.8.0 The following are special instructions for listener.ora, tnsnames.ora and oratab. 2ff7e9595c
Comments