The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.
Thanks for the question, kevin.
Asked: October 22, 2016 - 2:08 am UTC
Last updated: October 22, 2016 - 8:42 am UTC
Version: 10.2.0.5
Viewed 1000+ times
[oracle@host122 ~]$ cat test.sh echo "exit" | sqlplus / as sysdba @test.sql [oracle@host122 ~]$ cat test.sql select 'RUNNING_TEST' from dual; [oracle@host122 ~]$ ./test.sh SQL*Plus: Release 12.2.0.1.0 Production on Sat Oct 22 09:37:50 2016 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production /bin/bash: title: command not found 'RUNNING_TES ------------ RUNNING_TEST sys@db122 SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@host122 ~]$ ./test.sh SQL*Plus: Release 12.2.0.1.0 Production on Sat Oct 22 09:38:48 2016 Copyright (c) 1982, 2016, Oracle. All rights reserved. ERROR: ORA-01017: invalid username/password; logon denied Enter user-name: Enter password: ERROR: ORA-01005: null password given; logon denied Enter user-name: [oracle@host122 ~]$
Share and learn SQL and PL/SQL; free access to the latest version of Oracle Database!
Classes, workouts and quizzes on Oracle Database technologies. Expertise through exercise!