topic Re: Pro*C Install in Operating System - HP-UX

Pro*C Install

Sandy Chen — Thu, 24 May 2007 09:30:36 GMT

Hi All,

I've got Oracle 9i running on rx4640, hpux 11.23

Can anyone give me any documents on how to install Pro*C on my system?

Is the software depot downloadable from web? If yes, can anyone give me the links.

Regards,
Sandy

Re: Pro*C Install

James R. Ferguson — Thu, 24 May 2007 10:02:21 GMT

Hi Sandy:

The C/aCC+ compiler is a purchaseable product:

http://h20293.www2.hp.com/portal/swdepot/displayProductInfo.do?productNumber=B9007AA

An evaulation copy is available, though:

http://h20293.www2.hp.com/portal/swdepot/displayProductInfo.do?productNumber=B9007AAEVAL

Installation is nothing more than a 'swinstall' session.

Regards!

...JRF...

Re: Pro*C Install

Sandy Chen — Thu, 24 May 2007 10:21:28 GMT

Hi James,

Is this Pro*C is included in the C/aCC+ compiler?? What if I have HP ANSI/C Compiler? Is this product is also has Pro*C in it?

regards,
Sandy

Re: Pro*C Install

Patti Johnson — Thu, 24 May 2007 10:23:44 GMT

Sandy,

Pro*C is part of the Oracle distribution, but does not install as part of the Enterprise Edition installation. Start the Oracle installer, select custom installation, look for developer tools (not sure the exact name) and drill down for Pro*C.

You will also need to HP C compiler, but Pro*C is an Oracle product.

Patti

Re: Pro*C Install

Ben Dehner — Thu, 24 May 2007 10:59:19 GMT

Pro*C is a C pre-compiler that is part of Oracle. It may not be installed by default, so you'll have re-run the Oracle installer with a custom install. The component you'll want is the "Oracle 9i Development Kit". And if you've alread installed any Oracle patch sets or CPU's, you'll want to re-install them after installing a new Oracle component.

And, as I said, Pro*C is just a pre-compiler; it takes some custom Oracle marco-looking tags and generates the (ugly) C code required to use the Oracle OCI. But you will still need a back-end C compiler. I'd strongly recommend purchasing the HP ANSI-C compiler, but it is not strictly necessary. You can use the bundled C compiler on the system. If you can find it, you might be able to use the gcc compiler as well, but I've never tried this with Pro*C.

Re: Pro*C Install

Sandy Chen — Thu, 24 May 2007 21:32:28 GMT

Hi all,

Thanks for the replies. If I re-run the oracle installer, will it affect my current database? And for patching, is it necessary to re-patch the oracle again?

regards,
Sandy

Re: Pro*C Install

Oviwan — Fri, 25 May 2007 02:03:01 GMT

Hey

What would you exactly do? Have you already Oracle installed e.g. 9i and now you would install 10g and upgrade your db to 10g? If yes, you have to upgrade your instance also. follow the instrunction of the patch.

Regards

Re: Pro*C Install

Sandy Chen — Fri, 25 May 2007 02:09:07 GMT

Hi,

Actually my application guy wanted to create an email notification and they required pro*c installed, which is not for now. I don't want to upgrade the oracle. Just wanted to install the pro*c.

Regards,
Sandy

Re: Pro*C Install

Oviwan — Fri, 25 May 2007 02:26:54 GMT

Hey

check this metalink article for the hpux patches which are required. Note:169706.1

I would do it like that

1.DB Backup
2.Shutdown DB
3.Install Pro*c
4.startup db

I have never done this before.

Regards

Re: Pro*C Install

Ben Dehner — Fri, 25 May 2007 08:36:18 GMT

If you install the Oracle development tools then re-install the Oracle patch set, you won't have to re-patch the Oracle databases. Its just that, when installing a new Oracle component, all of the Oracle binaries in the same ORACLE_HOME should be of the same 9.2.0.X version. Pro*C might work anyway without re-installing the patch, but I'd suggest doing it because there probably are some Pro*C bugs that got patched.

However, it just occured to me, the Oracle patch installation might not run if you have running databases against the ORACLE_HOME, even if the components that you are patching have nothing to do with any running binaries.

Re: Pro*C Install

Yogeeraj_1 — Sat, 26 May 2007 00:59:31 GMT

hi Sandy,

If you are really concerned about your database and re-applying of patches. Then one alternative would be:

Install the additional software in another ORACLE_HOME

just my views.

good luck!

kind regards
yogeeraj

Re: Pro*C Install

Sandy Chen — Sat, 26 May 2007 12:23:36 GMT

Hi all,

Thanks for your input and suggestion. I'll try this things on my development server first. And thanks the idea to test it on another ORACLE_HOME, I'll try that one.

Regards,
Sandy