ORA-12526: TNS:listener: all appropriate instances are in restricted mode

The database instance is in restricted mode:

It does not allow connections through listener

==> sqlplus

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jul 8 04:56:12 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Enter user-name: sys/xxxxxx@DBNAME as sysdba

ERROR:

ORA-12526: TNS:listener: all appropriate instances are in restricted mode

To connect to database in restricted mode with listener , we need to make following change in our TNS entry.

    (CONNECT_DATA =

      (UR = A)

      (SERVER = DEDICATED)

      (SERVICE_NAME = DBNAME)

    )

After  the change

==> sqlplus

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jul 8 04:57:35 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Enter user-name: sys/xxxxxxx@DBNAME as sysdba

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

connected without any issues :)