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 …
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 ;
oracle database - Find out the history of SQL queries - Stack …
Feb 12, 2013 · An update SQL query was executed on the server, which caused many problems later. How can I get the list of update queries executed in last 2 months, so that I can trace the …
How to enter special characters like "&" in oracle database?
Aug 29, 2016 · INSERT INTO STUDENT(name, class_id) VALUES ('Samantha', 'Java_22 & Oracle_14'); If I try to run this query I am getting a popup and it asks me to enter value for …
sql - Query to get Oracle DB version - Stack Overflow
Jan 23, 2021 · Query to get Oracle DB version Asked 4 years, 9 months ago Modified 8 months ago Viewed 72k times
Checking oracle sid and database name - Stack Overflow
Checking oracle sid and database name Asked 14 years, 5 months ago Modified 4 years ago Viewed 911k 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?
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 .