Home » Server Options » Data Guard » RMAN-00554 RMAN-04006 (ORACLE 19c 19.3.0.0 )
RMAN-00554 RMAN-04006 [message #689135] Thu, 28 September 2023 01:25 Go to next message
LIPEKA
Messages: 9
Registered: September 2023
Junior Member
I am new to this and practicing Dataguard. I am unable to connect to standby(SALESPRDSBY ) to duplicate standby database. Using one computer(on this example).

Primary                                  Standby
User: Rock_it_pc1                        Rockpc1
DB_UNIQUE_NAME: SALESPRD                 SALESPRDSBY
Linux RHEL 8                             Linux RHEL8


tnsping from Primary to standby works.

I am stuck and need help. I have tried everything I can for two days and I need help. I have changed password on both databases in linux using orapw$ORACLE_SID


**Primary database is up and active.  Standby is in Nomount stage.


Few screen shots below.

From Primary(SALESPRD )



[rock_it_pc1@localhost ~]$ cat .profile_19c
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
export PATH=/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/usr/X11R6/bin
export LD_LIBRARY_PATH=/usr/lib:/usr/X11R6/lib:$ORACLE_HOME/lib
export ORACLE_SID=SALESPRD
export TNS_ADMIN=$ORACLE_HOME/network/admin
export EDITOR=vi



[rock_it_pc1@localhost dbs]$ rman target sys/password auxiliary sys/password@to_SALESPRDSBY

Recovery Manager: Release 19.0.0.0.0 - Production on Thu Sep 28 01:24:54 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: SALESPRD (DBID=3711266028)
RMAN-00571: ===========================================================
RMAN-00569: =========
ERROR MESSAGE STACK FOLLOWS
=========
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied



[rock_it_pc1@localhost dbs]$ tnsping SALESPRDSBY

TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 28-SEP-2023 01:56:56

Copyright (c) 1997, 2019, Oracle.  All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))) (CONNECT_DATA = (SID = SALESPRDSBY)))
OK (10 msec)
[rock_it_pc1@localhost dbs]$

[rock_it_pc1@localhost dbs]$ ls -trlh
total 11M
-rw-r--r--. 1 rock_it_pc1 rock_it_pc1 3.1K May 14  2015 init.ora
-rw-rw----. 1 rock_it_pc1 rock_it_pc1  11M Sep 25 23:59 snapcf_SALESPRD.f
-rw-rw-r--. 1 rock_it_pc1 rock_it_pc1 1.8K Sep 26 04:46 initSALESPRD.ora
-rw-rw-r--. 1 rock_it_pc1 rock_it_pc1   92 Sep 26 06:55 afiedt.buf
-rw-rw----. 1 rock_it_pc1 rock_it_pc1   24 Sep 27 22:40 lkSALESPRD
-rw-r-----. 1 rock_it_pc1 rock_it_pc1 2.5K Sep 27 22:56 orapwSALESPRD
-rw-rw----. 1 rock_it_pc1 rock_it_pc1 1.6K Sep 28 01:11 hc_SALESPRD.dat
-rw-rw----. 1 rock_it_pc1 rock_it_pc1 4.5K Sep 28 01:11 spfileSALESPRD.ora
-rw-r-----. 1 rock_it_pc1 rock_it_pc1 2.0K Sep 28 01:19 orapwSALESPRDSBY

[rock_it_pc1@localhost admin]$ ls -trlh
total 28K
-rw-r--r--. 1 rock_it_pc1 rock_it_pc1 1.5K Feb 13  2018 shrept.lst
drwxr-xr-x. 2 rock_it_pc1 rock_it_pc1   64 Apr 17  2019 samples
-rw-rw-r--. 1 rock_it_pc1 rock_it_pc1   52 Sep 20 03:31 afiedt.buf
-rw-r-----. 1 rock_it_pc1 rock_it_pc1 1.6K Sep 27 07:44 listener.ora.original
-rw-rw-r--. 1 rock_it_pc1 rock_it_pc1 1.2K Sep 27 07:44 tnsnames.ora.original
-rw-rw-r--. 1 rock_it_pc1 rock_it_pc1 1.2K Sep 27 07:48 tnsnames.ora
-rw-r-----. 1 rock_it_pc1 rock_it_pc1 1.6K Sep 27 07:53 listener.ora

[rock_it_pc1@localhost admin]$ cat listener.ora
  1. listener.ora Network Configuration File: /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
  2. Generated by Oracle configuration tools.
#######################################

  1. For Primay
####################################

SALESPRD =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
      (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) # I use this when not using dataguard
     # (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.230)(PORT = 1522)) # use this home for dataguar
    # (ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.82.138)(PORT = 1522)) # use this when at home or anywhere
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      )
   )
 )



