Database Software

Hi! Thanks everybody beforehand for your help and sorry for my English, I will try to explain myself in the best way.

We have a dataguard.

It has two listeners, ports are 1534 and 1544, but...... someone changed them to 1535 one time ago, and now I had to re-configurated everything again.

The thing is that log_archive_dest_2 at primary is wrong, because it points to 1535 instead of 1534. I have tried to edit init.ora and restart the instance but it always points to 1535 again.

I dont know if this parameter depends on another or there is a hidden configuration I cant see

**********
Primary
**********
-----------------------------------------------------------------------------------------------------------------------------------------
tnsnames.ora


LICITARP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server01g)(PORT = 1544))
(ADDRESS = (PROTOCOL = TCP)(HOST = server01)(PORT = 1534))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = LICITARP)
)
)

LICITARR =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server02g.XXXXXX.es)(PORT = 1544))
(ADDRESS = (PROTOCOL = TCP)(HOST = server02.XXXXXX.es)(PORT = 1534))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = LICITARR.XXXXXX.es)
)
)

LICITARP.XXXXXX.es =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server01.XXXXXX.es)(PORT = 1534))
)
(CONNECT_DATA =
(SID = LICITARP)
(SERVER = DEDICATED)
)
)

LICITARPG.XXXXXX.es =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server01g.XXXXXX.es)(PORT = 1544))
)
(CONNECT_DATA =
(SID = LICITARP)
(SERVER = DEDICATED)
)
)

LICITARR.XXXXXX.es =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server02.XXXXXX.es)(PORT = 1534))
)
(CONNECT_DATA =
(SID = LICITARR)
(SERVER = DEDICATED)
)
)

L_LICITARPG =
(ADDRESS= (PROTOCOL =TCP) (HOST=server01g.XXXXXX.es) (PORT=1544) )

L_LICITARP =
(ADDRESS= (PROTOCOL =TCP) (HOST=server01.XXXXXX.es) (PORT=1534) )





-----------------------------------------------------------------------------------------------------------------------------------------
listener.ora


SID_LIST_L_LICITARPG =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = LICITARP.XXXXXX.es)
(ORACLE_HOME = /opt/oracle/product/db111)
(SID_NAME = LICITARP)
)
)

L_LICITARP =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server01.XXXXXX.es)(PORT = 1534))
)
)
L_LICITARPG =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server01g.XXXXXX.es)(PORT = 1544))
)
)

SID_LIST_L_LICITARP =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = LICITARP_dgmgrl.XXXXXX.es)
(ORACLE_HOME = /opt/oracle/product/db111)
(SERVICE_NAME = LICITARP.XXXXXX.es)
(SID_NAME = LICITARP)
)
(SID_DESC =
(GLOBAL_DBNAME = LICITARP.XXXXXX.es)
(ORACLE_HOME = /opt/oracle/product/db111)
(SID_NAME = LICITARP)
)
(SID_DESC =
(GLOBAL_DBNAME = LICITARR.XXXXXX.es)
(ORACLE_HOME = /opt/oracle/product/db111)
(SID_NAME = LICITARR)
)
)


-----------------------------------------------------------------------------------------------------------------------------------------
parameters



My init ora parameters:

LICITARP.log_archive_dest_1='location="USE_DB_RECOVERY_FILE_DEST"',' valid_for=(ALL_LOGFILES,ALL_ROLES)'
LICITARP.log_archive_dest_2='service="LICITARR.xxxxxx.es", LGWR SYNC AFFIRM delay=0 OPTIONAL compression=DISABLE max_failure=0 max_connections=1 reopen=300 db_unique_name="LICITARR" net_timeout=30 valid_for=(online_logfile,primary_role)'


I start the database and when I show parameters, log_dest_2 points to 1535, a wrong port.

