xampp
XAMPPコントロールパネル起動時にエラー
20:13:59 [Tomcat] Problem detected! 20:13:59 [Tomcat] Port 8080 in use by "C:\oraclexe\app\oracle\product\11.2.0\server\BIN\tnslsnr.exe"! 20:13:59 [Tomcat] Tomcat WILL NOT start without the configured ports free! 20:13:59 [Tomcat] You need to uninstall/disable/reconfigure the blocking application 20:13:59 [Tomcat] or reconfigure Tomcat and the Control Panel to listen on a different port
原因
Apacheが使用するポート80が、すでにほかのソフトで使用されている。
対処
Apatcheが使用しているポートを変更した。
C:\xampp\apache\conf\httpd.conf を編集。下記２箇所
Listen 80 ServerName localhost:80
Windows10
Oracle 11g XE 無償版
OCIインストール
Version 12.1.0.2.0
Instant Client Package – Basic: All files required to run OCI, OCCI, and JDBC-OCI applications
|
|||
instantclient-basic-windows.x64-12.1.0.2.0.zip (72,416,242 bytes) (cksum – 1751087003)php.ini の編集
ociの機能を使う
;extension=php_oci8_12c.dll ; Use with Oracle Database 12c Instant Client
[OCI8]
; Connection: Enables privileged connections using external
; credentials (OCI_SYSOPER, OCI_SYSDBA)
; http://php.net/oci8.privileged-connect
;oci8.privileged_connect = Off
; Connection: The maximum number of persistent OCI8 connections per
; process. Using -1 means no limit.
; http://php.net/oci8.max-persistent
;oci8.max_persistent = -1
; Connection: The maximum number of seconds a process is allowed to
; maintain an idle persistent connection. Using -1 means idle
; persistent connections will be maintained forever.
; http://php.net/oci8.persistent-timeout
;oci8.persistent_timeout = -1
; Connection: The number of seconds that must pass before issuing a
; ping during oci_pconnect() to check the connection validity. When
; set to 0, each oci_pconnect() will cause a ping. Using -1 disables
; pings completely.
; http://php.net/oci8.ping-interval
;oci8.ping_interval = 60
; Connection: Set this to a user chosen connection class to be used
; for all pooled server requests with Oracle 11g Database Resident
; Connection Pooling (DRCP). To use DRCP, this value should be set to
; the same string for all web servers running the same application,
; the database pool must be configured, and the connection string must
; specify to use a pooled server.
oci8.connection_class =
; High Availability: Using On lets PHP receive Fast Application
; Notification (FAN) events generated when a database node fails. The
; database must also be configured to post FAN events.
;oci8.events = Off
; Tuning: This option enables statement caching, and specifies how
; many statements to cache. Using 0 disables statement caching.
; http://php.net/oci8.statement-cache-size
;oci8.statement_cache_size = 20
; Tuning: Enables statement prefetching and sets the default number of
; rows that will be fetched automatically after statement execution.
; 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
環境変数PATHに、OCI.dllへのパスを通す
Windowsアイコンを右クリック – システム – システム詳細 – 環境変数ボタンをクリック
画面下部のwindow内から、pathを見つけて編集ボタンをクリックしてパスを追加する
コメント