SID_LIST_SALESPRD =
 (SID_LIST =
   (SID_DESC =
      (ORACLE_HOME = /u01/app/oracle/product/19.0.0/dbhome_1)
     (SID_NAME = salesprd)
     (ENVS="TNS_ADMIN=/u01/app/oracle/product/19.0.0/dbhome_1/network/admin")
   )

)


ADR_BASE_LISTENER=/u01/app/oracle


[rock_it_pc1@localhost admin]$ cat tnsnames.ora
  1. tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/tnsnames.ora
  2. Generated by Oracle configuration tools.
#########################################
  1. FOr PRimary and standby
#####################################



SALESPRD =
 (DESCRIPTION =
  (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
     # (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.230)(PORT = 1522)) # use it for dataguard or link. home or work
    #  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.230)(PORT = 1522)) # Use this when not home.change ip
   )
   (CONNECT_DATA =
      (SID = SALESPRD)
       # (UR=A)      
   )
)

## FOR STANDBY DTBSE   on dell_latitude

to_SALESPRDSBY , SALESPRDSBY =
 (DESCRIPTION =
   (ADDRESS_LIST =
    # (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.122)(PORT = 1522))   #ip of the dell_see
   # (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.122)(PORT = 1522))   #ip of the dell_see when not home
       (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
   )
   (CONNECT_DATA =
     #  (SID = SALESPRD)
        (SID = SALESPRDSBY)
        # (UR=A)
   )
 )



[rock_it_pc1@localhost dbs]$ cat initSALESPRD.ora
SALESPRD.__data_transfer_cache_size=0
SALESPRD.__db_cache_size=3808428032
SALESPRD.__inmemory_ext_roarea=0
SALESPRD.__inmemory_ext_rwarea=0
SALESPRD.__java_pool_size=0
SALESPRD.__large_pool_size=33554432
SALESPRD.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
SALESPRD.__pga_aggregate_target=1627389952
SALESPRD.__sga_target=4865392640
SALESPRD.__shared_io_pool_size=134217728
SALESPRD.__shared_pool_size=872415232
SALESPRD.__streams_pool_size=0
SALESPRD.__unified_pga_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/SALESPRD/adump'
*.audit_trail='db'
*.compatible='19.0.0'
*.control_files='/u01/app/oracle/oradata/SALESPRD/controlfile/o1_mf_ljddod6h_.ctl','/u01/app/oracle/fast_recovery_area/SALESPRD/contr olfile/o1_mf_ljddod73_.ctl'
*.db_block_size=8192
*.db_create_file_dest='/u01/app/oracle/oradata'
#*.db_file_name_convert='/u02/app/oracle/oradata/SALESPRDSBY/datafile','/u01/app/oracle/oradata/SALESPRD/datafile'
*.db_name='SALESPRD'
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=8256m
*.db_unique_name='SALESPRD'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=SALESPRDXDB)'
*.fal_client='to_SALESPRD'
*.fal_server='to_SALESPRDSBY'
*.log_archive_config='dg_config=(salesprd, salesprdsby)'
*.log_archive_dest_1='location=use_db_recovery_file_dest valid_for=(all_logfiles,all_roles) db_unique_name=salesprd'
*.log_archive_dest_2='service=salesprdsby async valid_for=(online_logfiles, primary_role) db_unique_name=salesprdsby'
#*.log_file_name_convert='/u02/app/oracle/oradata/SALESPRDSBY/datafile','/u01/app/oracle/oradata/SALESPRD/datafile'
*.open_cursors=300
*.pga_aggregate_target=1543m
*.processes=640
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=4629m
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'
[rock_it_pc1@localhost dbs]$


-=-=-=-==-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=


STANDBY (SALESPRDSBY)



[rockpc1@localhost ~]$ cat .profile_19csby
export ORACLE_BASE=/u02/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
export PATH=/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/usr/X11R6/bin
export LD_LIBRARY_PATH=/usr/lib:/usr/X11R6/lib:$ORACLE_HOME/lib
#export ORACLE_SID=SALESPRD
export ORACLE_SID=SALESPRDSBY
export TNS_ADMIN=$ORACLE_HOME/network/admin
export EDITOR=vi


[rockpc1@localhost dbs]$ ls -trlh
total 20K
-rw-r--r--. 1 rockpc1 rockpc1 1.9K Sep 27 07:35 initSALESPRDSBY.ora
-rw-r--r--. 1 rockpc1 rockpc1 3.1K Sep 27 07:35 init.ora
-rw-r-----. 1 rockpc1 rockpc1 2.5K Sep 27 23:24 orapwSALESPRD
-rw-r-----. 1 rockpc1 rockpc1 2.0K Sep 28 01:14 orapwSALESPRDSBY
-rw-rw----. 1 rockpc1 rockpc1 1.6K Sep 28 01:23 hc_SALESPRDSBY.dat
[rockpc1@localhost dbs]$ tnsping SALESPRD

TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 28-SEP-2023 02:12:35

Copyright (c) 1997, 2019, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))) (CONNECT_DATA = (SID = SALESPRD)))
OK (0 msec)
[rockpc1@localhost dbs]$


[rockpc1@localhost dbs]$ cat initSALESPRDSBY.ora
SALESPRD.__data_transfer_cache_size=0
SALESPRD.__db_cache_size=3808428032
SALESPRD.__inmemory_ext_roarea=0
SALESPRD.__inmemory_ext_rwarea=0
SALESPRD.__java_pool_size=0
SALESPRD.__large_pool_size=33554432
SALESPRD.__oracle_base='/u02/app/oracle'#ORACLE_BASE set from environment
SALESPRD.__pga_aggregate_target=1627389952
SALESPRD.__sga_target=4865392640
SALESPRD.__shared_io_pool_size=134217728
SALESPRD.__shared_pool_size=872415232
SALESPRD.__streams_pool_size=0
SALESPRD.__unified_pga_pool_size=0
*.audit_file_dest='/u02/app/oracle/admin/SALESPRDSBY/adump'
*.audit_trail='db'
*.compatible='19.0.0'
*.control_files='/u02/app/oracle/oradata/SALESPRDSBY/controlfile/o1_mf_ljddod6h_.ctl','/u02/app/oracle/fast_recovery_area/SALESPRD/co ntrolfile/o1_mf_ljddod73_.ctl'
*.db_block_size=8192
*.db_create_file_dest='/u02/app/oracle/oradata'
*.db_file_name_convert='/u01/app/oracle/oradata/SALESPRD/datafile','/u02/app/oracle/oradata/SALESPRDSBY/datafile'
*.db_name='SALESPRD'
*.db_recovery_file_dest='/u02/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=8256m
*.db_unique_name='SALESPRDSBY'
*.diagnostic_dest='/u02/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=SALESPRDXDB)'
*.fal_client='to_SALESPRDSBY' #Pointing to listner/tnsnames nomenclature
*.fal_server='to_SALESPRD'
*.log_archive_config='dg_config=(salesprd, salesprdsby)'
*.log_archive_dest_1='location=use_db_recovery_file_dest valid_for=(all_logfiles,all_roles) db_unique_name=salesprdsby'
*.log_archive_dest_2='service=salesprdsby async valid_for=(online_logfiles, primary_role) db_unique_name=salesprd'
*.log_file_name_convert='/u01/app/oracle/oradata/SALESPRD/datafile','/u02/app/oracle/oradata/SALESPRDSBY/datafile'
*.open_cursors=300
*.pga_aggregate_target=1543m
*.processes=640
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=4629m
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'


[rockpc1@localhost admin]$ ls -trlh
total 20K
-rw-r--r--. 1 rockpc1 rockpc1 1.5K Sep 27 07:35 shrept.lst
drwxr-xr-x. 2 rockpc1 rockpc1   64 Sep 27 07:35 samples
-rw-r-----. 1 rockpc1 rockpc1 1.7K Sep 27 07:40 listener.ora.original
-rw-r--r--. 1 rockpc1 rockpc1 1.2K Sep 27 07:40 tnsnames.ora.original
-rw-r--r--. 1 rockpc1 rockpc1 1.2K Sep 27 07:49 tnsnames.ora
-rw-r-----. 1 rockpc1 rockpc1 1.7K Sep 27 23:36 listener.ora
[rockpc1@localhost admin]$ cat listener.ora
  1. listener.ora Network Configuration File: /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
  2. Generated by Oracle configuration tools.
#######################################

  1. For STANDBY
####################################

SALESPRDSBY =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
      (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522)) # I use this when not using dataguard
    #  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.122)(PORT = 1522)) # use this home for dataguar
    # (ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.82.138)(PORT = 1522)) # use this when at home or anywhere
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
      )
   )
 )



SID_LIST_SALESPRDSBY =
 (SID_LIST =
   (SID_DESC =
      (ORACLE_HOME = /u02/app/oracle/product/19.0.0/dbhome_1)
     #  (SID_NAME = salesprd)
      (SID_NAME = salesprdsby)
     (ENVS="TNS_ADMIN=/u02/app/oracle/product/19.0.0/dbhome_1/network/admin")
   )

)


ADR_BASE_LISTENER=/u02/app/oracle


