pdo连接oracle时报错
之前一直是在自己的pc上开发，现在要转移到服务器上了。程序拷到服务器上后运行，在创建pdo对象时出错，报could not find driver。查了php.ini 能打开的都打开了，甚至后来把我自己pc上的考到了服务器上，还是不行。之后查了phpinfo，我自己的pc上pdo driver已经启用了oci，但是服务器上就没有，忘了还需要做什么了。。望大神提示一下。。。
回复讨论(解决方案)
安装 oracle 客户端
补充一下 服务器上没装oracle。是需要装客户端才可以吗？
无论 oracle 服务器在哪，都需要装客户端才可以
那你的 oracle 在哪？在你的 PC 上？
不关机？
无论 oracle 服务器在哪，都需要装客户端才可以
那你的 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，从官网下的。好烦，当时就弄了好久。。。
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
Function to calculate the number of days between two dates in oracle
May 08, 2024 pm 07:45 PM
The function in Oracle to calculate the number of days between two dates is DATEDIFF(). The specific usage is as follows: Specify the time interval unit: interval (such as day, month, year) Specify two date values: date1 and date2DATEDIFF(interval, date1, date2) Return the difference in days
How long will Oracle database logs be kept?
May 10, 2024 am 03:27 AM
The retention period of Oracle database logs depends on the log type and configuration, including: Redo logs: determined by the maximum size configured with the "LOG_ARCHIVE_DEST" parameter. Archived redo logs: Determined by the maximum size configured by the "DB_RECOVERY_FILE_DEST_SIZE" parameter. Online redo logs: not archived, lost when the database is restarted, and the retention period is consistent with the instance running time. Audit log: Configured by the "AUDIT_TRAIL" parameter, retained for 30 days by default.
The order of the oracle database startup steps is
May 10, 2024 am 01:48 AM
The Oracle database startup sequence is: 1. Check the preconditions; 2. Start the listener; 3. Start the database instance; 4. Wait for the database to open; 5. Connect to the database; 6. Verify the database status; 7. Enable the service (if necessary ); 8. Test the connection.
How to use interval in oracle
May 08, 2024 pm 07:54 PM
The INTERVAL data type in Oracle is used to represent time intervals. The syntax is INTERVAL <precision> <unit>. You can use addition, subtraction, multiplication and division operations to operate INTERVAL, which is suitable for scenarios such as storing time data and calculating date differences.
How to see the number of occurrences of a certain character in Oracle
May 09, 2024 pm 09:33 PM
To find the number of occurrences of a character in Oracle, perform the following steps: Get the total length of a string; Get the length of the substring in which a character occurs; Count the number of occurrences of a character by subtracting the substring length from the total length.
Oracle database server hardware configuration requirements
May 10, 2024 am 04:00 AM
Oracle database server hardware configuration requirements: Processor: multi-core, with a main frequency of at least 2.5 GHz. For large databases, 32 cores or more are recommended. Memory: At least 8GB for small databases, 16-64GB for medium sizes, up to 512GB or more for large databases or heavy workloads. Storage: SSD or NVMe disks, RAID arrays for redundancy and performance. Network: High-speed network (10GbE or higher), dedicated network card, low-latency network. Others: Stable power supply, redundant components, compatible operating system and software, heat dissipation and cooling system.
How much memory does oracle require?
May 10, 2024 am 04:12 AM
The amount of memory required by Oracle depends on database size, activity level, and required performance level: for storing data buffers, index buffers, executing SQL statements, and managing the data dictionary cache. The exact amount is affected by database size, activity level, and required performance level. Best practices include setting the appropriate SGA size, sizing SGA components, using AMM, and monitoring memory usage.
How to replace string in oracle
May 08, 2024 pm 07:24 PM
The method of replacing strings in Oracle is to use the REPLACE function. The syntax of this function is: REPLACE(string, search_string, replace_string). Usage steps: 1. Identify the substring to be replaced; 2. Determine the new string to replace the substring; 3. Use the REPLACE function to replace. Advanced usage includes: multiple replacements, case sensitivity, special character replacement, etc.
