一、当前ORACLE用户的状态可查看视图DBA_USERS;一般情况下在使用的正常用户均处于OPEN状态。 123456789101112131415161718192021 SQL> select username,account_status from dba_users;USERNAME              ACCOUNT_STATUS--------------------- ------------------MGMT_VIEW             OPENSYS    &nbs...

SYS@PROD >startup ORA-00119: invalid specification for system parameter DISPATCHERS ORA-00111: invalid attribute DISPPATCHERS 解决方法 1.创建pfile SYS@PROD >create pfile from spfile; File created. 2.修改pfile [oracle@edbjr2p1 dbs]$ vim initPROD.ora *.dispatchers='(PROT=TCP)(DISPATCHERS=2)' 3.从pfile启动 SYS@PROD >startup pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initPROD.ora'; ORACLE instance started. Total System Global Area 835104768 bytes Fixed Size 2257840 bytes Var...