search
HomeBackend DevelopmentPHP Tutorialpdo连接oracle时报错

pdo连接oracle时报错

Jun 23, 2016 pm 01:51 PM
oraclepdoReport an errorconnect

之前一直是在自己的pc上开发,现在要转移到服务器上了。程序拷到服务器上后运行,在创建pdo对象时出错,报could not find driver。查了php.ini 能打开的都打开了,甚至后来把我自己pc上的考到了服务器上,还是不行。之后查了phpinfo,我自己的pc上pdo driver已经启用了oci,但是服务器上就没有,忘了还需要做什么了。。望大神提示一下。。。


回复讨论(解决方案)

安装 oracle 客户端

补充一下 服务器上没装oracle。是需要装客户端才可以吗?

无论 oracle 服务器在哪,都需要装客户端才可以

那你的 oracle 在哪?在你的 PC 上?
不关机?

无论 oracle 服务器在哪,都需要装客户端才可以

那你的 oracle 在哪?在你的 PC 上?
不关机?

嗯。。正在下客户端。我的oracle在我的pc上啊,关机什么意思。。。。正常关啊。。。

安装 oracle 客户端


大哥,我手头上有instantclient_11_2可以吗?这东西怎么用啊?我只是在用plsql时候引用了它的文件夹

我按照我pc上的,把instantclient_11_2下面三个o开头的dll文件复制到apache/bin下了,现在在phpinfo -> pdodrivers里能看到oci了,改提示TNS no listener 12541错误了

oracle在你的pc上,而应用在服务器上。
你把 pc 关了,服务器上的应用还能工作吗?

instantclient_11_2 是客户端安装程序吧?运行它一路确认就可以了

不能像你那样复制文件,因为与注册表相关
TNS no listener 12541 是监听未启动
你都没有 oracle 服务器,还怎么监听?

不知道的的 oracle 是从哪来的,现在 oracle 大客户版本的光盘很容易就下载到了。里面什么都有

oracle在你的pc上,而应用在服务器上。
你把 pc 关了,服务器上的应用还能工作吗?

instantclient_11_2 是客户端安装程序吧?运行它一路确认就可以了

不能像你那样复制文件,因为与注册表相关
TNS no listener 12541 是监听未启动
你都没有 oracle 服务器,还怎么监听?

不知道的的 oracle 是从哪来的,现在 oracle 大客户版本的光盘很容易就下载到了。里面什么都有


pc没关,俩都开着呢,我这个程序不是一直挂着,就用一次。oracle的客户端也安了,还是一样的提示。我pc本地运行这个程序就没问题,pc装的是oracle11g+instantclient_11_2+plsql,从官网下的。好烦,当时就弄了好久。。。
Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
How to make PHP applications fasterHow to make PHP applications fasterMay 12, 2025 am 12:12 AM

TomakePHPapplicationsfaster,followthesesteps:1)UseOpcodeCachinglikeOPcachetostoreprecompiledscriptbytecode.2)MinimizeDatabaseQueriesbyusingquerycachingandefficientindexing.3)LeveragePHP7 Featuresforbettercodeefficiency.4)ImplementCachingStrategiessuc

PHP Performance Optimization Checklist: Improve Speed NowPHP Performance Optimization Checklist: Improve Speed NowMay 12, 2025 am 12:07 AM

ToimprovePHPapplicationspeed,followthesesteps:1)EnableopcodecachingwithAPCutoreducescriptexecutiontime.2)ImplementdatabasequerycachingusingPDOtominimizedatabasehits.3)UseHTTP/2tomultiplexrequestsandreduceconnectionoverhead.4)Limitsessionusagebyclosin

PHP Dependency Injection: Improve Code TestabilityPHP Dependency Injection: Improve Code TestabilityMay 12, 2025 am 12:03 AM

Dependency injection (DI) significantly improves the testability of PHP code by explicitly transitive dependencies. 1) DI decoupling classes and specific implementations make testing and maintenance more flexible. 2) Among the three types, the constructor injects explicit expression dependencies to keep the state consistent. 3) Use DI containers to manage complex dependencies to improve code quality and development efficiency.

PHP Performance Optimization: Database Query OptimizationPHP Performance Optimization: Database Query OptimizationMay 12, 2025 am 12:02 AM

DatabasequeryoptimizationinPHPinvolvesseveralstrategiestoenhanceperformance.1)Selectonlynecessarycolumnstoreducedatatransfer.2)Useindexingtospeedupdataretrieval.3)Implementquerycachingtostoreresultsoffrequentqueries.4)Utilizepreparedstatementsforeffi

Simple Guide: Sending Email with PHP ScriptSimple Guide: Sending Email with PHP ScriptMay 12, 2025 am 12:02 AM

PHPisusedforsendingemailsduetoitsbuilt-inmail()functionandsupportivelibrarieslikePHPMailerandSwiftMailer.1)Usethemail()functionforbasicemails,butithaslimitations.2)EmployPHPMailerforadvancedfeatureslikeHTMLemailsandattachments.3)Improvedeliverability

PHP Performance: Identifying and Fixing BottlenecksPHP Performance: Identifying and Fixing BottlenecksMay 11, 2025 am 12:13 AM

PHP performance bottlenecks can be solved through the following steps: 1) Use Xdebug or Blackfire for performance analysis to find out the problem; 2) Optimize database queries and use caches, such as APCu; 3) Use efficient functions such as array_filter to optimize array operations; 4) Configure OPcache for bytecode cache; 5) Optimize the front-end, such as reducing HTTP requests and optimizing pictures; 6) Continuously monitor and optimize performance. Through these methods, the performance of PHP applications can be significantly improved.

Dependency Injection for PHP: a quick summaryDependency Injection for PHP: a quick summaryMay 11, 2025 am 12:09 AM

DependencyInjection(DI)inPHPisadesignpatternthatmanagesandreducesclassdependencies,enhancingcodemodularity,testability,andmaintainability.Itallowspassingdependencieslikedatabaseconnectionstoclassesasparameters,facilitatingeasiertestingandscalability.

Increase PHP Performance: Caching Strategies & TechniquesIncrease PHP Performance: Caching Strategies & TechniquesMay 11, 2025 am 12:08 AM

CachingimprovesPHPperformancebystoringresultsofcomputationsorqueriesforquickretrieval,reducingserverloadandenhancingresponsetimes.Effectivestrategiesinclude:1)Opcodecaching,whichstorescompiledPHPscriptsinmemorytoskipcompilation;2)DatacachingusingMemc

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

SublimeText3 English version

SublimeText3 English version

Recommended: Win version, supports code prompts!

Safe Exam Browser

Safe Exam Browser

Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

SecLists

SecLists

SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

PhpStorm Mac version

PhpStorm Mac version

The latest (2018.2.1) professional PHP integrated development tool