Hi Guys,
I really need some serious advice here. Allow me brief you on what happened.
All this time my Oracle server was running fine, until one day someone changed the hostname of the Oracle server without any clue of consequence of doing so.
Then I restarted the server few days ago and found out that I could not access Oracle DB and the listener could not be started.
I edited the hostname on listener.ora and tnsnames.ora files and the listener could start successfully.
However, I could not connect to Oracle database unless I logged in using sysdba account.
I removed previous DBConsole Repository and replaced CONTROL02.CTL file in order to match CONTROL01.CTL file in D:\app\Administrator\oradata\PIRDB folder
But this is as far as I can get. Below are some command results which might help troubleshooting. Any advice will be much appreciated.
SQL> connect
Enter user-name: SYSTEM
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
Warning: You are no longer connected to ORACLE.
SQL>
SQL> select name, open_mode, database_role from v$database;
SP2-0640: Not connected
SQL> connect as sysdba
Enter user-name: sys
Enter password:
Connected.
SQL> select name, open_mode, database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
PIRDB MOUNTED PRIMARY
SQL> select instance_name, status, database_status from v$instance;
INSTANCE_NAME STATUS DATABASE_STATUS
---------------- ------------ -----------------
pirdb MOUNTED ACTIVE
D:\app\Administrator\product\11.2.0\dbhome_1\BIN>lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 30-JUL-2016 15:13
:26
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 30-JUL-2016 10:11:04
Uptime 0 days 5 hr. 2 min. 22 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\Administrator\product\11.2.0\dbhome_1\network\a
dmin\listener.ora
Listener Log File d:\app\administrator\diag\tnslsnr\068-RWS-01\listener\
alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=068-RWS-01)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "pirdb" has 1 instance(s).
Instance "pirdb", status READY, has 1 handler(s) for this service...
The command completed successfully