这个问题是因为克隆后,数据库层连接数达到最大值造成不能连接,更改如下:
SQL> alter system set processes=1000 scope=spfile;
alter system set processes=1000 scope=spfile
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE specified at startup
SQL> create spfile from pfile;
File created.
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2160600 bytes
Variable Size 427821096 bytes
Database Buffers 624951296 bytes
Redo Buffers 14004224 bytes
Database mounted.
Database opened.
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /data/t01/oratest/db/tech_st/1
1.1.0/dbs/spfiletest.ora
SQL> show parameter pfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /data/t01/oratest/db/tech_st/1
1.1.0/dbs/spfiletest.ora
SQL> alter system set processes=1000 scope=spfile;
System altered.
SQL> alter system set sessions=500 scope=spfile;
System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
重新启动应用即可。