[oracle@rac2 ~]$ sqlplus sys@localhost:1521/pdborcl.localdomain as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 21 10:39:12 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
Enter user-name:
This error is generated by the fact that in easy connect string the password must be specified also or if the password is not specified the connect string should enclosed in double quotes.
First case, without password specified:
[oracle@rac2 ~]$ sqlplus sys@\"localhost:1521/pdborcl.localdomain\" as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 21 10:41:30 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
SYS:localhost:1521/pdborcl.localdomain SQL>
In this case the \ is the escape character for double quotes.
Second case, with password in connect string:
[oracle@rac2 ~]$ sqlplus sys/Passw0rd@\"localhost:1521/pdborcl.localdomain\" as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 21 10:41:56 2015
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, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
SYS:localhost:1521/pdborcl.localdomain SQL>
SQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 21 10:39:12 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
Enter user-name:
This error is generated by the fact that in easy connect string the password must be specified also or if the password is not specified the connect string should enclosed in double quotes.
First case, without password specified:
[oracle@rac2 ~]$ sqlplus sys@\"localhost:1521/pdborcl.localdomain\" as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 21 10:41:30 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
SYS:localhost:1521/pdborcl.localdomain SQL>
In this case the \ is the escape character for double quotes.
Second case, with password in connect string:
[oracle@rac2 ~]$ sqlplus sys/Passw0rd@\"localhost:1521/pdborcl.localdomain\" as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 21 10:41:56 2015
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, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
SYS:localhost:1521/pdborcl.localdomain SQL>
No comments:
Post a Comment