mounting error

[Roshan]

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

[Roshan]

I have tried on production:

SQL> alter database disable thread 2;

alter database disable thread 2
*
ERROR at line 1:
ORA-01615: instance CI2 (thread 2) is mounted - cannot disable


SQL> SQL> alter database enable public thread 2;

alter database enable public thread 2
*
ERROR at line 1:
ORA-01612: instance CI2 (thread 2) is already enabled

[ErmanArslansOracleBlog]

Read this Oracle Support Note->

Startup database failed with ORA-1620: no public threads are available for mounting After changing DB_NAME (Doc ID 2228602.1)

[Roshan]

ok. thanks

[Roshan]

I have checked the Oracle doc. If I change the db_name parameter in pfile/spfile, I will get a mismatch error for the database name since DB name in control file will be different to that in pfile/spfile.

[ErmanArslansOracleBlog]

Roshan, please tell me what you did exactly.

1)You restored how? What did you do after that? (did you change db name?, if yes how? to what name?)
2)What are the values of the following init.ora parameters:

db_name?

instance_name?

<instance_name>.thread=1
<instance_name>.thread=2