1. Key Software Oracle Olr Cannot Be Opened. Error 2

Key Software Oracle Olr Cannot Be Opened. Error 2

I have installed Oracle Express edition 11g, which was downloaded two days back. At the time of installation, I did not get any issues but when I try to start the server using Short Cut or SQL Developer am getting the exception. SQL Developer am getting exception in listener.log: 25-FEB-2016 17:51:37 * (CONNECT_DATA=(SID=xe)(CID=(PROGRAM=SQL Developer)(HOST=__jdbc__)(USER=joseph_mi))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=51245)) * establish * xe * 12505 TNS-12505: TNS:listener does not currently know of SID given in connect descriptor On trying following commands am getting below traces, Microsoft Windows [Version 6.3.9600] (c) 2013 Microsoft Corporation. Belajar membaca. All rights reserved. C: Users joseph_mi>tnsping o11gr2 TNS Ping Utility for 64-bit Windows: Version 11.2.0.2.0 - Production on 25-FEB-2 016 16:54:55 Copyright (c) 1997, 2014, Oracle. All rights reserved. Message 3511 not found; No message file for product=NETWORK, facility=TNSTNS-035 05: Message 3505 not found; No message file for product=NETWORK, facility=TNS C: Users joseph_mi>sqlplus system/password Error 6 initializing SQL*Plus SP2-0667: Message file sp1.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory C: Users joseph_mi>echo%ORACLE_SID%%ORACLE_SID% Log file has below error details: C: oraclexe app oracle product 11.2.0 server log lp_joseph_mi client Oracle Database 11g Clusterware Release 11.2.0.2.0 - Production Copyright 1996, 2010 Oracle.