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!

Cannot Connect to Oracle 9i DB Server

452573Nov 7 2006 — edited Nov 6 2013

Hi,

My problem is, I cannot connect to Oracle 9i DB Server. I tried to run the php_info() and it displays: 

OCI8 Support enabled 
Version 1.2.2 
Revision $Revision: 1.322 $ 
Active Persistent Connections 0 
Active Connections 0 
Temporary Lob support enabled 
Collections support enabled 

Directive Local Value Master Value 
oci8.default_prefetch 10 10 
oci8.max_persistent -1 -1 
oci8.old_oci_close_semantics 0 0 
oci8.persistent_timeout -1 -1 
oci8.ping_interval 60 60 
oci8.privileged_connect Off Off 
oci8.statement_cache_size 20 20 

I've got this from error.log in apache server. 

PHP Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that PATH includes the directory with Oracle Instant Client libraries in C:\\EID_Web\\Exercises\\connect_to_oracle.php on line 14 

PHP Warning: ociparse() expects parameter 1 to be resource, boolean given in C:\\Web\\connect_to_oracle.php on line 15 

PHP Warning: ociexecute() expects parameter 1 to be resource, null given in C:\\Web\\connect_to_oracle.php on line 16 

PHP Warning: ocifetch() expects parameter 1 to be resource, null given in C:\\Web\\connect_to_oracle.php on line 22 

PHP Warning: ocifreestatement() expects parameter 1 to be resource, null given in C:\\Web\\connect_to_oracle.php on line 32 

PHP Warning: ocilogoff() expects parameter 1 to be resource, boolean given in C:\\Web\\connect_to_oracle.php on line 33 

By the way, I'm using apache server version 2.2.3 and PHP/5.2.0RC6-dev running on windows 2000 as our web server. We have a remote Oracle9i DB Server. 
Thanks in advance for the help.

Alex Keh-Oracle

Answer

The current async implementation, task-based, is the third .NET iteration for asynchronous programming models. Before task-based async, there was event-based pattern and the async programming model. .NET async programming patterns have been around since near the beginning of .NET FW itself. And the reason why these async models have changed over time is because there was never a popular async model until the most recent iteration.

And therein lies the reason why ODP.NET has taken a wait and see approach. Async .NET programming is not new, but historically it had never gone mainstream.

With that said, Oracle is working on supporting task-based async. We'll have more details during Oracle OpenWorld in September.

Marked as Answer by OnurGumus · Sep 27 2020

OnurGumus

Dear Alex,

I disagree with your below comment:

" Async .NET programming is not new, but historically it had never gone mainstream."

As of now except Oracle, all database vendors that support .NET, also support proper asynchronous API.

Alex Keh-Oracle

Hi Onur,

What I meant by that statement was that the event-based pattern and the async programming model were not popular among .NET developers and eventually abandoned by Microsoft. Vendors who devoted much effort to supporting those earlier two models had to invest yet again in async with the task-based async pattern. Oracle has approached supporting a new async pattern relatively cautiously when noting the history.

user12186381

Hi Alex,

Any plans to make the async make GA?

I see that we have a pre-release available, but clearly states that should be used in Production Environments.

I'm just waiting for the final release to start using it in our projects.

Thanks,

Alex Keh-Oracle

ODP.NET Async is part of 23c client. When 23c DB goes GA, the client will also be GA.

The plan is to have DB 23c GA in the first half of 2024.

1 - 5

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 4 2013

Added on Nov 7 2006

#php

7 comments

22,030 views

DevOps, CI/CD and Automation

Cannot Connect to Oracle 9i DB Server

Comments

Post Details