Hi everyone,
everyday between 04:00am and 04:30am a lot of errors appear in alert log:
Fatal NI connect error 12537, connecting to:
(LOCAL=NO)
nt OS err code: 0
Time: 26-JAN-2016 04:27:09
VERSION INFORMATION:
TNS for Solaris: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Solaris: Version 11.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Solaris: Version 11.2.0.1.0 - Production
Time: 26-JAN-2016 04:27:09
TNS-12537: TNS:connection closed
ns secondary err code: 12560
Tracing not turned on.
ns secondary err code: 12560
Tns error struct:
TNS-12537: TNS:connection closed
Tns error struct:
VERSION INFORMATION:
TNS for Solaris: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Solaris: Version 11.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Solaris: Version 11.2.0.1.0 - Production
ns main err code: 12537
TNS-12537: TNS:connection closed
nt main err code: 0
nt main err code: 0
Tns error struct:
ns secondary err code: 12560
Tracing not turned on.
ns main err code: 12537
Time: 26-JAN-2016 04:27:09
ns secondary err code: 12560
ns main err code: 12537
nt main err code: 0
ns main err code: 12537
nt secondary err code: 0
nt main err code: 0
Tracing not turned on.
Tns error struct:
nt secondary err code: 0
Tue Jan 26 04:27:09 2016
opiodr aborting process unknown ospid (22786) as a result of ORA-609
opiodr aborting process unknown ospid (22810) as a result of ORA-609
Tue Jan 26 04:27:13 2016
RSM0 started with pid=79, OS id=22835
Tue Jan 26 04:27:16 2016
Tue Jan 26 04:27:16 2016
opiodr aborting process unknown ospid (22780) as a result of ORA-609
opiodr aborting process unknown ospid (22764) as a result of ORA-609
opiodr aborting process unknown ospid (22768) as a result of ORA-609
There is a cron job that starts rman backup script at 04:00am. Here is the script:
#!/usr/bin/bash
export ORACLE_SID=DB1
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.1/db_1
export PATH=$ORACLE_HOME/bin:$PATH
rman target / log /tmp/rman.log <<EOF
set encryption on identified by 'password' only;
run
{
crosscheck backup;
crosscheck archivelog all;
delete noprompt expired backup;
delete noprompt expired archivelog all;
backup as compressed backupset database format
'/disk1/oracle/rman_backup/DATA_%d_%T_%s_%c.bak' tag 'DATA'
plus archivelog format
'/disk1/oracle/rman_backup/ARC_%d_%T_%s_%c.bak' tag 'ARCHIVE';
backup current controlfile format
'/disk1/oracle/rman_backup/CONTROL_%d_%T_%s_%c.bak' tag='CONTROLFILE';
backup spfile format
'/disk1/oracle/rman_backup/SPFILE_%d_%T_%s_%c.bak' tag='SPFILE BACKUP';
}
delete noprompt obsolete;
EOF
I don't understand why rman backup causes these errors?
OS: Oracle Solaris 10 8/11 s10s_u10wos_17b SPARC
Oracle: 11.2.0.1.0