[rockpc1@localhost admin]$ cat tnsnames.ora
  1. tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/tnsnames.ora
  2. Generated by Oracle configuration tools.
#########################################
  1. FOr STANDBY
#####################################



SALESPRDSBY =
 (DESCRIPTION =
  (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
    #  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.122)(PORT = 1522)) # use it for dataguard or link. home or work
    #  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.230)(PORT = 1522)) # Use this when not home.change ip
   )
   (CONNECT_DATA =
      (SID = SALESPRDSBY)
     #  (SID = SALESPRD)
         # (UR=A)
   )
)

## FOR STANDBY DTBSE   on dell_latitude

to_SALESPRD, SALESPRD =
 (DESCRIPTION =
   (ADDRESS_LIST =
    # (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.230)(PORT = 1522))   #ip of the dell_see
   # (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.122)(PORT = 1522))   #ip of the dell_see when not home
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
   )
   (CONNECT_DATA =
      (SID = SALESPRD)
      # (UR-A)
   )
  )




-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=
I have noticed from primary that I am unabel to login as SQL> sqlplus sys/password@SALESPRD as sysdba   getting an error and same thing on the stanby side. Bringing this up just in case they are related to the RMAN issue I am getting.



Re: RMAN-00554 RMAN-04006 [message #689136 is a reply to message #689135] Thu, 28 September 2023 02:13 Go to previous messageGo to next message
John Watson
Messages: 8916
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

Quote:
I have noticed from primary that I am unabel to login as SQL> sqlplus sys/password@SALESPRD as sysdba   getting an error and same thing on the stanby side. Bringing this up just in case they are related to the RMAN issue I am getting.
This is exactly your problem: you do not have not have password file authentication working. You need to recreate the password file for the primary, copy it for the standby, and then show that you can connect (or not) through the tnsnames aliases. Please show all this, using copy/paste from SQL*Plus. Do not merely describe it Smile
Re: RMAN-00554 RMAN-04006 [message #689148 is a reply to message #689136] Thu, 28 September 2023 13:30 Go to previous messageGo to next message
LIPEKA
Messages: 9
Registered: September 2023
Junior Member
John Watson wrote on Thu, 28 September 2023 02:13
Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

Quote:
I have noticed from primary that I am unabel to login as SQL> sqlplus sys/password@SALESPRD as sysdba   getting an error and same thing on the stanby side. Bringing this up just in case they are related to the RMAN issue I am getting.
This is exactly your problem: you do not have not have password file authentication working. You need to recreate the password file for the primary, copy it for the standby, and then show that you can connect (or not) through the tnsnames aliases. Please show all this, using copy/paste from SQL*Plus. Do not merely describe it Smile

Thanks John.Please help.  Recreating password file and posting result. From Primary Database (SALESPRD)

rock_it_pc1@localhost ~]$ # PASSWORD FILE RECREATION FOR PRIMARY DATABASE SALESPRD
[rock_it_pc1@localhost ~]$ . .profile_19c
[rock_it_pc1@localhost ~]$ cd $ORACLE_HOME/dbs
[rock_it_pc1@localhost dbs]$ ls -trlh
total 11M
-rw-r--r--. 1 rock_it_pc1 rock_it_pc1 3.1K May 14  2015 init.ora
-rw-rw----. 1 rock_it_pc1 rock_it_pc1  11M Sep 25 23:59 snapcf_SALESPRD.f
-rw-rw-r--. 1 rock_it_pc1 rock_it_pc1 1.8K Sep 26 04:46 initSALESPRD.ora
-rw-rw-r--. 1 rock_it_pc1 rock_it_pc1   92 Sep 26 06:55 afiedt.buf
-rw-rw----. 1 rock_it_pc1 rock_it_pc1   24 Sep 27 22:40 lkSALESPRD
-rw-r-----. 1 rock_it_pc1 rock_it_pc1 2.5K Sep 27 22:56 orapwSALESPRD
-rw-rw----. 1 rock_it_pc1 rock_it_pc1 1.6K Sep 28 01:11 hc_SALESPRD.dat
-rw-rw----. 1 rock_it_pc1 rock_it_pc1 4.5K Sep 28 01:11 spfileSALESPRD.ora
-rw-r-----. 1 rock_it_pc1 rock_it_pc1 2.0K Sep 28 01:19 orapwSALESPRDSBY
[rock_it_pc1@localhost dbs]$ # Checking current status
[rock_it_pc1@localhost dbs]$ lsnrctl start SALESPRD

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 28-SEP-2023 13:51:10

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/19.0.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/salesprd/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     SALESPRD
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                28-SEP-2023 13:51:12
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/salesprd/alert/log.xml
Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "salesprd" has 1 instance(s).
 Instance "salesprd", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[rock_it_pc1@localhost dbs]$ lsnrctl service SALESPRD

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 28-SEP-2023 13:51:31

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
Services Summary...
Service "salesprd" has 1 instance(s).
 Instance "salesprd", status UNKNOWN, has 1 handler(s) for this service...
   Handler(s):
     "DEDICATED" established:0 refused:0
        LOCAL SERVER
The command completed successfully
[rock_it_pc1@localhost dbs]$ sqlplus sys/password@SALESPRD as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 28 13:52:07 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 4865390248 bytes
Fixed Size    8906408 bytes
Variable Size  905969664 bytes
Database Buffers 3942645760 bytes
Redo Buffers    7868416 bytes
Database mounted.
Database opened.
SQL> show parameter remote_login_passwordfile

NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile     string EXCLUSIVE
SQL> show parameter sec_case_sensitive_logon

NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon     boolean FALSE

SQL> ed
Wrote file afiedt.buf

 1  select username, sysdba, account_status, password_profile,authentication_type
 2* from v$pwfile_users
SQL> /

USERNAME   SYSDB ACCOUNT_ST PASSWORD_PROFILE AUTHENTI
---------- ----- ---------- -------------------- --------
SYS   TRUE  OPEN PASSWORD
SYSTEM   TRUE  OPEN PASSWORD

SQL> conn system
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied



Warning: You are no longer connected to ORACLE.
SQL> show user
USER is ""

[rock_it_pc1@localhost dbs]$ rm orapwSALESPRD
[rock_it_pc1@localhost dbs]$ ls -trlh
total 11M
-rw-r--r--. 1 rock_it_pc1 rock_it_pc1 3.1K May 14  2015 init.ora
-rw-rw----. 1 rock_it_pc1 rock_it_pc1  11M Sep 25 23:59 snapcf_SALESPRD.f
-rw-rw-r--. 1 rock_it_pc1 rock_it_pc1 1.8K Sep 26 04:46 initSALESPRD.ora
-rw-rw----. 1 rock_it_pc1 rock_it_pc1   24 Sep 27 22:40 lkSALESPRD
-rw-r-----. 1 rock_it_pc1 rock_it_pc1 2.0K Sep 28 01:19 orapwSALESPRDSBY
-rw-rw----. 1 rock_it_pc1 rock_it_pc1 1.6K Sep 28 13:52 hc_SALESPRD.dat
-rw-rw----. 1 rock_it_pc1 rock_it_pc1 4.5K Sep 28 13:52 spfileSALESPRD.ora
-rw-rw-r--. 1 rock_it_pc1 rock_it_pc1  100 Sep 28 14:05 afiedt.buf
[rock_it_pc1@localhost dbs]$ rm orapwSALESPRDSBY
[rock_it_pc1@localhost dbs]$ ls -trlh
total 11M
-rw-r--r--. 1 rock_it_pc1 rock_it_pc1 3.1K May 14  2015 init.ora
-rw-rw----. 1 rock_it_pc1 rock_it_pc1  11M Sep 25 23:59 snapcf_SALESPRD.f
-rw-rw-r--. 1 rock_it_pc1 rock_it_pc1 1.8K Sep 26 04:46 initSALESPRD.ora
-rw-rw----. 1 rock_it_pc1 rock_it_pc1   24 Sep 27 22:40 lkSALESPRD
-rw-rw----. 1 rock_it_pc1 rock_it_pc1 1.6K Sep 28 13:52 hc_SALESPRD.dat
-rw-rw----. 1 rock_it_pc1 rock_it_pc1 4.5K Sep 28 13:52 spfileSALESPRD.ora
-rw-rw-r--. 1 rock_it_pc1 rock_it_pc1  100 Sep 28 14:05 afiedt.buf
[rock_it_pc1@localhost dbs]$ orapwd file=orapwSALESPRD password=password format=12 entries=25 ignorecase=y
[rock_it_pc1@localhost dbs]$ ls -trlh
total 11M
-rw-r--r--. 1 rock_it_pc1 rock_it_pc1 3.1K May 14  2015 init.ora
-rw-rw----. 1 rock_it_pc1 rock_it_pc1  11M Sep 25 23:59 snapcf_SALESPRD.f
-rw-rw-r--. 1 rock_it_pc1 rock_it_pc1 1.8K Sep 26 04:46 initSALESPRD.ora
-rw-rw----. 1 rock_it_pc1 rock_it_pc1   24 Sep 27 22:40 lkSALESPRD
-rw-rw----. 1 rock_it_pc1 rock_it_pc1 1.6K Sep 28 13:52 hc_SALESPRD.dat
-rw-rw----. 1 rock_it_pc1 rock_it_pc1 4.5K Sep 28 13:52 spfileSALESPRD.ora
-rw-rw-r--. 1 rock_it_pc1 rock_it_pc1  100 Sep 28 14:05 afiedt.buf
-rw-r-----. 1 rock_it_pc1 rock_it_pc1 2.0K Sep 28 14:19 orapwSALESPRD
[rock_it_pc1@localhost dbs]$ lsnrctl stop SALESPRD

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 28-SEP-2023 14:20:36

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
The command completed successfully
[rock_it_pc1@localhost dbs]$ lsnrctl start SALESPRD

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 28-SEP-2023 14:20:44

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/19.0.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/salesprd/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     SALESPRD
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                28-SEP-2023 14:20:44
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/salesprd/alert/log.xml
Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "salesprd" has 1 instance(s).
 Instance "salesprd", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

[rock_it_pc1@localhost dbs]$ sqlplus sys/password@SALESPRD as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 28 14:21:31 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


[rock_it_pc1@localhost dbs]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 28 14:21:51 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[rock_it_pc1@localhost dbs]$ sqlplus sys/password@SALESPRD as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 28 14:22:41 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 4865390248 bytes
Fixed Size    8906408 bytes
Variable Size  905969664 bytes
Database Buffers 3942645760 bytes
Redo Buffers    7868416 bytes
Database mounted.
Database opened.
SQL> select username, sysdba from v$pwfile_users;

USERNAME
--------------------------------------------------------------------------------
SYSDB
-----
SYS
TRUE

Back to square one. Please help. help
Re: RMAN-00554 RMAN-04006 [message #689149 is a reply to message #689148] Thu, 28 September 2023 13:44 Go to previous messageGo to next message
John Watson
Messages: 8916
Registered: January 2010
Location: Global Village
Senior Member
Your password file has the instance name in upper case, that needs to be lower to match what you have in listener.ora. In fact, case sensitivity seems to be an issue all over the place, there may be a few more things that need to be fixed.

You have not used [code] tags as I asked to format your copy/pastes. Please do so in future.
Re: RMAN-00554 RMAN-04006 [message #689152 is a reply to message #689149] Thu, 28 September 2023 15:16 Go to previous messageGo to next message
LIPEKA
Messages: 9
Registered: September 2023
Junior Member
John Watson wrote on Thu, 28 September 2023 13:44
Your password file has the instance name in upper case, that needs to be lower to match what you have in listener.ora. In fact, case sensitivity seems to be an issue all over the place, there may be a few more things that need to be fixed.

You have not used [code] tags as I asked to format your copy/pastes. Please do so in future.

I did change instance name in listener.ora from salesprd to SALESPRD. restarted OS, recreated password with orapwSALESPRD. same result.
*Note: I do not have a sqlnet.ora file in my $ORACLE_HOME/dbs folder. Can this inability to connect with password linked to this? Just checking since I read someone make mention of it without offering solution.



[rock_it_pc1@localhost ~]$ . .profile_19c
[rock_it_pc1@localhost ~]$ cd $TNS_ADMIN
[rock_it_pc1@localhost admin]$ ls -trlh
total 28K
-rw-r--r--. 1 rock_it_pc1 rock_it_pc1 1.5K Feb 13  2018 shrept.lst
drwxr-xr-x. 2 rock_it_pc1 rock_it_pc1   64 Apr 17  2019 samples
-rw-rw-r--. 1 rock_it_pc1 rock_it_pc1   52 Sep 20 03:31 afiedt.buf
-rw-r-----. 1 rock_it_pc1 rock_it_pc1 1.6K Sep 27 07:44 listener.ora.original
-rw-rw-r--. 1 rock_it_pc1 rock_it_pc1 1.2K Sep 27 07:44 tnsnames.ora.original
-rw-rw-r--. 1 rock_it_pc1 rock_it_pc1 1.2K Sep 27 07:48 tnsnames.ora
-rw-rw-r--. 1 rock_it_pc1 rock_it_pc1  104 Sep 27 23:34 sqlnet.ora.bky
-rw-r-----. 1 rock_it_pc1 rock_it_pc1 1.7K Sep 28 15:06 listener.ora
[rock_it_pc1@localhost admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

#######################################

# For Primay

####################################

SALESPRD =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
       (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) # I use this when not using dataguard
      # (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.230)(PORT = 1522)) # use this home for dataguar
     # (ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.82.138)(PORT = 1522)) # use this when at home or anywhere
       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
       )
    )
  )



SID_LIST_SALESPRD =
  (SID_LIST =
    (SID_DESC =
       (ORACLE_HOME = /u01/app/oracle/product/19.0.0/dbhome_1)
       (SID_NAME = [color=red]SALESPRD[/color])
     # (SID_NAME = salesprd)
      (ENVS="TNS_ADMIN=/u01/app/oracle/product/19.0.0/dbhome_1/network/admin")
    )

 )


ADR_BASE_LISTENER=/u01/app/oracle





[rock_it_pc1@localhost admin]$ lsnrctl start SALESPRD

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 28-SEP-2023 16:00:17

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/19.0.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/salesprd/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     SALESPRD
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                28-SEP-2023 16:00:19
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/salesprd/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "SALESPRD" has 1 instance(s).
  Instance "SALESPRD", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[rock_it_pc1@localhost admin]$ cd ../..;cd dbs
[rock_it_pc1@localhost dbs]$ ls -trlh
total 11M
-rw-r--r--. 1 rock_it_pc1 rock_it_pc1 3.1K May 14  2015 init.ora
-rw-rw----. 1 rock_it_pc1 rock_it_pc1  11M Sep 25 23:59 snapcf_SALESPRD.f
-rw-rw-r--. 1 rock_it_pc1 rock_it_pc1 1.8K Sep 26 04:46 initSALESPRD.ora
-rw-rw----. 1 rock_it_pc1 rock_it_pc1   24 Sep 27 22:40 lkSALESPRD
-rw-rw-r--. 1 rock_it_pc1 rock_it_pc1  100 Sep 28 14:05 afiedt.buf
-rw-r-----. 1 rock_it_pc1 rock_it_pc1 2.0K Sep 28 14:23 orapwSALESPRD
-rw-rw----. 1 rock_it_pc1 rock_it_pc1 4.5K Sep 28 14:23 spfileSALESPRD.ora
-rw-rw----. 1 rock_it_pc1 rock_it_pc1 1.6K Sep 28 15:20 hc_SALESPRD.dat
[rock_it_pc1@localhost dbs]$ [color=red]rm orapwSALESPRD[/color]
[rock_it_pc1@localhost dbs]$ ls -trlh
total 11M
-rw-r--r--. 1 rock_it_pc1 rock_it_pc1 3.1K May 14  2015 init.ora
-rw-rw----. 1 rock_it_pc1 rock_it_pc1  11M Sep 25 23:59 snapcf_SALESPRD.f
-rw-rw-r--. 1 rock_it_pc1 rock_it_pc1 1.8K Sep 26 04:46 initSALESPRD.ora
-rw-rw----. 1 rock_it_pc1 rock_it_pc1   24 Sep 27 22:40 lkSALESPRD
-rw-rw-r--. 1 rock_it_pc1 rock_it_pc1  100 Sep 28 14:05 afiedt.buf
-rw-rw----. 1 rock_it_pc1 rock_it_pc1 4.5K Sep 28 14:23 spfileSALESPRD.ora
-rw-rw----. 1 rock_it_pc1 rock_it_pc1 1.6K Sep 28 15:20 hc_SALESPRD.dat
[rock_it_pc1@localhost dbs]$ [color=green]orapwd file=orapwSALESPRD password=password format=12 entries=25 ignorecase=y[/color]
[rock_it_pc1@localhost dbs]$ ls -trlh
total 11M
-rw-r--r--. 1 rock_it_pc1 rock_it_pc1 3.1K May 14  2015 init.ora
-rw-rw----. 1 rock_it_pc1 rock_it_pc1  11M Sep 25 23:59 snapcf_SALESPRD.f
-rw-rw-r--. 1 rock_it_pc1 rock_it_pc1 1.8K Sep 26 04:46 initSALESPRD.ora
-rw-rw----. 1 rock_it_pc1 rock_it_pc1   24 Sep 27 22:40 lkSALESPRD
-rw-rw-r--. 1 rock_it_pc1 rock_it_pc1  100 Sep 28 14:05 afiedt.buf
-rw-rw----. 1 rock_it_pc1 rock_it_pc1 4.5K Sep 28 14:23 spfileSALESPRD.ora
-rw-rw----. 1 rock_it_pc1 rock_it_pc1 1.6K Sep 28 15:20 hc_SALESPRD.dat
-rw-r-----. 1 rock_it_pc1 rock_it_pc1 2.0K Sep 28 16:02 orapwSALESPRD
[rock_it_pc1@localhost dbs]$ lsnrctl stop SALESPRD

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 28-SEP-2023 16:02:49

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
The command completed successfully

[rock_it_pc1@localhost dbs]$ lsnrctl start SALESPRD

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 28-SEP-2023 16:05:14

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/19.0.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/salesprd/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     SALESPRD
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                28-SEP-2023 16:05:14
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/salesprd/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "SALESPRD" has 1 instance(s).
  Instance "SALESPRD", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[rock_it_pc1@localhost dbs]$ [color=red]tnsping SALESPRD[/color]

TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 28-SEP-2023 16:05:35

Copyright (c) 1997, 2019, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))) (CONNECT_DATA = (SID = SALESPRD)))
OK (0 msec)
[rock_it_pc1@localhost dbs]$ [color=red]sqlplus sys/password@SALESPRD as sysdba[/color]

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 28 16:06:30 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

