This may seem as weird question:
If i have user called demo
with password Pass1234
When connecting to oracle 11g I can run sqlplus
like this with password in command line:
on DB host:
C:\> sqlplus demo/Pass1234
Or remote machine
C:\> sqlplus demo/Pass1234@<ip>:1521/orcl
I can do so without give the password in command line and expose it like this:
C:\> sqlplus demo
Then I get:
SQL*Plus: Release 11.1.0.7.0 bla bla bla
Copyright (c) bla bla bla
Enter password:
Then I can enter the password manually.
When connecting to Oracle 12c I can connect like this from any machine (with password):
C:\> sqlplus demo/Pass1234@<ip>:1521/pdborcl
My question is: How to connect to Oracle 12c without tnsnames.ora
edit and without write the password in the command line?
I also havn't figured out yet if it is possible to connect to Oracle 12c from sqlplus on the DB host machine without give the IP or localhost, and without editing the tnsnames.ora, like I can do in Oracle 11g?
And more thing, can I do so from a remote machine (even to Oracle 11g) without using a full connect?
(means to give user and db connection in command line and password manually, not like use /NOLOG
in command and then: SQL> connect demo/Pass1234@<ip>:1521/pdborcl
)
Thanks!
sqlplus username@\"db_machine:1521/db_servicename\"
sqlplus username
won't connect me to a user schema on 12c because it located on pdb, it will try to connect me to the core of the default DB, and there is no such as user at the core. in 11g it will connect me to that user on the default DB(there's no core nor pdb, just db). I would call it a difference. sorry if it was not clear from my question.