Initially Conncop creates a connection pooling with primary node in a RAC environment. If user make a request again conncop pool cache connections will be reuse, no new connection. Node goes down also conncop cache of connections will present untill instance get rebooted. In this case session will be terminated along with cache of connections. That's why after server rebooted we were unable to see that error
hi sir, first of all i need to thank you for sharing your experience and knowledge to us... my question is what will be the conection architecture of a oracle database which have both think clients and applications...will it be having dedicated server process for applications and a pool of shared server processes for think clients seperatly? Also can you give examples for think clients in real time.
Yeah its possible to have both... in such circumstances you will configure dedicated connections for connection pool and MultiThreaded sessions ( Shared Servers) for thick clients...
Hi sir , number of connections from application are more than size of connection pool which is effecting other applications which are connected to same database , what could be the issue here please help
Hi Sir, When 1000 request of same data is sent to the database server, it initiates login and perform operations within time, but it doesn't logout in allocated time (I,e in my case takes 5 minutes) .Atlast, It throws timeout error. Is it due to deadlock ? As we access same data in 1000 request. Is there a way to overcome it?
Hi Sir, I have a doubt We need pfile/spfile to start db. We need control file as well to start db. Pfile has all the parameters mentioned while control file has db physical details. So what is the difference between both? Y can't we maintain a single file.? This question arises as pfile has db name and unique name. Whereas control file also has db name.
Control file is a binary file whereas pfile is a text file. you can create a pfile even if you lose one, but control file is maintained by the server. Pfile is for instance to start and come to nomount state... after that the control file is read and instance gets to mount state and then the data files and redo log files are opened by the instance and the instance is open for users to work with their data.
How do the application verify the users? Even for verification it needs to check the credentials in DB I hope. Or else does it verify users by using these 10connection pools? Confused..!!
Hi Padala, very good question. When all application users connect to the application and get authenticated as application users maintained by the application( for which the application will have its own authentication mechanism), the DB User for all application users happens to be the same. Thus the database is unaware of who is the real user. Thats the problem with Connection pool... To overcome this.. you have solutions like maintaining a CLIENT_ID or APPLICATION_CONTEXT which are attributes of a database connection. Thus when an application uses one of the connections in the pool to perform an operation for an Application user say USER1, The application should append this information to the DB Connection attribute... thereby the database can be aware of the real application user. Which can be used to audit or other operations in the database where the real users should be known to the Database. Another way to identify the application user in the Database is by using Proxy connections... Hope this helps..
Very nice. I am using the same way.But some times i am getting Time out ocuured.The pool is probably full.any one can suggest me how to solve. Thanks in advance.
I prefer making the connection with the Oracle database with the help of ADO.NET data provider www.devart.com/dotconnect/oracle/. Has anyone tested out other vendors?
Ramkumar Swaminathan im sorry for bothering you,but in case if the tutorial concerned java code is available,then i can understand the concept in a better way.
This man is a serious legend.. 🔥🔥👌🏻❤️
Thank you for this best video. You explained the matter broadly that I got a full understanding on con pool. Wow!
Thank you very much, Sir. I was scraping the web for an explanation like this. Keep up the great work. you're helping many
Nicely explained. I really liked the way you said it 6:45
great video , Thanks a lot
nicely explained , like the way it is explained!!!
+Sain Singh thanks
You save my time..thanks
Thanks you Sir..Nice
Chad brought me here🙃
Thank you for the explanation, sir!
Respects
Initially Conncop creates a connection pooling with primary node in a RAC environment.
If user make a request again conncop pool cache connections will be reuse, no new connection.
Node goes down also conncop cache of connections will present untill instance get rebooted.
In this case session will be terminated along with cache of connections.
That's why after server rebooted we were unable to see that error
hi sir,
first of all i need to thank you for sharing your experience and knowledge to us...
my question is what will be the conection architecture of a oracle database which have both think clients and applications...will it be having dedicated server process for applications and a pool of shared server processes for think clients seperatly?
Also can you give examples for think clients in real time.
Yeah its possible to have both... in such circumstances you will configure dedicated connections for connection pool and MultiThreaded sessions ( Shared Servers) for thick clients...
Hello Sir, what in the case of, let us say if 10 connection drops for some reason is there some kind of Heartbeat mechanism pre configured?
Sir, very nice explanation, do you have any training lessons on JBOSS SERVER.
+Nazir Hussain not from me... Boy shall keep you posted if I find any good channel on jboss
Hi sir , number of connections from application are more than size of connection pool which is effecting other applications which are connected to same database , what could be the issue here please help
Hi Sir,
When 1000 request of same data is sent to the database server, it initiates login and perform operations within time, but it doesn't logout in allocated time (I,e in my case takes 5 minutes) .Atlast, It throws timeout error. Is it due to deadlock ? As we access same data in 1000 request. Is there a way to overcome it?
Hi Sir, I have a doubt
We need pfile/spfile to start db. We need control file as well to start db. Pfile has all the parameters mentioned while control file has db physical details. So what is the difference between both? Y can't we maintain a single file.?
This question arises as pfile has db name and unique name. Whereas control file also has db name.
Control file is a binary file whereas pfile is a text file. you can create a pfile even if you lose one, but control file is maintained by the server. Pfile is for instance to start and come to nomount state... after that the control file is read and instance gets to mount state and then the data files and redo log files are opened by the instance and the instance is open for users to work with their data.
Ramkumar Swaminathan thank you so much for the wonderful explanation 😊
Sir practiceal videos I need installation Linux in oracle
How do the application verify the users?
Even for verification it needs to check the credentials in DB I hope.
Or else does it verify users by using these 10connection pools?
Confused..!!
Hi Padala, very good question. When all application users connect to the application and get authenticated as application users maintained by the application( for which the application will have its own authentication mechanism), the DB User for all application users happens to be the same. Thus the database is unaware of who is the real user. Thats the problem with Connection pool... To overcome this.. you have solutions like maintaining a CLIENT_ID or APPLICATION_CONTEXT which are attributes of a database connection. Thus when an application uses one of the connections in the pool to perform an operation for an Application user say USER1, The application should append this information to the DB Connection attribute... thereby the database can be aware of the real application user. Which can be used to audit or other operations in the database where the real users should be known to the Database.
Another way to identify the application user in the Database is by using Proxy connections...
Hope this helps..
Ramkumar Swaminathan
Perfect Explanation..!!
Thanks for your time.
Most Welcome... Enjoy Learning...
how to find max pool count supported by oracle here?
Very nice. I am using the same way.But some times i am getting
Time out ocuured.The pool is probably full.any one can suggest me how to solve. Thanks in advance.
I prefer making the connection with the Oracle database with the help of ADO.NET data provider www.devart.com/dotconnect/oracle/. Has anyone tested out other vendors?
Even if you use ADO.NET... there will be options to configure connection specifications... Kindly take care of that...
Sir,Where is the java code for all tutorials uploaded anywhere.
NO code available...
Ramkumar Swaminathan im sorry for bothering you,but in case if the tutorial concerned java code is available,then i can understand the concept in a better way.
I guess in whole vedio you are talking about server connection pool not db connection pool