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
- How to add the dynamic new rows from my registration form in my database?
- How to store a date/time in sqlite (or something similar to a date)
- Problem with add new attribute in table with BOTO3 on python
- When an E-R attribute should be perceived as a relationship attribute or as an entity set attribute?
- SQLAlchemy: efficient relationship loading in 3-way many-to-many relationship
- Cannot connect to Postgres Database when running Quarkus Tests with Gitlab ci
- Local or remote database with react-native?
- I want to edit a specific row in database
- How to enter data in mongodb array at specific position such that if there is only 2 data in array and I want to insert at 5, then rest data is null
- Open Web Library
- database login.py and register.py error showing 404 file not found and doesn't work
- SQL71561: SqlComputedColumn: When column selected
- Liquibase as SaaS To Configure Multiple Database as Dynamic
- Updated max input vars but table still shows error
- Spring does not map set of roles
Related Questions in ORACLE
- sqlplus myusername/mypassword@ORCL not working with Oracle on Docker
- Oracle setting up on k8s cluster using helm charts enterprise edition
- Oracle Managed Data Access Client can't work from IIS but work for local debug environment
- If composite indexing created - indexing is called?
- Oracle Http server ISNT-07551
- why here not creating table?
- Data migration from Oracle Database Clob to GCP Bucket
- SQL Alchemy custom type, forcing blob bind parameter
- How to send message to syslog agent in plsql
- Whatever the data available in previous record it should add to the new record
- I have an Oracle SQL query that is giving me a "ORA-00918: column ambiguously defined" error on a line that is a comment line
- 'ORA-12170: TNS:Connect timeout occurredORA-12170: TNS:Connect timeout occurred' ERROR while working on oracle with laravel
- Is their any way i can open parallel query tabs
- VSCode Libraries not showing for New Java Project
- I can't ssh to my instance, Connection refused
Related Questions in SQLPLUS
- sqlplus myusername/mypassword@ORCL not working with Oracle on Docker
- Editor in SQLPLUS gives error when changing default editor
- sqlplus pointing to libclntsh.so.21.1 which does not exists in $ORACLE_HOME/lib
- SP2-0734:Unknown command beginning "CONSTRAINT..."
- I am not able to understand why I am getting this type of an output in SQLPlus. If someone could help me out with this it would be great
- How to add new line in sqlplus within a bash script?
- can't login via sqlplus command but manual login works
- Error appearing while creating a table in my class in oracle 21c
- Does PostgreSQL have a feature like 'Ampersand Substitution' in SQL*Plus?
- Oracle - Load local/client file to blob column
- Merge statement into table creates duplicates?
- Running .sql script file from sqlplus succeeds, but passing the sql string as standard input of sqlplus fails with SQL> SP2-0734 in powershell
- Check oracle db mode as another user faling
- ERROR: ORA-12154: TNS:could not resolve the connect identifier specified (First time installation)
- Remove initial and trailing blank line in SQL *Plus SPOOL (SET MARKUP CSV)
Related Questions in RDBMS
- Prisma Many to Many relationship with at least one value
- Precedence of operators in SQL
- How do I create columns that add a tag if it matches with a keyword from a different dataset?
- Does replacing string column with repeating values at some point with an int FK have any performance benefits in RDBMS?
- How will Spring boot work with Sql Response?
- How to replicate the "Script as Create" functionality from Azure Data Studio in python using pyodbc?
- How to properly connect GCP Cloud Functions with Relational Databases
- Unable to run pg_buffercache_pages() function
- Does it make sense to continue looking for comparison table where I could see the difference between completely different DB types?
- Extracting values from JSON list
- Difference between local, session and shared preload library in PostgreSQL and use of LOAD command
- Google Android Management API - mapping Map<K,V> fields
- What is the design logic for postgresql to not provide the construct as 'create database IF NOT EXISTS dbname'?
- RDBMS Many To Many Relationships Django
- How many entity tables should I have? User table attribute role or three tables for the roles?
Related Questions in SYSDBA
- Using Ansible how to connect Oracle DB on Linux & run command "show pdb" to display oracle pluggable DB, "shutdown immediate" to stop DB and start DB
- How do i connect to database using 'sqlplus / as sysdba' rather than 'sqlplus sys/<password> as sysdba'?
- Oracle - unable to create DB link
- Reg: sysdba not logging, system user and other user connecting
- Grant DBA role to a user in cloud
- 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
- Changing SYSDBA user password in InterBase
- Ora-01031: insufficient privileges when I create the first user
- How can I change/create the sysdba password for firebird 3.0 embedded
- Can a non sysdba compile dbms_session?
- regarding oracle database "sysdba" user and creating a new user
- Execute sql statement as sys as sysdba
- Oracle 12c pluggable database won't start
- java.lang.SecurityException: policy table update SYS:JAVA.LANG.RUNTIMEPERMISSION, GETCLASSLOADER
- how to specify DBA role while connecting to Oracle DB from a spring boot application
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