oracle sql developer- ora-12514 error

sql oracle ora-12514
user3498706 picture user3498706 · May 6, 2014 · Viewed 40.7k times · Source

im using oracle sql developer to make my database, but now i stopped to work. it wrote this:

An error was encountered performing the requested operation:

Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

Vendor code 12514

i also tried to make new connection but it didnt help pls help me,i dont know what to do, i need this to do my homework

when i tried to change connection it wrote this:

An error was encountered performing the requested operation:

ORA-01031: insufficient privileges 01031. 00000 - "insufficient privileges" *Cause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges. When Trusted Oracle is configure in DBMS MAC, this error may occur if the user was granted the necessary privilege at a higher label than the current login. *Action: Ask the database administrator to perform the operation or grant the required privileges. For Trusted Oracle users getting this error although granted the the appropriate privilege at a higher label, ask the database administrator to regrant the privilege at the appropriate label. Vendor code 1031

Answer

Nistha Pandey picture Nistha Pandey · Sep 13, 2015

Please check the services are running: OracleOraDb11g_home1TNSListener and OracleServiceORCL.

Related questions

Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More
How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: select * from sometable order by name limit 20,10 to get the 21st to the 30th rows (skip the …

Read More
Oracle SQL: Update a table with data from another table

Table 1: id name desc ----------------------- 1 a abc 2 b def 3 c adf Table 2: id name desc ----------------------- 1 x 123 2 y 345 In oracle SQL, how do I run an sql update query that can update Table 1 with Table 2's name and desc using …

Read More