NIO4444

with a semicolon (;) with a slash (/) on a line by itself with a blank line

现象：Value "/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus: cannot execute [Permission denied]"0" of type "string" is not suitable for value type "Numeric (unsigned)"检查：/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus 路径各层级是否都有执行+x权限。...

#查询Oracle所有实例名字shell# su - oracleshell# sqlplus / as sysdbaSQL> select instance_name from v$instance ;SQL> select name from v$database ;

sqlplus -s user/pass @sql脚本脚本内部sql要有分号结尾。否则不会执行。

#Oracle监控用户shell# su - oracleshell# sqlplus / as sysdbaSQL>CREATE USER oracleZabbix IDENTIFIED BY oracleZabbix DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOC...

sqlplus “/as sysdba”

sys / as sysdba select instance_name from V$instance;

shell# su - oracleshell# sqlplus / as sysdbaSQL> CREATE USER zabbix IDENTIFIED BY zabbix DEFAULT TABLESPACE SYSTEMTEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; SQL> GRANT CONNE...