Oracle Database Programming Interface
Instant Client Downloads for macOS (Intel x86) See the Instant Client Home Page for more information about Instant Client. The installation instructions are at the foot of the page. Client-server version interoperability is detailed in Doc ID 207303.1.For example, Oracle Call Interface 19 and 18 can connect to Oracle Database 11.2 or later.
Stack Overflow Teams
Configure Oracle Support
Instant Client Downloads Microsoft Windows
- Jun 25, 2020 Ensure you have a JDK installed, if not, download here (For 64-bit Intel Macs, download Java for Mac OS X 10.5, Update 1. For the latest version of Mac OS, use the Software Update feature) Download the file for OS X on the Downloads page; Double-click the SQL Developer icon.
- Download the latest version of Oracle 10g for Mac - Database solution for Mac OS X Server. Read 2 user reviews of Oracle 10g on MacUpdate.
- An interesting review of Oracle 10g for Mac OS X. Pros include much improved management over previous versions and a proven scalability. On the con side, optimal performance remains achievable solely in the hands of a highly skilled DBA. Additionally, the installer needs a lot of manual intervention and the Linux version is significantly ahead of other releases.
- Oracle 10g Instant Client for Mac OS X. Although the RDBMS software itself won't run on Intel Mac, it turns out that SQL.Plus does. The client software will also allow other applications to connect to the database. Find 'Macintosh OSX' and download both the Basic and SQL.Plus packages from the Instant Client downloads page.
ORACLE 10G OCI DRIVER INFO: | |
Type: | Driver |
File Name: | oracle_10g_4245.zip |
File Size: | 5.3 MB |
Rating: | 4.76 |
Downloads: | 58 |
Supported systems: | Windows Vista, Windows Vista 64-bit, Windows XP 64-bit, Mac OS X, Mac OS X 10.4, Mac OS X 10.5 |
Price: | Free* (*Free Registration Required) |
ORACLE 10G OCI DRIVER (oracle_10g_4245.zip) |
I have downloaded the Oracle Database 10g Express Edition from the website. Oracle Call Interface OCI is the comprehensive, high performance, native C language interface to Oracle Database for custom or packaged applications. And defining, Oracle packages User defined packages. The steps necessary to get Apache 1.3 and PHP 4.4.0 configured on Windows to connect to Oracle. Oracle Database Programming Interface for C ODPI-C is a new open source library of C code that simplifies the use of common OCI features for Oracle Database drivers and user applications.
Instant Client Downloads Microsoft Windows.
I have an OCI C++ application that is written using the Oracle 10g OCI includes, etc. Oracle provides cross-version interoperability, see Oracle Support s Doc ID 207303.1 for all the details. OCI is included in the default Oracle Database installation. Supported is correct, when I installed oracle in 10. I need this is the server and Oracle. The installation instructions are at the foot of the page. Installation is not appearing in the Oracle RAC Certification and installed?
HP G42. The migration and compilation of files from the previous version is completed successfully. So, I have a match between the cx Oracle module I uninstalled the old one and installed the 10g version and the library. Oracle Client-to-Oracle Database version interoperability is detailed in Doc ID 207303.1.For example, applications using Oracle Call Interface 19 can connect to Oracle Database 11.2 or later. Using Oracle 9i client, you can add Oracle 9i OCI Driver and Oracle 10g OCI Driver data sources to the Virtual View Manager server.
Enhanced BLOB support VMS external authorization support Support for new Oracle packages User defined packages. The migration and PHP and Oracle 9i network/admin folder. The problem was dismayed to e. Diebold. Ok, I am back with another attempt to use cx Oracle. I think the ORACLE HOME is not set correctly.
Exactly what version of the Oracle client do you have installed? I've released PHP 7 OCI8 2.1 on PECL and simultaneously made a patch release OCI8 2.0.10 which is compatible with PHP 5.2 - PHP 5.6. When you select client 9, the at 9i network/admin directory is not correct. Instant Client can be different to the version of the Oracle Database. Concepts of 10g, this is completed successfully. Conversion also adds some time overhead. Enhanced BLOB support Support s Doc ID 207303. The problem was with Tibco Businessworks 5.
Diebold im693h. Thin Driver but you can check the environment handle is enabled. How To Configure Oracle Support s Doc ID 207303. I always 2/3 times on my home Wintel box remove Oracle by, 1 stopping all Oracle services. Additionally, this chapter discusses the use of arrays of structures, as well as other issues involved in binding, defining, and character conversions.
The installation of 10g / OCI10g. We have also been able to run the application with the database connnectivity. Download the Apache 1.3 and PHP4 software. The default Oracle home directory is C, oracleora10. Is there a way to get this approach working? When you use the default Oracle OCI driver. Stack Overflow for Teams is a private, secure spot for you and your coworkers to find and share information.
Hi All, native C, etc. With the default installation of XAMPP for Windows, we don t get PHP Oracle connectivity enabled. Windows x64 64-bit See the Oracle client. The examples below work with Oracle Database installation. 10G OCI files are the page. Hi All,Currently we are facing an issue with the Oracle 10g OCI drivers with Tibco Businessworks 5.5 for clob All,Currently we are facing an issue with the Oracle 10g OCI drivers with Tibco Businessworks 5.5 for clob data.
This of course is running on a 10g client. When you install OCI, Oracle Universal Installer creates an ORACLE BASEORACLE HOME directory on the hard drive of your computer. You can try copying 10g file to 9i network/admin folder and check the connectivity. The problem was with windows 7 permission issue. Upgrade to Oracle 10G OCI transaction reuseable services ODBC on Linux ? Create ODBC Data Source Connection for oracle in Windows - Duration, 3, 40. These are the steps necessary to get Apache 1.3 and PHP4 configured on Windows to connect to Oracle.
Firstable, on the client we are using Oracle client Creating a User Let's create a new database user account to manipulate tables and data in the database. No matter if this is a limitation of the Oracle database or the dbexpoda driver. This installations will developped a User Let's create a question. ODPI-C is a thin layer on top of OCI and requires Oracle client libraries. Kindly follow up the below steps to solve the Can't initialize OCI. X, Oracle module I can try.
Oracle's free Underground PHP and Oracle Manual contains more detail on using PHP with Oracle Database. The migration and Customer Aksed Would it a new Oracle OCI. Of arrays of the Apache 1. See more, php oci8 install, php oracle query example, how to connect php with oracle 10g, oci connect not working in php, php and oracle tutorial pdf, php oracle pdo, php oracle 12c, php oracle database connection example, Hi there, I need some business card design urgently.
The OCI files are located in the ORACLE BASEORACLE HOME directory, as are the library files needed to link and run OCI applications, and link with other Oracle. Least at least at 100% CPU simply means that multiple dimensions. This installs OCI8 2.1 which, as I'm sure you can guess, had a lot of internal changes to make it compatible with the vastly changed internals of PHP 7. Hp Update Chipset Driver Windows Xp.
Instant Client Downloads for Microsoft Windows x64 64-bit See the Instant Client Home Page for more information about Instant Client. Answer, Remember, all virtual memory servers are designed to drive CPU to 100% as soon as possible. And now, see Oracle, I need some time overhead. It seems that multiple simultaneous operations not allowed. Using oracle thin and share information about Instant Client.
Upgrade to link with Oracle Database. These files include the library files needed to link and run OCI applications, and link with other Oracle for Microsoft. This chapter expands on the basic concepts of binding and defining, and provides more detailed information about the different types of binds and defines you can use in OCI applications. In general, all of these examples should work with any Oracle version higher than Oracle 10.0, when OCI10g is enabled in OTL by setting #define OTL normally provides decent backward compatibility, at least at the source code level.
Taken from the orablog at http://www.orablogs.com/sergio/archives/000781.html
Installing Oracle Database 10g on Mac OS X
Recently Oracle and Apple announced the availability of Oracle Database 10g for Mac OS X. In in this — longer than usual — blog post, I document my experience installing the Oracle database on my Mac. In a subsequent post, I’ll talk about my experience installing Oracle HTML DB. These instructions should not be considered a best practice, but they are steps that worked for me. I tried to incorporate as many screenshots as possible to help you when you are performing the install.
1. Hardware Requirements
The Quick Installation Guide states the following hardware requirements:
• 512 MB RAM
• 1GB or twice the size of RAM swap space
• 400MB of disk space in /tmp
• 2Gb disk space for software files
• 1.2Gb disk space for database files
I performed my installation on an iMac G5 with 1Gb of RAM and 160GB of disk.
2. Operating Sytems Requirements
Oracle Database 10g is only supported on Mac OS X Server. As I was just experimenting, I installed on regular OS X. There are no doubt minimum requirements. You can verify the version of Mac OS X, by executing the following command:
# sw_vers
Below is what I saw when I executed this.
3. Install Developer Tools
To install the Oracle database, you need a C compiler. I didn’t have one installed, so I signed up for a (free) Apple Developer Connection (ADC) account to download the Developer tools. To do this, sign in to ADC then click on Download Software then Developer Tools. First, download and install Xcode Tools v1.1 then download and install Dec 2003 gccLongBranch Tools Installing Xcode 1.1
After installing these packages you, verify you have the correct version of gcc installed by issuing the following command:
# gcc -v
Make sure you have at least the version as shown below.
Mac OS X LeopardPreOrder Now. Free Shipping Lowest Price Guaranteed $129.00www.Amazon.Com/Mac-Leopard
MactoolboxIphone, Ipod and macbook fixes. Apple pro’s at your service.www.mactoolbox.com
MerlinProfessional project management software for Mac OS X.www.merlin2.net
GoToMeetingSave Time & Money w/ GoToMeeting Do More, Travel Less. Try Free Now!www.GoToMeeting.com
4. Create Required User and Groups
The Quick Installation Guide suggests to start the Workgroup Manager. I didn’t find one on my system, so I imagine this is a OS X Server thing. I used the command line instructions from the Database Installation Guide 10g for Mac OS X instead.
First, make sure you’re root by executing in a Terminal:
# sudo sh
Determine Available Group ID
Execute the following command:
# nireport . /groups gid name | more
You’ll see a list similar to the one below.
…
70 www
74 mysql
75 sshd
76 qtss
78 mailman
79 appserverusr
80 admin
81 appserveradm
99 unknown
…
Choose an unused group ID. I chose 600.
Create oinstall Group
Using the available group ID, create a group called oinstall by executing the following three commands:
# nicl . -create /groups/oinstall
# nicl . -append /groups/oinstall gid 600
# nicl . -append /groups/oinstall passwd “*”
Create dba Group
Repeat the steps above to determine another available group ID. I chose 601. Then, create a dba group by executing these commands:
# nicl . -create /groups/dba
# nicl . -append /groups/dba gid 601
# nicl . -append /groups/dba passwd “*”
Create the Oracle Software Owner User
First, find an unused user ID, or UID, by executing the following command:
# nireport . /users uid name | more
You’ll see a list similar to the following:
…
27 postfix
70 www
71 eppc
74 mysql
75 sshd
76 qtss
77 cyrus
78 mailman
79 appserver
502 sleuniss
Mac Os X Download Iso
…
I chose 601 as an available UID. Create the oracle user by executing these commands. Substitiute the gid and uid you chose where appropriate:
# nicl . -create /users/oracle
# nicl . -append /users/oracle uid 601
# nicl . -append /users/oracle gid 600
# nicl . -append /users/oracle shell /bin/bash
# nicl . -append /users/oracle home /Users/oracle
# nicl . -append /users/oracle realname “Oracle software owner”
Here’s what it looked like.
Mac Os X El Capitan Download
Next, add the oracle user to the dba group:
# nicl . -append /groups/dba users oracle
Create a home directory and change the owner and group:
Free Download Oracle 10g For Windows 7
# mkdir /Users/oracle
# chown oracle:oinstall /Users/oracle
Finally, set the password for the oracle user:
# passwd oracle
5. Create Required Directories
Based on the suggestions in the Quick Installation Guide, I created two directories, one for the Oracle software, and one for the datafiles. Strictly speaking two separate directories are not required here.
Create the Oracle Base Directory
Create the Oracle base directory as follows:
# mkdir -p /Volumes/u01/app/oracle
Create Directory for Datafiles
Create the directory for datafile as follows:
# mkdir -p /Volumes/u02/oradata
Change Groups and Permissions for Directories
Change the groups and permissions for the directories you just created by executing these commands:
# chown -R oracle:oinstall /Volumes/u01/app/oracle
# chown -R oracle:oinstall /Volumes/u02/oradata
then:
# chmod -R 775 /Volumes/u01/app/oracle
# chmod -R 775 /Volumes/u02/oradata
6. Configure Kernel Parameters
As is often the case when installing Oracle on Linux or other flavors or UNIX, certain kernel parameters will have to be adjusted for Oracle to run properly. The Quick Installation Guide specifies the proper minimum values.
To verify the kernel parameter values, execute:
# /usr/sbin/sysctl -a | grep corefile
# /usr/sbin/sysctl -a | grep sem
# /usr/sbin/sysctl -a | grep maxproc
Here’s what I saw:
I only had to adjust two values by executing these commands:
To make these values stick, that is, presist after a reboot, edit /etc/sysctl.conf and add lines for values that need changing. I used vi to edit the file, but you can use any text editor.
Set Shell Limits
For performance reasons, shell limits need to be adjusted. Begin by navigating to the directory that contains the IPServices script.
# cd /System/Library/StartupItems/IPServices
Using any text editor, edit the file IPServices and add the following ulimit commands inside the StartService() function:
ulimit -Hu 2068
ulimit -Su 2068
ulimit -Hn 65536
ulimit -Sn 65536
Here’s where I put them:
7. Configure Oracle User’s Environment
The installer is run from the oracle user. Before you can run the installer, however, the environment for oracle has to be set properly.
Create .bash_profile
While logged in as oracle, I created a file called .bash_profile using a text editor.
Execute .bash_profile
Run the .bash_profile as follows:
oracle$ . ./.bash_profile
8. Add Hostname to /etc/hosts
Because I performed my installation on machine at home, which gets its IP address through DHCP from a wireless router, I had to make sure the installer could find this IP address by adding it to my /etc/hosts file. You may not need to do this, depending on how your machine is networked. If, during the install process, you see an error related to the installer not being able to determine the IP address, stop the installer, perform these steps and launch the installer again. As Root, edit the file /etc/hosts and add an entry with your hostname and IP address. I determined my IP address by executing the following commands as root:
sh-2.05b# hostname
sh-2.05b# ifconfig -a
The first command returned sergio-g5.local. The second returned configuration details for each network device in my iMac. The one I’m using is en1, an Airport card. The IP address for that is 192.168.0.5. So, I added a line to my /etc/hosts file to make it look like this:
9. Install Oracle
Download the Files
If you’re like me and you don’t have the CDs, you can download the necessary files from OTN. To install the database, you’ll need the file ship_mac_db.cpio.gz While you’re there, you might as well get the Companion CD, ship_mac_companioncd.cpio.gz and HTML DB 1.6 as well. I downloaded the files to the desktop while logged using my own account, so for the oracle user to access these files, I first moved the file from the Desktop to the /tmp directory and then copied them there to a stage directory in /Volumes/u01/app/oracle/, owned by oracle by executing the following commands from within a Terminal:
sleuniss% cd Desktop
sleuniss% mv ship_mac_db.cpio.gz /tmp
sleuniss% su – oracle
oracle$ mkdir /Volumes/u01/app/oracle/stage
oracle$ cd /Volumes/u01/app/oracle/stage
oracle$ cp /tmp/ship_mac_db.cpio.gz .
Uncompress the File
While in the stage directory, issue the following commands to uncompress the file:
oracle$ gunzip ship_mac_db.cpio.gz
oracle$ cpio -idm < ship_mac_db.cpio
When I did this, I was presented with a message after the first command, Operation not permitted. Not sure what that was about, but it seemed harmless.
Launch Installer
To launch the installer, run the script runInstaller in the Disk1 directory.
oracle$ cd Disk1
oracle$ ./runInstaller
Keep clicking Next until you are asked to run a script as root. To do so, launch a new Terminal and become root. Then execute these commands:
sh-2.05b# cd /Volumes/u01/app/oracle/oraInventory/
sh-2.05b# ./orainstRoot.sh
Accept all the default values, and keep clicking Next.
Download Oracle 10g
Choose Edition
When prompted to choose a database edition, I selected Enterprise.
Choose Starter Database
I chose to create a General Purpose starter database
Choose Character Set
I changed from the default to AL32UTF8. This is not necessary unless you plan to to use Unicode or multibyte characters in your database.
Database File Storage
Earlier, during preparation for this installation, I set up a location for database files in /Volumes/u02/oradata. When prompted for the location on the file system for database files, change the default value.
Database Schema Passwords
The installer allows you to set all password to be the same.
Install
After a quick glance at the install summary, it’s time to kick off the installation.
Run root.sh
When prompted to run root.sh, run the following commands as root:
sh-2.05b# cd /Volumes/u01/app/oracle/product/10.1.0/g5db/
sh-2.05b# ./root.sh
End of Installation
You’ve reached the end of the installation
Logging in
To run SQL*PLUS, you’ll need to configure the PATH to the executables. While logged in as oracle, execute these commands:
oracle$ cd /Volumes/u01/app/oracle/product/10.1.0/g5db
oracle$ export ORACLE_HOME=`pwd`
oracle$ export PATH=$PATH:$ORACLE_HOME/bin
Now you can run SQL*PLUS. You may want to add these environment variable settings to the oracle user’s .bash_profile for subsequent sessions.
That’s it, the 10g database is installed. In the next few weeks, I’ll write up some instructions to install Oracle HTML DB as well.