Hi All, I'm pretty new to Instillation/configuration area and with the help of google/YouTube docs/videos shared by all of you started my Hyperion EPM suite 11.2.1.4 installation Journey month ago by overcoming many hurdles and finally able to install and configure successfully and everything seems working fine for the first time..
when i had check the listener status after first time installation and before restart of server it was showing the status is ready to accept the connections for instance ORCL and DB is up and running fine..I think this is the Dynamic listener where the newly created instance is getting registered after DB installation.
after first time installation .
the real nightmare started when I have restarted the server.. unable to connect DB and getting the below error
when I restarted the server my listener status is being changed as below. and getting the below DB error when I'm trying to connect.
Ora-01034:Oracle not available
Ora-27101: shared memory realm does not exist
Procee ID:0
Session ID:0 Serial number 0.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Prod
ction
Start Date 10-MAR-2016 11:45:39
Uptime 0 days 0 hr. 25 min. 32 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\admin\product\11.2.0\dbhome_1\network\admin\li
- tener.ora
Listener Log File c:\app\admin\diag\tnslsnr\SRIKANTH\listener\alert\log
xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
C:\Users\admin>
I think some environmental variable path setting(oracle home/SID) is been getting changed after server restart.. I have tried all possible options to crack this mystery but no use.
Database :-Oracle 11gR2 (Wind64)
OS--------------Windows Server-2012 R2 Essentials (installed on VMWARE)
RAM-16GB
Processor -core I7
final twist is when I uninstall the Hperion suit and delete all the Registry the DB is getting up and the listener status is showing ready.
can please help me to update what setting/path need to change after server restart to work the DB up
thanks in Advance