Primary DB:TST12C1
Standby DB:TST12C1S1
OS=RHEL 6.1
DB VERSION=12.1.0.2
Hi Gurus,
I'm trying to create a 12.1.0.2 Standby db for a RAC primary DB getting error "ORA-01017" . I created passwordfile multiple times on primary db and copied to the standby but no luck. Not sure what is it that i'm doing wrong here i have configured few standby's in the past with 10 and 11g's but having strange issue with the 12c. Please suggest your expert advice.
[oracle@ocd01-node1 dbs]$ orapwd file=orapwTST12C1N1 entries=10 password=Te\$t1234 ignorecase=n force=y format=12
[oracle@ocd01-node1 dbs]$ scp orapwTST12C1N1 ocd01-node3:/ocd01adm/oracle/product/12.1.2/db_1/dbs/orapwTST12C1N3 orapwTST12C1N1 100% 7680 7.5KB/s 00:00
[oracle@ocd01-node1 dbs]$ [oracle@ocd01-node1 dbs]$ scp orapwTST12C1N1 ocd01-node2:/ocd01adm/oracle/product/12.1.2/db_1/dbs/orapwTST12C1N2 orapwTST12C1N1 100% 7680 7.5KB/s 00:00
[oracle@ocd01-node1 dbs]$ cp orapwTST12C1N1 orapwTST12C1S1N1
[oracle@ocd01-node1 dbs]$ scp orapwTST12C1S1N1 ocd01-node3:/ocd01adm/oracle/product/12.1.2/db_1/dbs/orapwTST12C1S1N3 orapwTST12C1S1N1 100% 7680 7.5KB/s 00:00
[oracle@ocd01-node1 dbs]$ scp orapwTST12C1S1N1 ocd01-node2:/ocd01adm/oracle/product/12.1.2/db_1/dbs/orapwTST12C1S1N2 orapwTST12C1S1N1 100% 7680 7.5KB/s 00:00
[oracle@ocd01-node1 dbs]$ set -o vi
[oracle@ocd01-node1 dbs]$ sqlplus sys@tst12c1 as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 12 17:09:16 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Enter password: Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options
[oracle@ocd01-node1 dbs]$ sqlplus sys@tst12c1s1 as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 12 17:09:27 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
[oracle@ocd01-node1 admin]$ srvctl config database -d TST12C1
Database unique name: TST12C1
Database name: TST12C1
Oracle home: /ocd01adm/oracle/product/12.1.2/db_1
Oracle user: oracle
Spfile: +OCD01_DGA_DTA/TST12C1/PARAMETERFILE/spfile.297.908550797
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: OCD01_DGA_ARC,OCD01_DGA_DTA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: oinstall
OSOPER group: oper
Database instances: TST12C1N1,TST12C1N2,TST12C1N3
Configured nodes: ocd01-node1,ocd01-node2,ocd01-node3
Database is administrator managed
[oracle@ocd01-node1 admin]$
TNS Entry:
TST12C1S1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxx-crs-scan)(PORT = 1526))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TST12C1S1)
)
)
Static Service in Listener.ora
)
(SID_DESC =
(GLOBAL_DBNAME = "tst12c1s1")
(SID_NAME = TST12C1S1N1)
(ORACLE_HOME = /ocd01adm/oracle/product/12.1.2/db_1)
(ENVS="TNS_ADMIN=/ocd01adm/oracle/product/12.1.2/db_1/network/admin")
)
)
Thanks in Advance.