Oracle Database Discussions

Hello Everyone,

Oracle 10.2.0.3
OS : Linux

I am going to configure Dataguard in 10.2.0.3 in the same server,But I have 2 Oracle Homes with different users(Owners).

I configure listener in primary side db(PROD) like

Primary Side :

prod =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.100)(PORT = 1521))
)
)

SID_LIST_prod =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME= /oracle/app/oracle/product/10.2.0)
(SID_NAME = PROD)
)
)

And Standby side:

Tnsnames.ora file

to_prod=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.100)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = prod)
)
)



And listener.ora at standby side:

stand =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.101)(PORT = 1522))
)
)

SID_LIST_stand =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME= /oracle/app/oracle/product/10.2.0)
(SID_NAME = PROD)
)
)


Tnsnames.ora at primary side:

to_std =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.101)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = prod)
)
)


Both side Listener’s are working file
And Tns also working fine….

And parameter at Primary Database Side:

#log_archive_dest=/disk1/oracle/prod/arch
log_archive_dest_1='location=/disk1/oracle/prod/arch'
log_archive_dest_2='service=/disk1/oracle/prod/arch'
fal_server=to_std
fal_client=to_std

And parameters at standby Side:

log_archive_dest_1='location=/disk2/oranew/test/arch'
log_archive_dest_2='service=/disk2/oranew/test/arch'
fal_server=to_std
fal_client=to_std
standby_archive_dest=/disk2/oranew/test/arch
standby_file_management=auto
db_file_name_convert=/disk1/oradata/prod/data,/disk2/oranew/test/data
log_file_name_convert=/disk1/oradata/prod/data,/disk2/oranew/test/data

But when I am going to start standby database as…

Standby side:

Sys> Startup nomount

Sys> Alter database mount standby database;
Altered

Sys> alter database recover managed standby database;


But standby side alert logfile showing the error…

ORA-12154: TNS:could not resolve the connect identifier specified


Thanks,