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.
Showing posts with label ORA Errors. Show all posts
Showing posts with label ORA Errors. Show all posts
Friday, September 9, 2011
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;
*
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
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;
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;
Subscribe to:
Posts (Atom)