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 and running. Addionally any application that used TNS for connecting to the database would not work either.
oracle database - Find out the history of SQL queries - Stack …
Feb 12, 2013 · Get list of queries to oracle database. 0. Oracle Table Queried or Modified Date. 0.
How to enter special characters like "&" in oracle database?
Aug 29, 2016 · We can use another way as well for example to insert the value with special characters 'Java_22 & Oracle_14' into db we can use the following format.. 'Java_22 '||'&'||' Oracle_14' Though it consider as 3 different tokens we dont have any option as the handling of escape sequence provided in the oracle documentation is incorrect.
Checking oracle sid and database name - Stack Overflow
Oracle query command to check database name (or server host): select sys_context('userenv', 'server_host ...
oracle database - Difference between using a TNS name and a …
Apr 5, 2013 · SERVICE_NAME is a alias to a database instance (or many instances). The main purpose of this is if you are running a cluster. Using this we can connect specific database within a cluster. And other way, using SID (System IDentifier) we can connect to a database instance, which is a unique name for an Oracle database instance.
oracle database - Getting ORA-01031: insufficient privileges while ...
May 18, 2015 · If you are having trouble starting up Oracle, you may need to add the Oracle user to the dba group. For ORA-00942: table or view does not exist. You tried to execute a SQL statement that references a table or view that either does not exist, that you do not have access to, or that belongs to another schema and you didn't reference the table by ...
sql - Get list of all tables in Oracle? - Stack Overflow
Oct 15, 2008 · A new feature available in SQLcl( which is a free command line interface for Oracle Database) is. Tables alias. Here are few examples showing the usage and additional aspects of the feature. First, connect to a sql command line (sql.exe in windows) session. It is recommended to enter this sqlcl specific command before running any other commands ...
oracle database - ORA-28001: The password has expired - Stack …
1.open command prompt 2.type sqlplus 3.It will ask Enter Password, you can give old password, it will show password has expired ORA-28001 4.It will ask new password and retype password 5.It will change with new password 6.Go to the sql database …
oracle database - ORA-28000: the account is locked error getting ...
Login to SQL Plus client on the oracle database server machine. enter user-name: system. enter password: password [Only if, if you have not changed your default password while DB installation] press enter. after which, you will be seeing the connection status. Now, SQL> ALTER USER [USER_NAME] ACCOUNT UNLOCK; press enter.
What is the dual table in Oracle? - Stack Overflow
Sep 16, 2008 · The DUAL table is a special one-row table present by default in all Oracle database installations. It is suitable for use in selecting a pseudocolumn such as SYSDATE or USER The table has a single VARCHAR2(1) column called DUMMY that has a value of "X"