Error "ORA-12154: TNS:could not resolve the connect identifier specified" accuring while logging in as "sys as sysdba" with password . But then I read an article saying that,"admin privilages let's a sysdba login without a password." and I tried that and immediately got connected to sql server . Can anyone tell me why this happened ? and why login with password isn't working with this .
I inatalled Oracle db 19c and login as user sys as sysdba the error,"ORA-12154: TNS:could not resolve the connect identifier specified" accured
1.5k Views Asked by Paras Bartwal At
1
There are 1 best solutions below
Related Questions in DATABASE
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- How to not load all database records in my TListbox in Firemonkey Delphi XE8
- microsoft odbc driver manager data source name not found and no default driver specified
- Cloud Connection with Java Window application
- Automatic background scan if user edit column?
- Jmeter JDBC Connection Configuration Parametrization of Database URL for accessing SQL Database
- How to grant privileges to current user
- MySQL: Insert a new row at a specific primary key, or alternately, bump all subsequent rows down?
- Inserting and returning autoidentity in SQLite3
- Architecture: Multiple Mongo databases+connections vs multiple collections with Express
- SQL - Adding a flag based on results within a query - best practice?
- Android database query not returning any results
- Developing a search and tag heavy website
- Oracle stored procedure wrapping compile error with inline comments
- Problems communicating with mysql in php
Related Questions in ORACLE
- Column displays each count
- MAX and GROUP BY - SQL
- Best Practice for adding columns to a Table in Oracle database
- Updating an Oracle row with value from same row
- Retrieving data from Oracle database
- Ibatis execute update sql on oracle, it is not working and no exceptions
- Building an sql execution plan history
- Implementation of Rank and Dense Rank in MySQL
- how to update the date field for this specific condition using oracle query?
- Oracle stored procedure wrapping compile error with inline comments
- Android: How to connect oracle database using Android Java code?
- SQL Conditional Join on Columns
- Multi value wildcard search in ibatis
- Get count of consecutive days meeting a given criteria
- How to update the metadata of a layer in Oracle imported through FME Workbench?
Related Questions in SQLPLUS
- Ignoring User Exists Error in Oracle
- In Oracle 11g how do you time weight average data hourly between two dates?
- ORA-06502 Error Only in SQLPLUS
- Connect to two DB using Oracle wallet without TNS_ADMIN path change
- Which tables do not have indexes in Oracle?
- Why is SPOOL writing my output with LINESIZE set to 32767?
- accented letters and sql plus/AIX
- How to know what SETS are ON in SQL PLUS?
- Installing rlwrap on linux - without root permission
- Hide SQL > statements in the spool file
- SQL*Plus spool only data and exclude errors
- Recover error WshShell.exec
- How to log queries taking long time
- How to specify tablespace_name in SQLPlus Oracle select
- Write to a file in PL/SQL without spools or utl_file
Related Questions in RDBMS
- Hierarchical RDBMS Query spanning across multiple tables with in clause
- Why I can't perform this simple insert operation? How can I solve this date format issue?
- How to import only new data by using Sqoop?
- Making relational algebra equations in a sample database
- adding a where condition for one criteria in sql query
- What happens to sql views, if database is moved to another server
- Why I can't perform this insert query if a specific field value is set to null?
- Star schema role in the Pentaho Mondrian OLAP server
- Can Rails deal with DB uniqueness without index?
- Max. number of subqueries with WHERE clause in MySQL
- How to maintain author order in database of citations
- What is the difference between a Technical key and a Surrogate key?
- Why django group by wrong field? annotate()
- mysql: Get combination of data from multiple table by passing multiple value
- How to organize data in document based stores?
Related Questions in SYSDBA
- Access table user in sysdba privilege
- Unable to login to Sqlplus as sysdba: "ORA-01031: insufficient privileges"
- Reg: sysdba not logging, system user and other user connecting
- Changing SYSDBA user password in InterBase
- I inatalled Oracle db 19c and login as user sys as sysdba the error,"ORA-12154: TNS:could not resolve the connect identifier specified" accured
- Firebird/Interbase - create new user/view without SYSDBA
- ORA-01031: insufficient privileges while connecting with sys as sysdba
- Django Oracle connection as SYS should be as SYSDBA or SYSOPER
- group two tables result without duplicate results
- "sysdba" login in Sql Server 2014? Why?
- java.lang.SecurityException: policy table update SYS:JAVA.LANG.RUNTIMEPERMISSION, GETCLASSLOADER
- Oracle 12c pluggable database won't start
- Restrict user to use ‘conn /as sysdba’ from OS Level
- Grant DBA role to a user in cloud
- Login as SYS user to Oracle 11g from .NET
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
When you specify
sqlplus sys as sysdbawith the correct ORACLE_SID environment variable set from the DB server, Oracle uses OS-authentication to authenticate sys and BEQ protocol (no network) to connect. That's why it would work without a password.Connecting to
sqlplus sys/password@tnsname as sysdbaconnects across a network (your error indicates that your tnsname wasn't resolved) and requires that a separate password file be configured for authentication. See here: https://docs.oracle.com/database/121/ADMIN/dba.htm#ADMIN11056