How to startup automatically Oracle 19C using bash scripting and SQL PLUS?

Question

I've tried to create a bash script for connecting to my Oracle 19C database using sqlplus, I added the following code (which works also) :

#! /bin/sh.
connectsqlplus(){
    sqlplus "'"sys/mypassword as sysdba"'" 
EOF 
}
connectsqlplus

The main problem is that I want to use this bash script to start the database, what I've created seems to only let me open the sqlplus terminal, I just want to add the SQL> startup so that the database starts but I'm not really sure how to add this command in the SQL terminal by using bash scripting.

Any help would be much appreciated ! Thank you .

From bash script I asked, not from the SQLPLUS command line which opens after I enter the code and execute the script from above. — Bob950
– Bob950, Commented Dec 27, 2021 at 22:22

EdStevens · Accepted Answer · 2021-12-27 22:29:24Z

3

#start_oracle_db.sh
ORACLE_SID=nameofyourdatabaseasrecordedinoratabfile
ORAENV_ASK=NO
source oraenv
sqlplus << EOF
connect / as sysdba
startup
exit
EOF

answered Dec 27, 2021 at 22:29

EdStevens

3,9203 gold badges12 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bob950 Over a year ago

Appreciate it "

Collectives™ on Stack Overflow

How to startup automatically Oracle 19C using bash scripting and SQL PLUS?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related