SQL> show parameters dest

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /opt/oracle/admin/LICITARP/adu
mp
background_dump_dest string /opt/oracle/diag/rdbms/licitar
p/LICITARP/trace
core_dump_dest string /opt/oracle/diag/rdbms/licitar
p/LICITARP/cdump
db_create_file_dest string
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_online_log_dest_5 string
db_recovery_file_dest string /opt/oracle/oradata/flash_reco
very_area
db_recovery_file_dest_size big integer 100G
diagnostic_dest string /opt/oracle
log_archive_dest string
log_archive_dest_1 string location="USE_DB_RECOVERY_FILE
_DEST", valid_for=(ALL_LOGFIL
ES,ALL_ROLES)
log_archive_dest_10 string
log_archive_dest_2 string service="(DESCRIPTION=(ADDRESS

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_LIST = (ADDRESS=(PROTOCOL=tcp
)(HOST=server02)(¡¡¡¡¡PORT=1535!!!!)))
(CONNECT_DATA=(SERVICE_NAME=LI
CITARR.XXXXXX.es)(SERVER=DE
DICATED)))", LGWR SYNC AFFI
RM delay=0 OPTIONAL compressio
n=DISABLE max_failure=0 max_co
nnections=1 reopen=300 db_un
ique_name="LICITARR" net_timeo
ut=30 valid_for=(online_logfi
le,primary_role)

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string ENABLE
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string ENABLE
log_archive_dest_state_3 string ENABLE

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_min_succeed_dest integer 1
standby_archive_dest string ?/dbs/arch
user_dump_dest string /opt/oracle/diag/rdbms/licitar
p/LICITARP/trace
SQL> show parameters fal

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_client string (DESCRIPTION=(ADDRESS_LIST = (
ADDRESS=(PROTOCOL=tcp)(HOST=fl
o5ora01)(PORT=1534)))(CONNECT_
DATA=(SERVICE_NAME=LICITARP.XX
XXXXXX.es)SERVER=DEDICATED))
fal_server string (DESCRIPTION=(ADDRESS_LIST = (
ADDRESS=(PROTOCOL=tcp)(HOST=f
lo5ora02)(PORT=1534)))(CONNECT
DATA=(SERVICENAME=LICITARR.X
XXXXX.es)(SERVER=DEDICATED)
)



**********
Standby
**********
-----------------------------------------------------------------------------------------------------------------------------------------
tnsnames.ora


LICITARR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server02.intranet.XXXXXX.es)(PORT = 1534))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = LICITARR)
)
)

LICITARR
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server02.intranet.XXXXXX.es)(PORT = 1534))
)
(CONNECT_DATA =
(SID = LICITARR)
(SERVER = DEDICATED)
)
)


L_LICITARR =
(ADDRESS = (PROTOCOL = TCP)(HOST = server02.intranet.XXXXXX.es)(PORT = 1534))


LICITARR.XXXXXX.ES =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server02.intranet.XXXXXX.es)(PORT = 1534))
)
(CONNECT_DATA =
(SID = LICITARR)
(SERVER = DEDICATED)
)
)



-----------------------------------------------------------------------------------------------------------------------------------------
listener.ora



SID_LIST_L_LICITARRG =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = LICITARP_dgmgrl.XXXXXX.es)
(ORACLE_HOME = /opt/oracle/product/db111)
(SERVICE_NAME = LICITARPG.XXXXXX.es)
(SID_NAME = LICITARP)
)
(SID_DESC =
(GLOBAL_DBNAME = LICITARR_dgmgrl.XXXXXX.es)
(ORACLE_HOME = /opt/oracle/product/db111)
(SERVICE_NAME = LICITARRG.XXXXXX.es)
(SID_NAME = LICITARR)
)
(SID_DESC =
(GLOBAL_DBNAME = LICITARPG_dgb.XXXXXX.es)
(ORACLE_HOME = /opt/oracle/product/db111)
(SERVICE_NAME = LICITARPG_DGB.XXXXXX.es)
(SID_NAME = LICITARP)
)
(SID_DESC =
(GLOBAL_DBNAME = LICITARRG_dgb.XXXXXX.es)
(ORACLE_HOME = /opt/oracle/product/db111)
(SERVICE_NAME = LICITARRG_DGB.XXXXXX.es)
(SID_NAME = LICITARR)
)
(SID_DESC =
(GLOBAL_DBNAME = LICITARP.XXXXXX.es)
(ORACLE_HOME = /opt/oracle/product/db111)
(SID_NAME = LICITARP)
)
(SID_DESC =
(GLOBAL_DBNAME = LICITARR.XXXXXX.es)
(ORACLE_HOME = /opt/oracle/product/db111)
(SID_NAME = LICITARR)
)
)

