Enabling tracing for oracle LISTENER

Background: For the oracle errors like “ORA-12170: TNS:Connect timeout occurred”, “ORA-12535: TNS:operation timed out”, “ORA-12560: TNS:protocol adapter error”, “TNS-00505: Operation timed out” and like others related to oracle listener it is useful of tracing the listener activities to dig down further. Workaround: Connect to the listener control utility from the command line or shell. LSNRCTL…

Linked tables having Calculated field can’t be made Local in MS Access 2016

Background: For the purpose of taking backup of the MS access database, VBA script failed for one of the tables of the source database, showing “Property not found Error: 3270“. Resolution: Compact and repairing didn’t solve the issue, recreated the table also didn’t help. Upon further dig down its been observed that removing the “Calculated”…

Oracle-Error: opiodr aborting process unknown ospid ( ) as a result of ORA-609

Background: After shutdown and restarted the oracle instance by an executive, client can’t connect to database instance though database is up and running and listener service is up. OS: Windows Server 2012 x64, Oracle: 11g R2, Data Guard Configured Workaround: From the alert_SID.log file found the below error raised after shutdown and consecutive startup and when…

MS Access Error: 3162: “You tried to assign the Null value to a variable that is not a Variant data type.”

Background: All of a sudden importing data from spreadsheet in a form produced the above error(it was tested and worked fine over two weeks), the same operation in another form is executing fine. This is bit frustrating when everything seems fine, no errors in logic or elsewhere but things are not working. Solution: Digging down further…

MS Access Tutorial: Displaying an alert message when recordset returns no value

Background: To make the user interface more friendly in nature it’s a good approach displaying an Alert Message when MS Access Query returns no value to its corresponding recordset. How To: By using the MS Access RecordsetClone and RecordCount Property we can return a message with an empty recordset. If Me.RecordsetClone.RecordCount <= 0 Then MsgBox (“No records…

Database design migration from SQL Server to Oracle by Enterprise Architect

Database design migration from SQL Server to Oracle by Enterprise Architect

Background: One of my development project initially was on SQL Server as backend database. But consistently facing problem of ‘ODBC failed to connect’ throughout a year. The database was the SQL Server XE. Convinced to transfer my database to Oracle as it is very reliable on ODBC connection. So intended to initiate a database design migration from…

Oracle Error: No listener – LISTENER failing to start upon windows startup

Case: Today morning on my development machine (Windows 10 ) I can’t login to the oracle schema with toad or from my application showing Oracle Error : No listener. Upon further investigation found that listener is not starting Automatically though its service configured to run automatically. Workaround: To resolve the “No Listener”, restarted workstation several times after changes…

Oracle Tutorial: Using single-row or multiple-row functions to customize output

This Oracle Tutorial: Using single-row or multiple-row functions contains the lessons mentioned below: Types of SQL Functions Single Row Functions Number Functions Character Functions Date Functions Conversion Functions General Functions Multiple Row/Aggregate Functions Restricting Group results With HAVING Clause Nesting Group Functions Download: Using single-row or multiple-row functions to customize output

Oracle Tutorial: SQL SELECT Statements

I had to arrange training session over Database Management System to my colleagues which used oracle as backend. This “Oracle Tutorial: SQL SELECT Statements” is about basics of DBMS, SQL and SELECT statements. Includes: Types of SQL statement Arithmetic Operators and Precedence Null Values Column Alias Concatenation Operator/Literal Character String Duplicate Rows/DISTINCT keyword Download: SQL Select…