- 论坛徽章:
- 0
|
【测试成功】
多谢各位高手相助,已解决之前的问题:
function check ()
{
su - oracle -c "sqlplus sys/oracle as sysdba <<EOF
select open_mode from v\$database;
select value from v\$nls_parameters where parameter like 'NLS_CHARACTERSET';
EOF"
}
check
执行结果:==========》
SQL> select open_mode from v
*
ERROR at line 1:
ORA-04044: procedure, function, package, or type is not allowed here
SQL> select value from v where parameter like 'NLS_CHARACTERSET'
*
ERROR at line 1:
=======================================================================
修改su - oracle -c "command" =====>su - oracle -c 'command'
function check ()
{
su - oracle -c 'sqlplus sys/oracle as sysdba <<EOF
select open_mode from v\$database;
select value from v\$nls_parameters where parameter like 'NLS_CHARACTERSET';
EOF'
}
check
执行结果==============
SQL>
OPEN_MODE
----------
READ WRITE
SQL> select value from v$nls_parameters where parameter like NLS_CHARACTERSET
*
ERROR at line 1:
... |
|