Oracle SHARED mode server confiuguration error ORA-12523

Summary Configure the Shared mode for Oracle connection, it failed and returned ORA-12523, found out it is mandatory to configure local listener. 本地监听的配置是必须的。 Configure Shared server mode ‘listener.ora’ was configured as below, LISTENER3 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ocp)(PORT = 1523)) ) LISTENER2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST […]

Running GUI application as another (non-root) user – Netmgr

Summary I can open the Netmgr in the Xshell through Xmanager without any issue. There was problem to do so using Oracle user under xWindows. Resolved it by setting “DISPLAY=:0.0”. Problem Need to use Netmgr GUI in xWindows. Error as below, [tom@ocp ~]$ netmgr ****DISPLAY environment variable not set! Oracle Net Manager is a GUI […]

India Mumbai, Pune trip – 1 – Air flight

I was on business trip to India Mumbai and Pune from 30th Nov. 2018 to 14th Dec. 2018, stayed 14 days in India. There is no direct flight from Singapore to Pune, I took Jet Aireways from Singapore to Delhi, then took domestic air flight transferred from Delhi to Pune. Singapore to Pune. FRI 30NOV […]

Oracle Start listener and Start OEM

Encountered SQL developer- the network adapter could not establish the connection, it is quite simple, the Oracle listener was not start up. Resolved by below command, after startup the listener, can connect through SQL developer with successful result. Error 1: Oracle SQL Developer error – IO Error: The Network Adapter could not establish the connection. […]

“ORA-01034: ORACLE not available” resolved

Summary Encountered problem cannot login Oracle by login name and password “system/oracle”, resolved this issue by changed the kernal parameter kernel.sem in sysctl.conf. Problem Encountered ORA-01034 and ORA-27101 as below, [tom@ocp ~]$ [tom@ocp ~]$ sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on 星期四 12月 20 20:42:24 2018 Copyright (c) 1982, 2009, Oracle. All rights reserved. SQL> […]

Keil copy out memory data when debugging

How to copy out the memory data from Keil when debugging, in command window, you can use Display command fetch the memory data, example: d 0x2000293C,0x20002984 0x2000293C C8 CC 9D 5F F2 EB FA D7 – AE 26 5F 5F BA 41 7D D3 …_…..&__.A}. 0x2000294C 4E 54 F3 F8 8C 62 E5 AD – […]

NUS MBA Corporate Photoshoot session

Student council organized NUS MBA Corporate Photoshoot Session, on 10 November 2018, Saturday, 10:00 – 13:00 at Mochtar Riady Building. The The payment was S$35 by cash. 15 photos were sent to me through Dropbox to choose out 2 photos to be edited, editing includes exposure, composition, backdrop cleaning and light face touch ups. I […]

Goodbye, my Samsonite suite case

My Samsonite suite case was totally damaged, need a new replacement. I would buy a new one from Taobao/Tmall with a Chinese brand, as long as buy it on Tmall, the quality will be quite okay, and it will be much cheaper than Samsonite. I have used this luggage case for so long time and […]

Zhuhai China trip 21 Nov to 24 Nov through HK-Zhuhai-Macau Bridge

Summary I went to Zhuhai China from 21st Nov to 24th Nov’18, the most convenient route was going through Hong Kong, and taking bus through Hong Kong Zhuhai Macau bridge, as you could take bus any time. You will have follow the fixed schedule to take boat between Hong Kong and Zhuhai. Hotel at Zhuhai, […]

Hongkong trip 14th to 16th Sep’18

Summary Arranged Hongkong trip from 14th to 16th Sep’18, stuck at Shenzhen because of Typhoon Mangkhut, returned back to Singapore on 18th Sep.18. Itinerary Air ticket, – Singapore to Shenzhen Flight CZ8500 Departure 03:20am 14th Sep. Changi International Airport, Terminal 1 Arrival 07:30am 14th Sep.18 Baoan Airport, Terminal 3 – Shenzhen to Singapore Flight CZ8499 […]