Showing posts with label ORA Errors. Show all posts
Showing posts with label ORA Errors. Show all posts

Friday, September 9, 2011

TNS-12547: TNS:lost contact,Linux Error: 104: Connection reset by peer

Error:

TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 104: Connection reset by peer

Solution:

Make sure the loopback entry in /etc/hosts is not missing when you start the listener:
127.0.0.1 localhost.localdomain localhost
Now try to run lsnrctl start as oracle again.

Saturday, July 9, 2011

ORA-04063: package body "SYS.DBMS_REGISTRY_SYS" has errors while running utlrp...

SELECT dbms_registry_sys.time_stamp('utlrp_end') as timestamp from dual
*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_REGISTRY_SYS" has errors


BEGIN dbms_registry_sys.validate_components; END;

*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_REGISTRY_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"SYS.DBMS_REGISTRY_SYS"
ORA-06512: at line 1


Solution:
1.shutdown immediate
2.startup upgrade
3.run catalog and catproc scritp
4.run utlrp
5.shutdown immediate
6.startup
7.select comp_name,version,status from dba_registry;

Sunday, July 3, 2011

Error: ORA-16606: unable to find property,Warning: ORA-16826: apply service state is inconsistent with the DelayMins property

DGMGRL> show configuration

Configuration
Name: DRS
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
starprim - Primary database
starstby - Physical standby database

Current status for "DRS":
Warning: ORA-16608: one or more databases have warnings


DGMGRL> show configuration 'starprim'
Error: ORA-16606: unable to find property "starprim"
Warning: ORA-16826: apply service state is inconsistent with the DelayMins property


Error: ORA-16501: the Data Guard broker operation failed

DGMGRL> show configuration 'starstby'
Error: ORA-16606: unable to find property "starstby"
Warning: ORA-16826: apply service state is inconsistent with the DelayMins property


Error: ORA-16501: the Data Guard broker operation failed



DGMGRL> DGMGRL> show configuration 'starprim'
Error: ORA-16606: unable to find property "starprim"

Error: ORA-16501: the Data Guard broker operation failed

Solution:

DGMGRL> disable configuration
Disabled.
DGMGRL> enable configuration
Enabled.



DGMGRL> DGMGRL>
Configuration
Name: DRS
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
starprim - Primary database
starstby - Physical standby database

Current status for "DRS":
SUCCESS

Wednesday, November 4, 2009

ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],[], [], []

SQL> startup
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1266392 bytes
Variable Size 67112232 bytes
Database Buffers 96468992 bytes
Redo Buffers 2924544 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],[], [], []

workaround:

Step 1:
Shutdown immediate
Step 2:
Startup mount
Step 3:
Recover database;
Step 4:
Alter database open;