DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

I cant install oci8 on php7

0a28a4ba-c68b-4b91-b277-6f276b14383aDec 18 2015 — edited Jan 9 2016

Hello all,

Last 2 days I spend to install oci8 on php7 but without success.

I still cant see oci8 in phpinfo() however I see some information in php -i.

[root@ora ~]# php -i |grep oci8

oci8

oci8.connection_class => no value => no value

oci8.default_prefetch => 100 => 100

oci8.events => Off => Off

oci8.max_persistent => -1 => -1

oci8.old_oci_close_semantics => Off => Off

oci8.persistent_timeout => -1 => -1

oci8.ping_interval => 60 => 60

oci8.privileged_connect => Off => Off

oci8.statement_cache_size => 20 => 20

;

Can you please help?

Installation was performed to centos 6.5

PHP was installed via

https://webtatic.com/packages/php70/

OCI8 was installed

http://www.oracle.com/technetwork/articles/dsl/technote-php-instant-12c-2088811.html

[root@ora ~]# env |grep LD_LIBRARY_PATH

LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib

[root@ora ~]#

[root@ora ~]# ls -l /usr/lib/oracle/12.1/client64/lib

total 190200

lrwxrwxrwx. 1 root root 21 Dec 19 00:06 libclntshcore.so -> libclntshcore.so.12.1

-rw-r--r--. 1 root root 6990875 Jul 7 2014 libclntshcore.so.12.1

lrwxrwxrwx. 1 root root 17 Dec 19 00:06 libclntsh.so -> libclntsh.so.12.1

-rw-r--r--. 1 root root 58793741 Jul 7 2014 libclntsh.so.12.1

-rw-r--r--. 1 root root 1768370 Jul 7 2014 libipc1.so

-rw-r--r--. 1 root root 544150 Jul 7 2014 libmql1.so

-rw-r--r--. 1 root root 6213011 Jul 7 2014 libnnz12.so

lrwxrwxrwx. 1 root root 15 Dec 19 00:06 libocci.so -> libocci.so.12.1

-rw-r--r--. 1 root root 2576030 Jul 7 2014 libocci.so.12.1

-rw-r--r--. 1 root root 109549133 Jul 7 2014 libociei.so

-rw-r--r--. 1 root root 156353 Jul 7 2014 libocijdbc12.so

-rw-r--r--. 1 root root 337137 Jul 7 2014 libons.so

-rw-r--r--. 1 root root 118491 Jul 7 2014 liboramysql12.so

-rw-r--r--. 1 root root 3670975 Jul 7 2014 ojdbc6.jar

-rw-r--r--. 1 root root 3677511 Jul 7 2014 ojdbc7.jar

-rw-r--r--. 1 root root 311555 Jul 7 2014 ottclasses.zip

-rw-r--r--. 1 root root 35925 Jul 7 2014 xstreams.jar

[root@ora ~]# cat /etc/php.ini |grep -i oci

extension=/usr/lib64/php/modules/oci8.so

[OCI8]

; credentials (OCI_SYSOPER, OCI_SYSDBA)

; http://php.net/oci8.privileged-connect

;oci8.privileged_connect = Off

; Connection: The maximum number of persistent OCI8 connections per

; http://php.net/oci8.max-persistent

;oci8.max_persistent = -1

; http://php.net/oci8.persistent-timeout

;oci8.persistent_timeout = -1

; ping during oci_pconnect() to check the connection validity. When

; set to 0, each oci_pconnect() will cause a ping. Using -1 disables

; http://php.net/oci8.ping-interval

;oci8.ping_interval = 60

;oci8.connection_class =

;oci8.events = Off

; http://php.net/oci8.statement-cache-size

;oci8.statement_cache_size = 20

; http://php.net/oci8.default-prefetch

;oci8.default_prefetch = 100

; Compatibility. Using On means oci_close() will not close

; oci_connect() and oci_new_connect() connections.

; http://php.net/oci8.old-oci-close-semantics

;oci8.old_oci_close_semantics = Off

[root@ora ~]#

root@ora ~]# cat /etc/sysconfig/httpd |grep -v '^#'

export ld_library_path=/usr/lib/oracle/12.1/client64/lib

[root@ora ~]#

This post has been answered by 0a28a4ba-c68b-4b91-b277-6f276b14383a on Dec 18 2015

Jump to Answer

807574

there're some t-patches released since -21.

you need to contact tech support to get those.

you also need to "tune" the web server. The major one is to set the javaheapsize to 1 gig.

807574

Here is something I got from support on tuning the web server:

At a customer site we are running the webserver for the UWC running the following JVM options for 20 days without problems

