ORA-01017: invalid username/password; logon denied..
oracle@generic ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Sun Nov 20 07:08:07 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
[oracle@generic ~]$ echo $TWO_TASK
ORCL
Unset this variable TWO_TASK <<<<<<<<<<<<<<<<
[oracle@generic ~]$ unset TWO_TASK
[oracle@generic ~]$ echo $TWO_TASKS
[oracle@generic ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Sun Nov 20 07:20:15 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>
===========
[oracle@localhost ~]$ ps -ef|grep -i smon
oracle 1970 1 0 05:00 ? 00:00:00 db_smon_FREE
oracle 6247 6193 0 06:26 pts/2 00:00:00 grep --color=auto -i smon
[oracle@localhost ~]$ . oraenv
ORACLE_SID = [FREE] ?
The Oracle base remains unchanged with value /opt/oracle
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Sun Sep 10 06:26:33 2023
Version 23.2.0.0.0
Copyright (c) 1982, 2023, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid credential or not authorized; logon denied
[oracle@localhost ~]$ echo $TWO_TASK
FREEPDB1
[oracle@localhost ~]$ unset TWO_TASK ---- unset
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Sun Sep 10 06:28:14 2023
Version 23.2.0.0.0
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Connected to:
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0
SQL>
====
connect to user
sqlplus hr/hr@//192.168.0.70:1521/freepdb1
SQL*Plus: Release 23.0.0.0.0 - Production on Tue Nov 7 11:46:00 2023
Version 23.3.0.23.09
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Last Successful login time: Wed Sep 13 2023 19:50:31 +00:00
Connected to:
Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.3.0.23.09
SQL> def
DEFINE _DATE = "07-NOV-23" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "//192.168.0.70:1521/freepdb1" (CHAR) <<<<<<<<<<<<---
DEFINE _USER = "HR" (CHAR)
DEFINE _PRIVILEGE = "" (CHAR)
DEFINE _SQLPLUS_RELEASE = "2303002309" (CHAR)
DEFINE _EDITOR = "vi" (CHAR)
DEFINE _O_VERSION = "Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.3.0.23.09" (CHAR)
DEFINE _O_RELEASE = "2303002309" (CHAR)
SQL>
SQL> show user
USER is "HR"
SQL>
2 comments:
[oracle@anuj ~]$ env|grep -i task
TWO_TASK=ORCL
[oracle@anuj ~]$ unset TWO_TASK
[oracle@anuj ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>
TWO_TASK
This Oracle environment variable specifies the default remote Oracle service. When this variable is defined, the connector connects to the specified database by using an Oracle listener that accepts connection requests. This variable is for use on Linux and UNIX only.
Use the LOCAL environment variable for Microsoft Windows.
If both ORACLE_SID and TWO_TASK or LOCAL are defined, TWO_TASK or LOCAL takes precedence.
Post a Comment