Error when trying to log in: ORA-12154
I am using Oracle 10g and PL/SQL Developer for the development. I have already tested from Net Manager that the database can be connected to, but when I tried to connect with PL/SQL Developer there was problem that I do not understand:
ORA-12154: TNS:could not resolve the connect identifier specified
I have already searched for solution for the problem but still it can't be resolved. Any advice?
Solution
This was a hard one. tnsping works. tnsnames.ora is correct. This post solved it for me: http://sambitimes.blogspot.de/2010/10/ora-12154-error-in-windows-7.html
If installation path of PL/SQL-Developer contains brackets, it screws up... This will not work with win7: "C:\Program Files (x86)\PLSQL Developer"
this does for me: "C:\Program Files\PLSQL Developer"
I hope it helps for others.
- Queue monitoring oracle script
- Date Time Format, Perl Oracle SQL
- Ansible playbook takes forever to execute an Oracle DB query
- Search All Fields In All Tables For A Specific Value (Oracle)
- Returning clause in json_table or skip error on error?
- Find a gap > 10min and select begin/end dates in timestamp logs
- Need to extract value from key-value pair data
- Simple OracleBulkCopy example erroneously prefixes my already qualified target table name with my own schema name
- Parsing JSON with Oracle SQL without knowing incoming field names
- Oracle SQL Developer doesn't start
- Alternatives for IN and NVL operators for classic report query
- List column name for user views in oracle
- Oracle Merge statement 'ON' vs 'UPDATE' conditions performance on target table
- Map table to exactly one of three
- Convert the total amount in words
- Oracle APEX - Create 'Duplicate' Button Next to the Report
- Log SQL parameter values when using spring-boot-starter-data-r2dbc for Oracle database (oracle-r2dbc)
- How do I pass a return code from an Oracle script back to the WINDOWS Batch script which called it?
- How to enter newline character in Oracle?
- Selecting from random column in PL/SQL
- What is the difference between complete refresh and fast refresh in materialized view?
- Split timeperiods by referring dates in another table
- Entity Framework Core automatically inserts double quotes in Oracle database
- How to remove duplicate rows from a join query in oracle?
- Oracle SQL how to get the group by columns along with other selected columns
- I want to choose hiredate between '20-FEB-81' AND '01-MAY-81'
- Access a Method in a PL/SQL Collection of Objects Using a Pipelined function
- How to query based on related tables and grouping the records as per the nearest range values?
- Substring between 2 strings in Oracle SQL
- Data type for encrypted content