oracle database - ORA-12154: TNS:could not resolve the connect ...
Oct 11, 2012 · 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 Database was up and admin could see it was up …
oracle database - Find out the history of SQL queries - Stack Overflow
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 exact …
Newest 'oracle-database' Questions - Stack Overflow
4 days ago · It takes about 40 seconds to connect to the Oracle database using JDBC, but similar code in C# using the OracleConnection.Open method completes in less than 1 ...
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 Oracle_14. …
How to get SID, Service Name and Port for Oracle database?
Jun 8, 2018 · I have oracle database running on address xx.xx.xx.xx I know login, password and initial catalog I am trying to set up new connection in Oracle SQL Developer so I can access this database …
Checking oracle sid and database name - Stack Overflow
Checking oracle sid and database name Asked 14 years, 6 months ago Modified 4 years, 1 month ago Viewed 912k times
oracle database - ORA-12170: TNS:Connect timeout occurred - Stack …
May 31, 2014 · I was trying to connect to the database here in my laptop using Oracle Toad but I kept on having this error: ORA-12170: TNS:Connect timeout occurred What are the possible reasons why I …
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 further?
How do I delete a columns from a large Oracle database?
Apr 16, 2024 · Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production I read about SET UNUSED, but it seems like it's the same thing? Rather, it will not physically clear the table …
database - How do I do a manual uninstall of Oracle ... - Stack Overflow
Sep 17, 2008 · Sometimes my Oracle database on Windows gets hosed. How do I do a manual uninstall of Oracle?