Jason Yu
asked on
why i cannot use sqlplus schemaname/password to connect to the database
I have an oracle 10g database running. I want to connect to a specific schema in one command like below. It prompts me "event not found". If I use the "sqlplus" then input schema name and password step by step, it works great. How could I resolve this?
thanks.
thanks.
[oracle@lom-dbstg-01 ~]$ sqlplus SURVEYREPORTRESULTS/P!n3app!3
-bash: !n3app!3: event not found
[oracle@lom-dbstg-01 ~]$ sqlplus SURVEYREPORTRESULTS/P!n3app!3;
-bash: !n3app!3: event not found
[oracle@lom-dbstg-01 ~]$ ps -ef | grep pmon
oracle 4148 1 0 Oct15 ? 00:00:20 ora_pmon_esstg
oracle 27815 27763 0 20:06 pts/0 00:00:00 grep pmon
[oracle@lom-dbstg-01 ~]$ sqlplus SURVEYREPORTRESULTS/P!n3app!3@esstg;
-bash: !n3app!3@esstg: event not found
[oracle@lom-dbstg-01 ~]$ sqlplus SURVEYREPORTRESULTS/P!n3app!3@ora_pmon_esstg;
-bash: !n3app!3@ora_pmon_esstg: event not found
[oracle@lom-dbstg-01 ~]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Oct 28 20:07:37 2015
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: SURVEYREPORTRESULTS
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER