Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about how to convert and execute shell scripts in common Oracle DBA scripts, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

Recently, I started to convert Oracle database scripts into shell scripts, so let's start sharing some scripts commonly used by Oracle today, which will be updated from time to time.

I. Environmental preparation

1. Configure tnsnames.ora

Make sure the alias is the same as ORACLE_SID, and later scripts need

# vim / u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora = MDMDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = xx.xx.65) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = MDMDB) =

two。 Test connection

Initialization script settdb.sh

Use script settdb.sh for DB login details registry

Output:

Third, the first script-- findfunc.sh

#! / bin/bash echo "= = View user $1 function object =" FUNC_OWNER= `sqlplus-silent $DB_CONN_STR@$SH_DB_SID

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.