ERROR:
ORA-01017:[color=red] invalid username/password; logon denied[/color]


Enter user-name: sys as sysdba
Enter password: 
Connected to an idle instance.

SQL> 









Re: RMAN-00554 RMAN-04006 [message #689154 is a reply to message #689152] Thu, 28 September 2023 15:55 Go to previous messageGo to next message
John Watson
Messages: 8916
Registered: January 2010
Location: Global Village
Senior Member
So you have not yet changed the name of the password file? It has to match the name of the instance. You need to be consistent with this. The instance name: the parameter instance_name in your spfile.

(ps - code tags! Yeah!!)
Re: RMAN-00554 RMAN-04006 [message #689156 is a reply to message #689154] Thu, 28 September 2023 16:26 Go to previous messageGo to next message
LIPEKA
Messages: 9
Registered: September 2023
Junior Member
John,

I have changed the nomemclature in the listener.ora from (SID = salesprd )  to (SID = SALESPRD) , the I have recreated the password file with orapwSALESPRD. I follow your instruction. the Change was made in the listener.ora. Please advise how to proceed
Re: RMAN-00554 RMAN-04006 [message #689160 is a reply to message #689156] Fri, 29 September 2023 01:22 Go to previous messageGo to next message
John Watson
Messages: 8916
Registered: January 2010
Location: Global Village
Senior Member
To repeat: you need to change the name of your password file. IT has to match the name of the instance. Do you actually know the name of your instance? You have not shown it so far.
Re: RMAN-00554 RMAN-04006 [message #689174 is a reply to message #689160] Fri, 29 September 2023 14:09 Go to previous messageGo to next message
LIPEKA
Messages: 9
Registered: September 2023
Junior Member
John Watson wrote on Fri, 29 September 2023 01:22
To repeat: you need to change the name of your password file. IT has to match the name of the instance. Do you actually know the name of your instance? You have not shown it so far.

I did change it to lowercase orapwsalesprd . when I do that and run sql>select username, sysdba from v$pwfile_users; it returns no row selected. When I go back and recreated in as orapwSALESPRD  it works fine. I believe the issue is not on the upper/lower case but somewhere else. I have struggled with this for now 8 days in a row. See below what you have requested.

   

SQL> select instance_name, host_name,instance_role, instance_mode, database_type , status from v$instance;

INSTANCE_N HOST_NAME  INSTANCE_R INSTANCE_MO DATABASE_TYPE   STATUS
---------- ---------- ---------- ----------- --------------- ------------
SALESPRD   localhost. PRIMARY_IN REGULAR     SINGLE	     OPEN
	   localdomai STANCE
	   n



Re: RMAN-00554 RMAN-04006 [message #689175 is a reply to message #689174] Fri, 29 September 2023 14:24 Go to previous messageGo to next message
John Watson
Messages: 8916
Registered: January 2010
Location: Global Village
Senior Member
This is getting confusing! Earlier we had this,
Service "salesprd" has 1 instance(s).
 Instance "salesprd", status UNKNOWN, has 1 handler(s) for this service...
but now we have
Service "SALESPRD" has 1 instance(s).
  Instance "SALESPRD", status UNKNOWN, has 1 handler(s) for this service...


Re: RMAN-00554 RMAN-04006 [message #689176 is a reply to message #689175] Fri, 29 September 2023 14:59 Go to previous message
LIPEKA
Messages: 9
Registered: September 2023
Junior Member
John Watson wrote on Fri, 29 September 2023 14:24
This is getting confusing! Earlier we had this,
Service "salesprd" has 1 instance(s).
 Instance "salesprd", status UNKNOWN, has 1 handler(s) for this service...
but now we have
Service "SALESPRD" has 1 instance(s).
  Instance "SALESPRD", status UNKNOWN, has 1 handler(s) for this service...

That is because I went into listener.ora/tnsnames.ora trying to put sid in upper case to match orapwSALESPRD or lower case to match orapwsalesprd   I now have it back to orapwSALESPRD
Previous Topic: Oracle Express - how to setup a DR standby server?
Goto Forum:
  


Current Time: Sat Feb 24 13:43:48 CST 2024