Archive

Archive for June, 2012

ORA-12528: TNS:listener: all appropriate instances are blocking new connections

June 20, 2012 Leave a comment

Today, I clone a 11gR2.0.3 database at the same database server. Once I start rman, I get the ORA errors message below

[oracle@ycsdb01 dbs]$ rman target / nocatalog auxiliary sys/12345@spbpro

Recovery Manager: Release 11.2.0.3.0 – Production on Wed Jun 20 17:13:06 2012

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: CSPRO (DBID=3560463483)
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
[oracle@ycsdb01 dbs]$ cd $ORACLE_HOME/network/admin

Solution

Then, I add the option “(UR=A)”  in tnsnames.ora as below. The problem is fixed.

SPBPRO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = scan.springboard.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = spbpro)(UR=A)
)
)

 

 

Categories: ORA-XXX, RMAN, TNS

Temporarily change user password

June 20, 2012 Leave a comment

1. Get the password string of user

SQL> select name, password from sys.user$ where name=’ROAMSAVE’;

NAME                           PASSWORD
—————————— ——————————
ROAMSAVE                       90EEB9F64DD6C1BF

2. Change the password of user
SQL> alter  user roamsave identified by roamsave;

 

3. Restore the password of the user

SQL> alter  user roamsave identified by values ’90EEB9F64DD6C1BF’;

User altered.

SQL> select name, password from sys.user$ where name=’ROAMSAVE’;

NAME                           PASSWORD
—————————— ——————————
ROAMSAVE                       90EEB9F64DD6C1BF

 

Categories: Administration

Can’t restore backup of database

June 9, 2012 Leave a comment

I need to restore a database to different asm diskgroup. Once I start to restore the database with the command follows.

run{
set newname for datafile 1 to ‘+DISKGROUP/cmsprod/datafile/system.261.670168721’;
set newname for datafile 2 to ‘+DISKGROUP/cmsprod/datafile/undotbs1.262.670168727’;
set newname for datafile 3 to ‘+DISKGROUP/cmsprod/datafile/sysaux.263.670168729’;
set newname for datafile 4 to ‘+DISKGROUP/cmsprod/datafile/undotbs2.265.670168733’;
set newname for datafile 5 to ‘+DISKGROUP/cmsprod/datafile/users.266.670168737’;
set newname for datafile 6 to ‘+DISKGROUP/cmsprod/datafile/tbs_cms.296.670173343’;
set newname for datafile 7 to ‘+DISKGROUP/cmsprod/datafile/tbs_production.297.670173385’;
set newname for datafile 8 to ‘+DISKGROUP/cmsprod/datafile/tbs_volantis_mcs.298.670173393’;
set newname for datafile 9 to ‘+DISKGROUP/cmsprod/datafile/volantis_tbs.316.670175271’;
set newname for datafile 10 to ‘+DISKGROUP/cmsprod/datafile/tbs_volantis_mcs_stg.317.670174997’;
set newname for datafile 11 to ‘+DISKGROUP/cmsprod/datafile/perfstat.335.671363091’;
set newname for datafile 12 to ‘+DISKGROUP/cmsprod/datafile/undotbs3.389.673005569’;
set newname for datafile 13 to ‘+DISKGROUP/cmsprod/datafile/tbs_cms.397.700411387’;
set newname for datafile 14 to ‘+DISKGROUP/cmsprod/datafile/tbs_cms.393.731520969’;
set newname for datafile 15 to ‘+DISKGROUP/cmsprod/datafile/manuted.368.731673341’;
set newname for datafile 16 to ‘+DISKGROUP/cmsprod/datafile/tbs_cms.401.736106307’;
restore database;
}

The message returned as below. It showed that it couldn’t connect to ASM Instance since the maximum number of processes exceeded. The default ASM instance default process is 40.

ORA-19870: error reading backup piece /u01/bkup/database/cmsprod/CMSPROD_data_bkup_5193
ORA-19504: failed to create file “+DISKGROUP”
ORA-17502: ksfdcre:4 Failed to create file +DISKGROUP
ORA-15055: unable to connect to ASM instance
ORA-00020: maximum number of processes () exceeded
ORA-15055: unable to connect to ASM instance
ORA-00020: maximum number of processes () exceeded
failover to previous backup

Fix Procedures

Then I increased process number in ASM instance and restarted. The problem is fixed