SID_LIST_L_LICITARR =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = LICITARP_dgmgrl.XXXXXX.es)
(ORACLE_HOME = /opt/oracle/product/db111)
(SERVICE_NAME = LICITARPG.XXXXXX.es)
(SID_NAME = LICITARP)
)
(SID_DESC =
(GLOBAL_DBNAME = LICITARR_dgmgrl.XXXXXX.es)
(ORACLE_HOME = /opt/oracle/product/db111)
(SERVICE_NAME = LICITARRG.XXXXXX.es)
(SID_NAME = LICITARR)
)
(SID_DESC =
(GLOBAL_DBNAME = LICITARP_dgb.XXXXXX.es)
(ORACLE_HOME = /opt/oracle/product/db111)
(SERVICE_NAME = LICITARP_DGB.XXXXXX.es)
(SID_NAME = LICITARP)
)
(SID_DESC =
(GLOBAL_DBNAME = LICITARR_dgb.XXXXXX.es)
(ORACLE_HOME = /opt/oracle/product/db111)
(SERVICE_NAME = LICITARR_DGB.XXXXXX.es)
(SID_NAME = LICITARR)
)
(SID_DESC =
(GLOBAL_DBNAME = LICITARP.XXXXXX.es)
(ORACLE_HOME = /opt/oracle/product/db111)
(SID_NAME = LICITARP)
)
(SID_DESC =
(GLOBAL_DBNAME = LICITARR.XXXXXX.es)
(ORACLE_HOME = /opt/oracle/product/db111)
(SID_NAME = LICITARR)
)
)


L_LICITARR =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server02.intranet.XXXXXX.es)(PORT = 1534))
)
)



L_LICITARRG =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server02g.intranet.XXXXXX.es)(PORT = 1544))
)
)

LISTENER_LICITARR=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server02.intranet.XXXXXX.es)(PORT = 1534))
)

SID_LIST_LISTENER_LICITARR =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /opt/oracle/product/db111)
(SID_NAME = LICITARR)
)
)





-----------------------------------------------------------------------------------------------------------------------------------------
parameters


SQL> show parameters dest

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /opt/oracle/admin/LICITARR/adu
mp/
background_dump_dest string /opt/oracle/diag/rdbms/licitar
r/LICITARR/trace
core_dump_dest string /opt/oracle/diag/rdbms/licitar
r/LICITARR/cdump
db_create_file_dest string
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_online_log_dest_5 string
db_recovery_file_dest string /opt/oracle/oradata/flash_reco
very_area
db_recovery_file_dest_size big integer 100G
diagnostic_dest string /opt/oracle
log_archive_dest string
log_archive_dest_1 string LOCATION=USE_DB_RECOVERY_FILE_
DEST OPTIONAL REOPEN=300
log_archive_dest_10 string
log_archive_dest_2 string service="(DESCRIPTION=(ADDRESS
_LIST = (ADDRESS=(PROTOCOL=tcp

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
)(HOST=server02)(PORT=1534)))
(CONNECT_DATA=(SERVICE_NAME=LI
CITARR.XXXXXX.es)(SERVER=DE
DICATED)))", LGWR SYNC AFFI
RM delay=0 OPTIONAL compressio
n=DISABLE max_failure=0 max_co
nnections=1 reopen=300 db_un
ique_name="LICITARR" net_timeo
ut=30 valid_for=(online_logfi
le,primary_role)
log_archive_dest_3 string

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string ENABLE
log_archive_dest_state_3 string ENABLE
log_archive_dest_state_4 string enable

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_min_succeed_dest integer 1
standby_archive_dest string ?/dbs/arch
user_dump_dest string /opt/oracle/diag/rdbms/licitar
r/LICITARR/trace

------------------------------------------------------------------------------------------------



If I tried this I managed to enter sqlplus in both nodes


[oracle@server01 admin]$ sqlplus "sys/YYYYYYY@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server02)(PORT=1534))(CONNECT_DATA=(SERVICE_NAME=LICITARR.XXXXX.es)(SERVER=DEDICATED)(CID=(PROGRAM=oracle)(HOST=server02)(USER=oracle)))) as sysdba"


SQL> select status from v$instance;

STATUS
------------
MOUNTED



[oracle@server01 admin]$ sqlplus "sys/YYYYYYY@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server01)(PORT=1534))(CONNECT_DATA=(SERVICE_NAME=LICITARP.XXXXX.es)(SERVER=DEDICATED)(CID=(PROGRAM=oracle)(HOST=server01)(USER=oracle)))) as sysdba"


SQL> select status from v$instance;

STATUS
------------
OPEN





I'm always getting this messages, where PORT = 1535 is wrong, and the correct port is 1534::

MESSAGE
--------------------------------------------------------------------------------
R.XXXXX.es)(SERVER=DEDICATED)))'

LGWR: Failed to archive log 2 thread 1 sequence 162530 (12514)
ARCH: Beginning to archive thread 1 sequence 162529 (13127536-13127548)
ARCH: Completed archiving thread 1 sequence 162529 (13127536-13127548)
Error 12514 received logging on to the standby
LGWR: Error 12514 creating archivelog file '(DESCRIPTION=(ADDRESS_LIST = (ADDRES
S=(PROTOCOL=tcp)(HOST=server02)(PORT=1535)))(CONNECT_DATA=(SERVICE_NAME=LICITAR
R.XXXXX.es)(SERVER=DEDICATED)))'