<JVMOPTIONS>-Xms1536m</JVMOPTIONS>
<JVMOPTIONS>-Xmx1536m</JVMOPTIONS>
<JVMOPTIONS>-server</JVMOPTIONS>
<JVMOPTIONS>-XX:+UseParNewGC</JVMOPTIONS>
<JVMOPTIONS>-XX:ParallelGCThreads=2</JVMOPTIONS>

But this is on a Solaris 9 / SPARC.

807574

OS and hardware shouldn't make a differnce. Likely those will help, too.

807574

Jay is correct you need to call support and get the -23 patch version for uwc and the -42 patch rev for messaging. Both of the patches are T patches but they work in production. Just make sure that if you are not using ssl you set you configutil params for usessl for imap,pop,http to NO or else your messaging server will shutdown every 720 seconds. This only happens with the -42 patch. The -23 patch is safe as far as we can see.

807574

What route1 is talking about, is that we fixed a bug, where Messaging Server wasn't checking to see if SSL ports are working.

By default, we enable SSL, but if you don't install a certificate, SSL doesn't work.

Now, we check to see if that's working if it's turned on. If not, we try to restart, and on a cluster, will failover......

807574

Oh, yes. the -23 patch is safe, BUT, without the -42 patch, UWC can't get to Calendar anymore.

807574

Hey Jay --

Just went rounds with Sun inside sales -- attempting to license JES CommSuite in order to get support (and access to the tech-support only patches).

Essentially, no dice. As company with less than ten users, I can't justify spending min of $5,000 year just for licensing -- in order to get support.

Please check following thread:
http://supportforum.sun.com/sjes/index.php?t=msg&th=742&start=0&rid=17767&SQ=d3620791e3a9a9c7e2f58f8cbf1da831

Is this an "over sight" between Sun JES product mgmt and tech support (ie. offer software "free" to companies under 100 users -- but require support access in order to get latest patches in order to run software in production).

My take: the end-user oddities with UWC in JES 2005Q4 require fixes -- primary: many messages received from Outlook senders can't be read (displayed with [ndif!!]).

Thoughts and/or suggestions?? We are willing to PAY $$$ for incident pack -- but no one @ sun support will take my $$$.

-GA

807574

Well, I know that we do single-incident cases. Apparently Sales doesn't know that. You should be able to contact support directly, and open a case for $$.

In any case, the current "t-patches" will be eventually posted on sunsolve.sun.com, and available publically.

As to management's intentions, um, I think indeed, that's the direction they're going.

807574

Howdy -- Thanks JAY for the release insight.

Heads up that 118207-42 (messaging 4.03 patch) was recently posted to public sunsolve.

Any ideas when -23 (or later) UWC patch will be posted as well (for public download via Sunsolve)??

Thanks -Garrett

807574

Alas, the release of uwc patch -23 depends on folk I don't even know. . .

807574

Hello Jay -- happy holidays!!

Any ideas when updated UWC patch will be posted to sunsolve for public download (ie. -23 or later)??

Thanks -GA

807574

Sorry, my listening bugs don't go quite far enough to know. You can get it from Tech Support.

807574

Hey Jay --

that's the problem -- I can't get it from support.

I talked with local Sun Service rep -- in region. Sun entry point for annual support contract is $5000 (ie. 100 users @ 50/seat for Comm Suite).

$5k / year just to get a patch once and long while is too much for ten users.

The Sun service rep said the current strategy does not encourage sub-100 seat customers.... enough said.

thus, I was looking for end-around to get latest UWC patch release... -GA

807574

While I'm not going to get all moral on this forum, please understand:

1. I'm a Sun employee. Software licence fees and support charges pay my income.

2. this forum isn't for doing an "end run" around official support.,

3. If I gave out t-patches here, my personal livelyhood would be in jeopardy. I'm just not prepared to do that.

Yes, the software is now, "free". That means that unless you're willing to pay for a licence and for tech support, you must wait until patches become publically available for them. At least, we don't do as some other companies do, and come after you for using the product without a licence.

807574

Hey Jay -- I understand and appreciate your position. This is obviously an issue for "higher-up" decision and business strategy folks @ Sun Corp.

As for us, after eight years on Sun platform -- this is likely pushing us towards another solution.

Zimbra is the wave of future -- AJAX interface, opensource core components, LDAP-compliant Directory based. Webmail interface very similar to Google's GMAIL with integrated calendar as well -- you can search across mail, contacts, and events seamlessly. Will inlucde Outlook plugin and Crackberry/Treo wireless acces/sync. AND ..the kicker ... only $1k/year up to $50/users (early adopter price -- http://zimbra.com).

While it's unfortunate that Sun isn't helping their sub-100user customers, I'm looking at this as potentially good thing for us.

Thanks again for all your help over the years. -GA

1 - 15

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 6 2016

Added on Dec 18 2015

#oracle, #php

5 comments

13,440 views

DevOps, CI/CD and Automation

I cant install oci8 on php7

Comments

Post Details