I'm trying to make standby to database.
I've insalled Oracle 11g database on virtual machine (host -
oratest). Standby is on virtual machine too (
When I'm trying to connect from source database to auxiliary database I'm getting ORA-12528. The only way I can connect to auxiliary databse is using the 2nd method from the note:
[oravis@standbysrv backup]$ rman target sys/manager@testprod auxiliary / Recovery Manager: Release 126.96.36.199.0 - Production on Sat Dec 26 19:36:39 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: TEST (DBID=2197628678) connected to auxiliary database: TEST (not mounted)
But this way does not work for active duplicate.
listener.ora of source database:
TESTSTAN = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = standbysrv)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = teststan) ) )
listener.ora of future standby:
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oravis/product/11.2.0/dbhome_1) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = teststan) (ORACLE_HOME = /u01/app/oravis/product/11.2.0/dbhome_1) (SID_NAME = test) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = standbysrv)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) )