mounting error

Posted by Roshan on Apr 30, 2018; 10:58am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/mounting-error-tp5817.html

Hi Erman,

after restoring a database on a standby server, when mouting it, I am getting

SQL> startup
ORACLE instance started.

Total System Global Area 5344731136 bytes
Fixed Size                  2237776 bytes
Variable Size            3254782640 bytes
Database Buffers         2080374784 bytes
Redo Buffers                7335936 bytes
ORA-01620: no public threads are available for mounting

I have checked on production(source) server

SQL> select thread#, status, enabled, instance from v$thread;

   THREAD# STATUS ENABLED
---------- ------ --------
INSTANCE
--------------------------------------------------------------------------------
         2 OPEN   PRIVATE
CI2


SQL> show parameter db_create_online_

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_create_online_log_dest_1          string      /db01/oradata/ci/CI/onlinelog
db_create_online_log_dest_2          string      /db01/oradata/ci/logs/CI/onlin
                                                 elog
db_create_online_log_dest_3          string
db_create_online_log_dest_4          string
db_create_online_log_dest_5          string
SQL> create pfile from spfile;

File created.

SQL>

How can I make the thread public?

Thanks,

R