smallwei
4:04 pm on October 18, 2009 |
Answers: 1
Tags: database (51), database oracle (3), dbuser, devdb, error (67), oracle (136), oracle database (11), perl (7), protocol adapter, script (26) 
Loading ...Resolve “Couldn’t connect to the database Oracle DEVDB DBUSER – ORA-12557: TNS:protocol adapter not loadable (DBD ERROR: OCIServerAttach)”
When running perl script connecting to Oracle database, I was getting the following error: Couldn’t connect to the database Oracle DEVDB DBUSER – ORA-12557: TNS:protocol adapter not loadable (DBD ERROR: OCIServerAttach)
Fixing ORA-12154: TNS:could Not Resolve the Connect Identifier Specified.Resolve ORA-12505: Using Oracle RAC and Java JDBC Thin Client ConnectionResolve Symantec Backup Exec Unable to Connect to Oracle Database in WindowsResolve “no Packages Matching ‘DBD-Oracle’ Found” Error when Trying to Instal…
Resolve ORA-39000 ORA-31619 ORA-17500 Errors when Using Oracle Data Pump
smallwei 4:07 pm on October 18, 2009
There are three things you can check:
1. Make sure perl DBD is installed.
2. Make sure ENV Path is configured correctly. If you have Oracle Application Server (OAS) installed, there is an oci.dll file that came with it. Same thing with Oracle Client. Make sure you pick the correct one. (I use the one from Oracle Client)
3. Try reinstall DBD after setting the path correctly.