ERROR ssl: nzos_Handshake failed, ret=29024

Today i faced an interesting issue with dbconsole.While stopping the dbconsole, it showed Failed. -bash-3.00$ emctl stop dbconsole Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0 Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved. http://node1:1158/em/console/aboutApplication Stopping Oracle Enterprise Manager 10g Database Control ............. --- Failed to shutdown DBConsole Gracefully --- failed. Lets check the …

Advertisement

Read Only Vs Offline Tablespace

"What is the difference between Read-Only tablespace and Offline tablespace, in terms of SCNs??"This was asked to me long time back.As per the Books,making a tablespace read-only prevents write operations on the datafiles in the tablespace.Bringing an online tablespace offline, makes the schema objects within the tablespace unavailable to the database users.But still i think …

ORA-00600: [4194], [a], [b]

One of the servers having 2 single instance databases hosted on it,was having some I/O issue.The control files, redo log files and the data files for both the database were present on these two mount points. bash-3.00$ cd /disk1 bash-3.00$ ls -lrt .: I/O error bash-3.00$ cd /disk2 bash-3.00$ ls -lrt .: I/O error Cause …

Online Redo Logfiles – In Physical Standby

Recently, i was asked, how to add the Online Redo Logfile to the Standby database, as the parameter log_file_name_convert was set wrong on the Standby database.When i heard the question, i was confused.Though for a moment, and it suddenly hit to my mind "What is the need of Online Redo Logfiles in the Standby database.The …

Row Cache Lock – An interesting case

Suddenly today morning i was reported that an Import is hanging.The dumpfile was of 1Gb  containing few small tables.Immediately, i checked what all are the sessions belonging to impdp and what is session wait for them.Knowing the session wait makes things easier to analyze. As the import was started by 'SYSTEM' SELECT NVL(a.username, '(oracle)') AS …