Skip to main content
Share Your Experience: Take the 2024 Developer Survey
2 votes
Accepted

How to make sqlplus parse stdin?

Short answer: sqlplus cannot do this. It reads [Oracle] SQL statements and executes them. As far as I know, "10334" is not [the start of] a valid SQL statement. Two possibilities: Use SQL ...
Phill  W.'s user avatar
  • 8,815
1 vote

sqlplus / as sysdba Connected to an idle instance

When you use @pdbname, you are using TNS to connect through the listener, which creates a shadow process with an environment correctly set up (thanks to listener.ora) to attach to the instance (which, ...
Paul W's user avatar
  • 633
1 vote

Unable to connect to Oracle user in pluggable database

from the output of listener-status above, I see that PDB1 is a known service for you listener. means a connect: sqlplus uer/pwd@PDB1 'should' work. You have configuered security, using a wallet. Are ...
Dieter H. aus B.'s user avatar
1 vote
Accepted

Unable to connect to Oracle user in pluggable database

-- without specifying service_name, you will connect to the CDB (root con) SQL>connect u/p<NOTHING_HERE> -- the service_name 'PDB1' will be made available when pdb is created SQL>!lsnrctl ...
Bjarte Brandt's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible