下面是段ksh脚本,想在里面执行connect /as sysdba;但系统不认,改怎么写呢? 请问 sqlplus -s /nolog << SQLPLUS connect ${OPT_DB_USER}/${OPT_DB_PASSWORD}@${OPT_DB_SERVER} //可以生效 @ /etc/sql/schema/reporting.sql; commit;
connect /as sysdba; // 这句在sh中应该是怎么写呢? alter database datafile '/qscora/oradata/arial/rollback1.dbf' resize 500M; commit; quit;SQLPLUS
connect /as sysdba; // 这句在sh中应该是怎么写呢? alter database datafile '/qscora/oradata/arial/rollback1.dbf' resize 500M; commit; quit;SQLPLUS
connect / as sysdba;
ORA-01031: insufficient privileges
ERROR:
ORA-01017: invalid username/password; logon denied
呢?
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
而不是输入passwd
su - oracle
sqlplus /nolog
connect / as sysdba如果先输入su - oracle然后执行脚本就可以现在的问题是我怎么把su - oracle写到调用这个ksh的脚本里面呢?
直接写
su - oracle
/a.ksh
报错
Not a terminal
stty: : Not a typewriter
stty: : Not a typewriter