Dear All,
I am facing below mentioned error when i try to connect instance,
C:\Documents and Settings\mit1287>SET ORACLE_SID=MEDI
C:\Documents and Settings\mit1287>SQLPLUS
SQL*Plus: Release 11.2.0.1.0 Production on Thu May 14 16:25:37 2015
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: SYS@MEDI
Enter password:
ORA-12528: TNS listener- all appropriate instances are blocking new connections.
When i googled, i found one solution that need to add
(UR = A) in the tnsnames.ora.
I added that and when i try to connect database, I am facing new error like below,
C:\Documents and Settings\mit1287>SET ORACLE_SID=MEDI
C:\Documents and Settings\mit1287>SQLPLUS
SQL*Plus: Release 11.2.0.1.0 Production on Thu May 14 16:25:37 2015
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: SYS@MEDI
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Please find below some of latest alert log entries
All dispatchers and shared servers shutdown
alter database close normal
ORA-1507 signalled during: alter database close normal...
Thu May 14 15:20:05 2015
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile D:\APP\MIT1003\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEMEDI.ORA
System parameters with non-default values:
processes = 150
memory_target = 1232M
control_files = "D:\APP\MIT1003\ORADATA\MEDI\CONTROL01.CTL"
control_files = "D:\APP\MIT1003\FLASH_RECOVERY_AREA\MEDI\CONTROL02.CTL"
db_block_size = 8192
compatible = "11.2.0.0.0"
db_recovery_file_dest = "D:\app\mit1003\flash_recovery_area"
db_recovery_file_dest_size= 4977M
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=mediXDB)"
audit_file_dest = "D:\APP\MIT1003\ADMIN\MEDI\ADUMP"
audit_trail = "DB"
db_name = "medi"
open_cursors = 300
diagnostic_dest = "D:\APP\MIT1003"
Thu May 14 15:20:06 2015
PMON started with pid=2, OS id=776
Thu May 14 15:20:06 2015
VKTM started with pid=3, OS id=468 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Thu May 14 15:20:06 2015
GEN0 started with pid=4, OS id=356
Thu May 14 15:20:06 2015
DIAG started with pid=5, OS id=1544
Thu May 14 15:20:06 2015
DBRM started with pid=6, OS id=1820
Thu May 14 15:20:06 2015
PSP0 started with pid=7, OS id=3184
Thu May 14 15:20:06 2015
DIA0 started with pid=8, OS id=1920
Thu May 14 15:20:06 2015
MMAN started with pid=9, OS id=2760
Thu May 14 15:20:06 2015
DBW0 started with pid=10, OS id=1604
Thu May 14 15:20:06 2015
LGWR started with pid=11, OS id=3476
Thu May 14 15:20:06 2015
CKPT started with pid=12, OS id=3432
Thu May 14 15:20:06 2015
SMON started with pid=13, OS id=756
Thu May 14 15:20:06 2015
RECO started with pid=14, OS id=2772
Thu May 14 15:20:06 2015
MMON started with pid=15, OS id=2056
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu May 14 15:20:06 2015
MMNL started with pid=16, OS id=1176
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\app\mit1003
Thu May 14 15:20:06 2015
alter database mount exclusive
ORA-214 signalled during: alter database mount exclusive...
Can you please help me to resolve this issue?