oracle database - ORA-12154: TNS:could not resolve the connect ...
Oct 11, 2012 · 0 I had an issue at work. The oracle server was "patched" and one of the databases I use could not be connect via the TNSNames entry but via Basic connection. The …
oracle database - SQL Error: ORA-00942 table or view does not …
2 I am using Oracle Database and i had same problem. Eventually i found ORACLE DB is converting all the metadata (table/sp/view/trigger) in upper case. And i was trying how i wrote …
How do I resolve this "ORA-01109: database not open" error?
May 3, 2017 · 2 Open SQLPLUS and login with sys as sysdba. After that run alter pluggable database <<database_name>> open; This Worked for me .
How to check the maximum number of allowed connections to an …
Oct 2, 2008 · What's the best way, using SQL, to check the maximum number of connections that is allowed for an Oracle database? In the end, I would like to show the current number of …
How to check Oracle database for long running queries
Mar 7, 2009 · My application, which uses an Oracle database, is going slow or appears to have stopped completely. How can find out which queries are most expensive, so I can investigate …
sql - How do we check version of Oracle - Stack Overflow
Oct 1, 2014 · How do we check version of Oracle on which we are working? How do we check the version of the interface on which we are working? I have tried select v$ from version ;
Connecting to Oracle Database through C#? - Stack Overflow
Sep 24, 2012 · I need to connect to a Oracle DB (external) through Visual Studio 2010. But I dont want to install Oracle on my machine. In my project I referenced: System.Data.OracleClient. …
Checking oracle sid and database name - Stack Overflow
Checking oracle sid and database name Asked 14 years, 4 months ago Modified 4 years ago Viewed 910k times
How to list all the roles existing in Oracle database?
How to list all the roles existing in Oracle database? Asked 11 years, 10 months ago Modified 6 years, 10 months ago Viewed 281k times
database - How do I do a manual uninstall of Oracle ... - Stack …
Sep 17, 2008 · Sometimes my Oracle database on Windows gets hosed. How do I do a manual uninstall of Oracle?