Connecting to Nomounted database
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
Use (UR=A) with (CONNECT_DATA=(SERVICE_NAME=SERVICE))
Connection using SERVICE_NAME without (UR=A) would error with ORA-12528: TNS:listener: all appropriate instances are blocking new connections
TESTUA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hal)(PORT = 1525))
)
(CONNECT_DATA =
(SERVICE_NAME = v10g.uk.oracle.com)
(UR = A)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hal)(PORT = 1525))
)
(CONNECT_DATA =
(SERVICE_NAME = v10g.uk.oracle.com)
(UR = A)
)
)
Please note that the (UR=A) clause is intended to work with a dynamically registered handler so the use of SERVICE_NAME versus SID is preferred.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/20747382/viewspace-2130839/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Connecting To 12CR2 RAC Pluggable Database With ORA-1033Database
- Hide RMAN Passwords when Connecting to a Target Database (Doc ID 183377.1)IDEDatabase
- Connecting to the MySQL ServerMySqlServer
- Connecting Oracle with MS-AccessOracle
- Connecting with Administrative Privileges: Example (33)
- GoldenGate&ASM&Connecting to a 'BLOCKED' instanceGoASMBloC
- [轉]Connecting OBIEE 11.1.1.7 to Hadoop Data SourcesHadoop
- Connecting to ASM through the TNS Listener from a Client DesktopASMclient
- How can I prevent users from connecting to a USB storage device?dev
- ssh-add 報錯:Error connecting to agent No such file or directoryError
- standby database to primary database.Database
- RMAN DUPLICATE Without Connecting To Target DB For Both Disk & Tape_1375864.1
- Troubleshooting: Connecting to SQL Server When System Administrators Are Locked OutSQLServer
- 機器學習之nltk download出錯:Error connecting to server: [Errno -2]機器學習ErrorServer
- The database owner SID recorded in the master database differs from the database owner SID recorded in database 'DB_NAME'DatabaseAST
- Oracle Database Cloud - Database as a Service Quick StartOracleDatabaseCloudUI
- Create RAC Standby Database for RAC Primary DatabaseDatabase
- Types of Oracle Database Users : Database Users (6)OracleDatabase
- 【OH】Creating a Database with the CREATE DATABASE StatementDatabase
- Database Testing: How to Regression Test a Relational DatabaseDatabase
- Tasks of a Database Administrator : Plan the Database (9)Database
- Database performance gets slower the longer the database is runningDatabaseORM
- NServiceBus翻譯之持久化技術(三):Using RavenDB In NServiceBus – Connecting持久化
- Database OverallDatabase
- Flashback DatabaseDatabase
- duplicate databaseDatabase
- v$databaseDatabase
- Size DatabaseDatabase
- standby databaseDatabase
- Database EngineerDatabase
- Create DatabaseDatabase
- Database StatisticsDatabase
- performance of the databaseORMDatabase
- Drop DatabaseDatabase
- Database StorageDatabase
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase
- recover database until cancel和 recover database區別Database
- Types of Oracle Database Users : Database Administrators (1)OracleDatabase