LGWR: Failed to archive log 3 thread 1 sequence 162531 (12514)

MESSAGE
--------------------------------------------------------------------------------
ARCH: Beginning to archive thread 1 sequence 162530 (13127548-13127555)
ARCH: Completed archiving thread 1 sequence 162530 (13127548-13127555)
Error 12514 received logging on to the standby
LGWR: Error 12514 creating archivelog file '(DESCRIPTION=(ADDRESS_LIST = (ADDRES
S=(PROTOCOL=tcp)(HOST=server02)(PORT=1535)))(CONNECT_DATA=(SERVICE_NAME=LICITAR
R.XXXXX.es)(SERVER=DEDICATED)))'

LGWR: Failed to archive log 1 thread 1 sequence 162532 (12514)
ARCH: Beginning to archive thread 1 sequence 162531 (13127555-13127565)
ARCH: Completed archiving thread 1 sequence 162531 (13127555-13127565)
Error 12514 received logging on to the standby

MESSAGE
--------------------------------------------------------------------------------
LGWR: Error 12514 creating archivelog file '(DESCRIPTION=(ADDRESS_LIST = (ADDRES
S=(PROTOCOL=tcp)(HOST=server02)(PORT=1535)))(CONNECT_DATA=(SERVICE_NAME=LICITAR
R.XXXXX.es)(SERVER=DEDICATED)))'

LGWR: Failed to archive log 2 thread 1 sequence 162533 (12514)
ARCH: Beginning to archive thread 1 sequence 162532 (13127565-13127570)
ARCH: Completed archiving thread 1 sequence 162532 (13127565-13127570)
Error 12514 received logging on to the standby
LGWR: Error 12514 creating archivelog file '(DESCRIPTION=(ADDRESS_LIST = (ADDRES
S=(PROTOCOL=tcp)(HOST=server02)(PORT=1535)))(CONNECT_DATA=(SERVICE_NAME=LICITAR
R.XXXXX.es)(SERVER=DEDICATED)))'

MESSAGE
--------------------------------------------------------------------------------

LGWR: Failed to archive log 3 thread 1 sequence 162534 (12514)
ARCH: Beginning to archive thread 1 sequence 162533 (13127570-13127575)
ARCH: Completed archiving thread 1 sequence 162533 (13127570-13127575)
Error 12514 received logging on to the standby
LGWR: Error 12514 creating archivelog file '(DESCRIPTION=(ADDRESS_LIST = (ADDRES
S=(PROTOCOL=tcp)(HOST=server02)(PORT=1535)))(CONNECT_DATA=(SERVICE_NAME=LICITAR
R.XXXXX.es)(SERVER=DEDICATED)))'

LGWR: Failed to archive log 1 thread 1 sequence 162535 (12514)
ARCH: Beginning to archive thread 1 sequence 162534 (13127575-13127582)

MESSAGE
--------------------------------------------------------------------------------
ARCH: Completed archiving thread 1 sequence 162534 (13127575-13127582)
Error 12514 received logging on to the standby

256 rows selected.



At those at alert, and again PORT = 1535 when it's wrong, since the correct port is 1534:

***********************************************************************

Fatal NI connect error 12514, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server02)(PORT=1535))(CONNECT_DATA=(SERVICE_NAME=LICITARR_DGB.XXXXX.es)(INSTANCE_NAME=LICITARR)(SERVER=DEDICATED)(CID=(PROGRAM=oracle)(HOST=server01)(USER=oracle))))

VERSION INFORMATION:
TNS for Linux: Version 11.1.0.7.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
Time: 10-NOV-2011 18:56:42
Tracing not turned on.
Tns error struct:
ns main err code: 12564

TNS-12564: TNS:connection refused
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0


***********************************************************************

Fatal NI connect error 12514, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server02)(PORT=1535))(CONNECT_DATA=(SERVICE_NAME=LICITARR_DGB.XXXXX.es)(INSTANCE_NAME=LICITARR)(SERVER=DEDICATED)(CID=(PROGRAM=oracle)(HOST=server01)(USER=oracle))))

VERSION INFORMATION:
TNS for Linux: Version 11.1.0.7.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
Time: 10-NOV-2011 18:56:42
Tracing not turned on.
Tns error struct:
ns main err code: 12564

TNS-12564: TNS:connection refused
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0


I have recreated password file in primary and copy it to secondary, after I have restarted both instances, but nothing