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>
1 comment:
[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>
Post a Comment