Home » Infrastructure » Windows » Error ORA-12505 tns listener does not currently know of sid given in connect descriptor (Oracle 10, Windows Server 2003)
Error ORA-12505 tns listener does not currently know of sid given in connect descriptor [message #648329] Sun, 21 February 2016 06:31 Go to next message
JeremyS
Messages: 10
Registered: February 2016
Location: FRANCE
Junior Member
Hello,

I have a problem with an Oracle application. Since i demoted domain controller on a server (Windows Server 2003), the application doesn't start. The error message appears : ORA-12505 tns listener does not currently know of sid given in connect descriptor.

I don't know Oracle but i searched without finding any solutions.

On the client computer, i found a tnsnames.ora file :

# C:\ORAWIN95\NET80\ADMIN\TNSNAMES.ORA Configuration File:C:\orawin95\net80\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant

CMEXAMPLE.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = tcp)(PORT = 1610)(HOST = CM_SERVER))
(ADDRESS = (PROTOCOL = tcp)(PORT = 1521)(HOST = LSNR_SERVER))
)
(CONNECT_DATA = (SID = ORCL))
(SOURCE_ROUTE = yes)
)

TCPEXAMPLE.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(Host = Production1)(Port = 1521))
(CONNECT_DATA = (SID = ORCL))
)

NMPEXAMPLE.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = NMP)(Server = FinanceServer1)(Pipe = ORAPIPE))
(CONNECT_DATA = (SID = ORCL))
)

GIMA8.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.5)(PORT = 1521))
(CONNECT_DATA = (SID = gima))
)

EXTPROC_CONNECTION_DATA.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(CONNECT_DATA = (SID = extproc))
)

BEQ-LOCAL.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = BEQ)(PROGRAM = oracle80)(ARGV0 = oracle80ORCL)(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))
(CONNECT_DATA = (SID = ORCL))
)

SPXEXAMPLE.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = SPX)(Service = Server_lsnr))
(CONNECT_DATA = (SID = ORCL))
)

TCP-LOOPBACK.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
(CONNECT_DATA = (SID = ORCL))
)



On the server computer i found a tnsnames.ora file too :

# tnsnames.ora Network Configuration File: D:\oracle\HomeVega10G\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

GIMA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.5)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = GIMA)
)
)

GIMA8 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.5)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = GIMA)
)
)


I found a listener.ora file on the server :

# listener.ora Network Configuration File
# Generated by Oracle configuration tools

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = d:\oracle\HomeVega10g)
(SID_NAME = VEGA)
)
)


LISTENER =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 192.168.10.5)
(PORT = 1521)
)
)



The services on the server :

OracleCSService (not started) Manual : i cannot start this service.
OracleJobSchedulerGIMA (started) Automatic
OracleJobSchedulerVEGA (started) Automatic
OracleOracleHomeVega10gSNMPPeerEncapsulator (not started) Manual
OracleOracleHomeVega10gSNMPPeerMasterAgent (not started) Manual
OracleOracleHomeVega10gTNSListener (started) Automatic
OracleOracleHomeVega10gTNSListenerGIMA (not started) Manual : i cannot start this service (it starts and stop immediately).
OracleServiceGIMA (started) Automatic


For information :

Application name : GIMA
Server ip address : 192.168.10.5
Ping server since client computer : OK (ip address and name).
No firewall on the client computer and server.
No antivirus.
Telnet 1521 on the server OK.
There is another application named VEGA on the server and there is no problem with this application.

Can you help me please ?

PS : Sorry for my English, i don't speak English very well !
Re: Error ORA-12505 tns listener does not currently know of sid given in connect descriptor [message #648330 is a reply to message #648329] Sun, 21 February 2016 07:28 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>PS : Sorry for my English, i don't speak English very well !
EXCELLENT post

post the actual complete command that produced the error

on the DB Server open Command Window & issue following OS commands

lsnrctl status
lsnrctl service

COPY the results from above then PASTE all back here
Re: Error ORA-12505 tns listener does not currently know of sid given in connect descriptor [message #648331 is a reply to message #648330] Sun, 21 February 2016 08:10 Go to previous messageGo to next message
JeremyS
Messages: 10
Registered: February 2016
Location: FRANCE
Junior Member
lsnrctl status :

LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 21-FEB-2016 15:07
:47

Copyright (c) 1991, 2004, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.5)(PORT=1521)
))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ
ction
Start Date 20-FEB-2016 14:14:52
Uptime 1 days 0 hr. 52 min. 55 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\oracle\HomeVega10G\network\admin\listener.ora
Listener Log File D:\oracle\HomeVega10G\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.5)(PORT=1521)))
Services Summary...
Service "VEGA" has 2 instance(s).
Instance "VEGA", status UNKNOWN, has 1 handler(s) for this service...
Instance "vega", status READY, has 1 handler(s) for this service...
The command completed successfully


lsnrctl service :

LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 21-FEB-2016 15:09
:18

Copyright (c) 1991, 2004, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.5)(PORT=1521)
))
Services Summary...
Service "VEGA" has 2 instance(s).
Instance "VEGA", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Instance "vega", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
The command completed successfully
Re: Error ORA-12505 tns listener does not currently know of sid given in connect descriptor [message #648332 is a reply to message #648331] Sun, 21 February 2016 08:22 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post excerpt from D:\oracle\HomeVega10G\network\log\listener.log that shows the 12505 status code
Re: Error ORA-12505 tns listener does not currently know of sid given in connect descriptor [message #648333 is a reply to message #648332] Sun, 21 February 2016 08:31 Go to previous messageGo to next message
JeremyS
Messages: 10
Registered: February 2016
Location: FRANCE
Junior Member
Excerpt from listener.log file :


TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production on 19-FEB-2016 08:36:37

Copyright (c) 1991, 2004, Oracle. All rights reserved.

System parameter file is D:\oracle\HomeVega10G\network\admin\listener.ora
Log messages written to D:\oracle\HomeVega10G\network\log\listener.log
Trace information written to D:\oracle\HomeVega10G\network\trace\listener.trc
Trace level is currently 0

Started with pid=2044
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.5)(PORT=1521)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
19-FEB-2016 08:37:04 * service_register * vega * 0
19-FEB-2016 08:38:04 * (CONNECT_DATA=(SID=gima)(CID=(PROGRAM=C:\Gima\v01_00\Bin\gima.exe)(HOST=ANGELE)(USER=ascordo))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.211)(PORT=1430)) * establish * gima * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
19-FEB-2016 08:38:22 * (CONNECT_DATA=(SID=gima)(CID=(PROGRAM=C:\Gima\v01_00\Bin\gima.exe)(HOST=ANGELE)(USER=ascordo))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.211)(PORT=1431)) * establish * gima * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
19-FEB-2016 08:40:01 * service_update * vega * 0
19-FEB-2016 08:41:07 * service_update * vega * 0
19-FEB-2016 08:47:08 * (CONNECT_DATA=(SID=gima)(CID=(PROGRAM=C:\Gima\v01_00\Bin\gima.exe)(HOST=ANGELE)(USER=ascordo))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.211)(PORT=1636)) * establish * gima * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
19-FEB-2016 08:51:10 * service_update * vega * 0
19-FEB-2016 08:57:14 * (CONNECT_DATA=(SID=gima)(CID=(PROGRAM=C:\Gima\v01_00\Bin\gima.exe)(HOST=ANGELE)(USER=ascordo))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.211)(PORT=1897)) * establish * gima * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
19-FEB-2016 09:01:13 * service_update * vega * 0
19-FEB-2016 09:06:40 * (CONNECT_DATA=(SID=gima)(CID=(PROGRAM=C:\Gima\v01_00\Bin\gima.exe)(HOST=ANGELE)(USER=ascordo))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.211)(PORT=2859)) * establish * gima * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
19-FEB-2016 09:10:43 * (CONNECT_DATA=(SID=gima)(CID=(PROGRAM=C:\Gima\v01_00\Bin\gima.exe)(HOST=ANGELE)(USER=ascordo))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.211)(PORT=2871)) * establish * gima * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
19-FEB-2016 09:11:16 * service_update * vega * 0
19-FEB-2016 09:12:28 * service_update * vega * 0
19-FEB-2016 09:14:07 * service_update * vega * 0
Re: Error ORA-12505 tns listener does not currently know of sid given in connect descriptor [message #648334 is a reply to message #648333] Sun, 21 February 2016 08:36 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Somebody is trying to connect to SID=gima, but the listener knows nothing about the GIMA database as shown by lsnrctl service output.

post tail end of alert_GIMA.log file.
Is the GIMA database up & online now?
Re: Error ORA-12505 tns listener does not currently know of sid given in connect descriptor [message #648335 is a reply to message #648334] Sun, 21 February 2016 08:50 Go to previous messageGo to next message
JeremyS
Messages: 10
Registered: February 2016
Location: FRANCE
Junior Member
I find 2 alert_gima.log files :

One in d:\oracle\admin\gima\bdump :

Thu Feb 18 12:00:39 2016
Private_strands 7 at log switch
Thread 1 advanced to log sequence 12650
Current log# 2 seq# 12650 mem# 0: D:\ORACLE\ORADATA\GIMA\REDO02.LOG
Thu Feb 18 17:34:09 2016
Starting background process EMN0
EMN0 started with pid=17, OS id=1212
Thu Feb 18 17:34:09 2016
Shutting down instance: further logons disabled
Thu Feb 18 17:34:09 2016
Stopping background process QMNC
Thu Feb 18 17:34:09 2016
Stopping background process CJQ0
Thu Feb 18 17:34:11 2016
Stopping background process MMNL
Thu Feb 18 17:34:12 2016
Stopping background process MMON
Thu Feb 18 17:34:13 2016
Shutting down instance (immediate)
License high water mark = 6
Thu Feb 18 17:34:13 2016
Stopping Job queue slave processes
Thu Feb 18 17:34:13 2016
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 83886080
large_pool_size = 8388608
java_pool_size = 50331648
control_files = D:\ORACLE\ORADATA\GIMA\CONTROL01.CTL, D:\ORACLE\ORADATA\GIMA\CONTROL02.CTL, D:\ORACLE\ORADATA\GIMA\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 10.1.0.2.0
db_file_multiblock_read_count= 16
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=GIMAXDB)
job_queue_processes = 10
background_dump_dest = D:\ORACLE\ADMIN\GIMA\BDUMP
user_dump_dest = D:\ORACLE\ADMIN\GIMA\UDUMP
core_dump_dest = D:\ORACLE\ADMIN\GIMA\CDUMP
sort_area_size = 65536
db_name = GIMA
open_cursors = 300
pga_aggregate_target = 25165824
PMON started with pid=2, OS id=4776
MMAN started with pid=3, OS id=4384
DBW0 started with pid=4, OS id=4768
LGWR started with pid=5, OS id=4920
CKPT started with pid=6, OS id=2128
SMON started with pid=7, OS id=5332
RECO started with pid=8, OS id=4828
CJQ0 started with pid=9, OS id=4860
Fri Feb 19 08:22:10 2016
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Fri Feb 19 08:22:11 2016
ALTER DATABASE MOUNT
Fri Feb 19 08:22:11 2016
Controlfile identified with block size 16384
Fri Feb 19 08:22:15 2016
Setting recovery target incarnation to 1
Fri Feb 19 08:22:16 2016
Successful mount of redo thread 1, with mount id 1265443187
Fri Feb 19 08:22:16 2016
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Fri Feb 19 08:22:17 2016
ALTER DATABASE OPEN
Fri Feb 19 08:22:17 2016
Beginning crash recovery of 1 threads
Fri Feb 19 08:22:17 2016
Started first pass scan
Fri Feb 19 08:22:17 2016
Completed first pass scan
0 redo blocks read, 0 data blocks need recovery
Fri Feb 19 08:22:17 2016
Started redo application at
Thread 1: logseq 12650, block 16889, scn 0.70772822
Recovery of Online Redo Log: Thread 1 Group 2 Seq 12650 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\GIMA\REDO02.LOG
Fri Feb 19 08:22:17 2016
Completed redo application
Fri Feb 19 08:22:17 2016
Completed crash recovery at
Thread 1: logseq 12650, block 16889, scn 0.70792823
0 data blocks read, 0 data blocks written, 0 redo blocks read
Fri Feb 19 08:22:18 2016
Thread 1 advanced to log sequence 12651
Maximum redo generation record size = 120832 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 7 at log switch
Thread 1 opened at log sequence 12651
Current log# 3 seq# 12651 mem# 0: D:\ORACLE\ORADATA\GIMA\REDO03.LOG
Successful open of redo thread 1
Fri Feb 19 08:22:18 2016
SMON: enabling cache recovery
Fri Feb 19 08:22:19 2016
Successfully onlined Undo Tablespace 1.
Fri Feb 19 08:22:19 2016
SMON: enabling tx recovery
Fri Feb 19 08:22:19 2016
Database Characterset is WE8MSWIN1252
Fri Feb 19 08:22:19 2016
Published database character set on system events channel
Fri Feb 19 08:22:19 2016
All processes have switched to database character set
Fri Feb 19 08:22:20 2016
Starting background process QMNC
QMNC started with pid=13, OS id=5296
Fri Feb 19 08:22:20 2016
replication_dependency_tracking turned off (no async multimaster replication found)
Fri Feb 19 08:22:21 2016
Starting background process MMON
MMON started with pid=14, OS id=1916
Fri Feb 19 08:22:21 2016
Starting background process MMNL
MMNL started with pid=15, OS id=5728
Fri Feb 19 08:22:22 2016
Completed: ALTER DATABASE OPEN
Fri Feb 19 08:22:47 2016
Running without dynamic strand for Non-Enterprise Edition
Fri Feb 19 08:22:47 2016
Starting ORACLE instance (normal)
Fri Feb 19 08:29:28 2016
Running without dynamic strand for Non-Enterprise Edition
Fri Feb 19 08:29:28 2016
Starting ORACLE instance (normal)
Fri Feb 19 08:33:10 2016
Running without dynamic strand for Non-Enterprise Edition
Fri Feb 19 08:33:10 2016
Starting ORACLE instance (normal)
Running without dynamic strand for Non-Enterprise Edition
Fri Feb 19 08:37:32 2016
Starting ORACLE instance (normal)
Fri Feb 19 08:52:39 2016
Private_strands 7 at log switch
Thread 1 advanced to log sequence 12652
Current log# 1 seq# 12652 mem# 0: D:\ORACLE\ORADATA\GIMA\REDO01.LOG
Fri Feb 19 09:34:41 2016
Starting background process EMN0
EMN0 started with pid=17, OS id=5640
Fri Feb 19 09:34:41 2016
Shutting down instance: further logons disabled
Fri Feb 19 09:34:41 2016
Stopping background process QMNC
Fri Feb 19 09:34:41 2016
Stopping background process CJQ0
Fri Feb 19 09:34:43 2016
Stopping background process MMNL
Fri Feb 19 09:34:44 2016
Stopping background process MMON
Fri Feb 19 09:34:45 2016
Shutting down instance (immediate)
License high water mark = 2
Fri Feb 19 09:34:45 2016
Stopping Job queue slave processes
Fri Feb 19 09:34:45 2016
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Fri Feb 19 09:34:49 2016
alter database close normal
Fri Feb 19 09:34:49 2016
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Feb 19 09:34:49 2016
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 12652
Successful close of redo thread 1
Fri Feb 19 09:34:50 2016
Completed: alter database close normal
Fri Feb 19 09:34:50 2016
alter database dismount
Completed: alter database dismount
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active


Another in d:\oracle\homevega10g\rdbms\trace :

Fri Feb 19 08:22:09 2016
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Windows NT Version V5.2 Service Pack 2
CPU : 2 - type 586, 2 Physical Cores
Process Affinity: 0x00000000
Memory (A/P) : PH:3238M/4095M, PG:5159M/5977M, VA:1958M/2047M
Fri Feb 19 08:22:09 2016
Running without dynamic strand for Non-Enterprise Edition
Fri Feb 19 08:22:09 2016
Starting ORACLE instance (normal)
Fri Feb 19 08:22:09 2016
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_1 parameter default value as D:\oracle\HomeVega10G\RDBMS
Autotune of undo retention is turned on.
Running with 1 strand for Non-Enterprise Edition
Dynamic strands is set to FALSE
Running with 1 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled


I don't know if GIMA database is up and online now. How can i check this ?
Re: Error ORA-12505 tns listener does not currently know of sid given in connect descriptor [message #648336 is a reply to message #648335] Sun, 21 February 2016 08:56 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
from Command Window do as below

SET ORACLE_SID=GIMA
SQLPLUS / AS SYSDBA
STARTUP

COPY the results rom above then PASTE all back here
Re: Error ORA-12505 tns listener does not currently know of sid given in connect descriptor [message #648337 is a reply to message #648336] Sun, 21 February 2016 09:04 Go to previous messageGo to next message
JeremyS
Messages: 10
Registered: February 2016
Location: FRANCE
Junior Member
SET ORACLE_SID=GIMA > OK.

SQLPLUS / AS SYSDBA >

ERROR:
ORA-01031: insufficient privileges


I tried with system / manager and administrator login > no results.
Re: Error ORA-12505 tns listener does not currently know of sid given in connect descriptor [message #648338 is a reply to message #648337] Sun, 21 February 2016 09:06 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
you need to be logged onto the OS as the same OS user who owns the Oracle software installation files; usually "oracle".
Re: Error ORA-12505 tns listener does not currently know of sid given in connect descriptor [message #648339 is a reply to message #648337] Sun, 21 February 2016 09:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

As this is Windows, you have to st put your OS account in the ORA_DBA OS group (on the database server).

Re: Error ORA-12505 tns listener does not currently know of sid given in connect descriptor [message #648340 is a reply to message #648338] Sun, 21 February 2016 09:28 Go to previous messageGo to next message
JeremyS
Messages: 10
Registered: February 2016
Location: FRANCE
Junior Member
I tried to be logged with domain administrator > no results.
With local administrator > no results.
With a user who is already logged on this server > no results.

There is no oracle user.
Re: Error ORA-12505 tns listener does not currently know of sid given in connect descriptor [message #648341 is a reply to message #648339] Sun, 21 February 2016 09:29 Go to previous messageGo to next message
JeremyS
Messages: 10
Registered: February 2016
Location: FRANCE
Junior Member
The server is already in ORA_DBA group (active directory local domain security group).

[Updated on: Sun, 21 February 2016 09:32]

Report message to a moderator

Re: Error ORA-12505 tns listener does not currently know of sid given in connect descriptor [message #648342 is a reply to message #648341] Sun, 21 February 2016 10:15 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I think your problem is here,
Quote:
i demoted domain controller on a server

What account is the OracleServiceGIMA service running under? What groups is your Windows account a member of? I don't know what "demoted" means (I'm not very good with Winows) but I would guess that you need to re-create the service to run under a local system account.
Re: Error ORA-12505 tns listener does not currently know of sid given in connect descriptor [message #648343 is a reply to message #648342] Sun, 21 February 2016 10:29 Go to previous messageGo to next message
JeremyS
Messages: 10
Registered: February 2016
Location: FRANCE
Junior Member
John Watson wrote on Sun, 21 February 2016 17:15
I don't know what "demoted" means (I'm not very good with Winows)


It means that i uninstalled the domain controller role on the server.

The OracleServiceGIMA is running under Local system user.
Re: Error ORA-12505 tns listener does not currently know of sid given in connect descriptor [message #648344 is a reply to message #648341] Sun, 21 February 2016 10:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

JeremyS wrote on Sun, 21 February 2016 16:29
The server is already in ORA_DBA group (active directory local domain security group).


What does this mean?
I meant the account you are connected with on the Windows database server must be in the local Windows group ORA_DBA.

In addition, the %ORACLE_HOME%\network\admin\sqlnet.ora file must contain the line:
SQLNET.AUTHENTICATION_SERVICES = (NTS)

Re: Error ORA-12505 tns listener does not currently know of sid given in connect descriptor [message #648345 is a reply to message #648344] Sun, 21 February 2016 10:53 Go to previous messageGo to next message
JeremyS
Messages: 10
Registered: February 2016
Location: FRANCE
Junior Member
Michel Cadot wrote on Sun, 21 February 2016 17:33

JeremyS wrote on Sun, 21 February 2016 16:29
The server is already in ORA_DBA group (active directory local domain security group).


What does this mean?
I meant the account you are connected with on the Windows database server must be in the local Windows group ORA_DBA.



I have a group named ORA_DBA in Active Directory. In this group, i have the domain administrator user and the Oracle server object.

I also tried to create a local group with the name ORA_DBA on the Oracle Server. In this group, i put the domain administrator account, the local administrator account, the local system account. But the sqlplus as sysdba connexion still failed.

Michel Cadot wrote on Sun, 21 February 2016 17:33

In addition, the %ORACLE_HOME%\network\admin\sqlnet.ora file must contain the line:
SQLNET.AUTHENTICATION_SERVICES = (NTS)


I don't find any sqlnet.ora files in d:\oracle\homevega10g\network\admin folder.
/forum/fa/13039/0/


[mod-edit: imaged inserted into message body by bb]

[Updated on: Sun, 21 February 2016 12:52] by Moderator

Report message to a moderator

Re: Error ORA-12505 tns listener does not currently know of sid given in connect descriptor [message #648346 is a reply to message #648345] Sun, 21 February 2016 10:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I don't find any sqlnet.ora files in d:\oracle\homevega10g\network\admin folder.


So create one with the line I posted.
Re: Error ORA-12505 tns listener does not currently know of sid given in connect descriptor [message #648347 is a reply to message #648346] Sun, 21 February 2016 11:06 Go to previous messageGo to next message
JeremyS
Messages: 10
Registered: February 2016
Location: FRANCE
Junior Member
Michel Cadot wrote on Sun, 21 February 2016 17:57

Quote:
I don't find any sqlnet.ora files in d:\oracle\homevega10g\network\admin folder.


So create one with the line I posted.


Done.

I could execute the command line sqlplus / as sysdba.
I then executed the command line STARTUP.

The application start now.

I will ask the user to try if all is good in the application tomorrow.

But it seems to be good Smile Smile Smile .

Thank you very very very much Smile !
Re: Error ORA-12505 tns listener does not currently know of sid given in connect descriptor [message #648348 is a reply to message #648347] Sun, 21 February 2016 11:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

If you want the database starts with the server execute the command:
%ORACLE_HOME%\BIN\ORADIM -EDIT -SID %ORACLE_SID% -startmode auto -srvcstart system


Re: Error ORA-12505 tns listener does not currently know of sid given in connect descriptor [message #648349 is a reply to message #648335] Sun, 21 February 2016 11:11 Go to previous message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
JeremyS wrote on Sun, 21 February 2016 08:50
I find 2 alert_gima.log files :

One in d:\oracle\admin\gima\bdump :


Several things very strange about this, starting with the fact that you seem to have two alert logs for the same database, in different directories, and overlapping times. And within the first, we see further strangeness:

Thu Feb 18 12:00:39 2016
Shutting down instance: further logons disabled
Thu Feb 18 17:34:09 2016
Stopping background process QMNC
Thu Feb 18 17:34:09 2016
Stopping background process CJQ0
Thu Feb 18 17:34:11 2016
Stopping background process MMNL
Thu Feb 18 17:34:12 2016
Stopping background process MMON
Thu Feb 18 17:34:13 2016
Shutting down instance (immediate)


Looks like a shutdown was issued on Feb 18 at 12:00:39. The line just before would have shown if it were 'norma', 'immediate' or 'abort'. In any event, we don't see any actual shutdown progress messages until 17:34, and those get interrupted with another 'shutdown immediate'

License high water mark = 6
Thu Feb 18 17:34:13 2016
Stopping Job queue slave processes
Thu Feb 18 17:34:13 2016
Job queue slave processes stopped
All dispatchers and shared servers shutdown


And we see no progress on that shutdown. Then we see a startup at Fri Feb 19 08:22:10:

Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
  processes                = 150
  shared_pool_size         = 83886080
  large_pool_size          = 8388608
  java_pool_size           = 50331648
  control_files            = D:\ORACLE\ORADATA\GIMA\CONTROL01.CTL, D:\ORACLE\ORADATA\GIMA\CONTROL02.CTL, D:\ORACLE\ORADATA\GIMA\CONTROL03.CTL
  db_block_size            = 8192
  db_cache_size            = 25165824
  compatible               = 10.1.0.2.0
  db_file_multiblock_read_count= 16
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=GIMAXDB)
  job_queue_processes      = 10
  background_dump_dest     = D:\ORACLE\ADMIN\GIMA\BDUMP
  user_dump_dest           = D:\ORACLE\ADMIN\GIMA\UDUMP
  core_dump_dest           = D:\ORACLE\ADMIN\GIMA\CDUMP
  sort_area_size           = 65536
  db_name                  = GIMA
  open_cursors             = 300
  pga_aggregate_target     = 25165824
PMON started with pid=2, OS id=4776
MMAN started with pid=3, OS id=4384
DBW0 started with pid=4, OS id=4768
LGWR started with pid=5, OS id=4920
CKPT started with pid=6, OS id=2128
SMON started with pid=7, OS id=5332
RECO started with pid=8, OS id=4828
CJQ0 started with pid=9, OS id=4860
Fri Feb 19 08:22:10 2016
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Fri Feb 19 08:22:11 2016
ALTER DATABASE   MOUNT
Fri Feb 19 08:22:11 2016
Controlfile identified with block size 16384
Fri Feb 19 08:22:15 2016
Setting recovery target incarnation to 1
Fri Feb 19 08:22:16 2016
Successful mount of redo thread 1, with mount id 1265443187
Fri Feb 19 08:22:16 2016
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Fri Feb 19 08:22:17 2016
ALTER DATABASE OPEN


And as part of the startup, a crash recovery, indicating the previous shutdown did not complete cleanly:

Fri Feb 19 08:22:17 2016
Beginning crash recovery of 1 threads
Fri Feb 19 08:22:17 2016

<snip crash recovery activity>

Completed crash recovery at
 Thread 1: logseq 12650, block 16889, scn 0.70792823
 0 data blocks read, 0 data blocks written, 0 redo blocks read
Fri Feb 19 08:22:18 2016
Thread 1 advanced to log sequence 12651


And eventually a successful OPEN:

Maximum redo generation record size = 120832 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 7 at log switch
Thread 1 opened at log sequence 12651
  Current log# 3 seq# 12651 mem# 0: D:\ORACLE\ORADATA\GIMA\REDO03.LOG
Successful open of redo thread 1
Fri Feb 19 08:22:18 2016
SMON: enabling cache recovery
Fri Feb 19 08:22:19 2016
Successfully onlined Undo Tablespace 1.
Fri Feb 19 08:22:19 2016
SMON: enabling tx recovery
Fri Feb 19 08:22:19 2016
Database Characterset is WE8MSWIN1252
Fri Feb 19 08:22:19 2016
Published database character set on system events channel
Fri Feb 19 08:22:19 2016
All processes have switched to database character set
Fri Feb 19 08:22:20 2016
Starting background process QMNC
QMNC started with pid=13, OS id=5296
Fri Feb 19 08:22:20 2016
replication_dependency_tracking turned off (no async multimaster replication found)
Fri Feb 19 08:22:21 2016
Starting background process MMON
MMON started with pid=14, OS id=1916
Fri Feb 19 08:22:21 2016
Starting background process MMNL
MMNL started with pid=15, OS id=5728
Fri Feb 19 08:22:22 2016
Completed: ALTER DATABASE OPEN
Fri Feb 19 08:22:47 2016


Then, beginning just a few minutes later, a series of startups issued in quick succession:

Running without dynamic strand for Non-Enterprise Edition
Fri Feb 19 08:22:47 2016
Starting ORACLE instance (normal)
Fri Feb 19 08:29:28 2016
Running without dynamic strand for Non-Enterprise Edition
Fri Feb 19 08:29:28 2016
Starting ORACLE instance (normal)
Fri Feb 19 08:33:10 2016
Running without dynamic strand for Non-Enterprise Edition
Fri Feb 19 08:33:10 2016
Starting ORACLE instance (normal)
Running without dynamic strand for Non-Enterprise Edition
Fri Feb 19 08:37:32 2016
Starting ORACLE instance (normal)


Then a 15 minute lag before the next message, with none of the normal startup messages:

Fri Feb 19 08:52:39 2016
Private_strands 7 at log switch
Thread 1 advanced to log sequence 12652
  Current log# 1 seq# 12652 mem# 0: D:\ORACLE\ORADATA\GIMA\REDO01.LOG
Fri Feb 19 09:34:41 2016
Starting background process EMN0
EMN0 started with pid=17, OS id=5640


then another shutdown:

Fri Feb 19 09:34:41 2016
Shutting down instance: further logons disabled
Fri Feb 19 09:34:41 2016
Stopping background process QMNC
Fri Feb 19 09:34:41 2016
Stopping background process CJQ0
Fri Feb 19 09:34:43 2016
Stopping background process MMNL
Fri Feb 19 09:34:44 2016
Stopping background process MMON
Fri Feb 19 09:34:45 2016
Shutting down instance (immediate)
License high water mark = 2
Fri Feb 19 09:34:45 2016
Stopping Job queue slave processes
Fri Feb 19 09:34:45 2016
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Fri Feb 19 09:34:49 2016
alter database close normal
Fri Feb 19 09:34:49 2016
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Feb 19 09:34:49 2016
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 12652
Successful close of redo thread 1
Fri Feb 19 09:34:50 2016
Completed: alter database close normal
Fri Feb 19 09:34:50 2016
alter database dismount
Completed: alter database dismount
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active


Quote:

Another in d:\oracle\homevega10g\rdbms\trace :


What was the actual name of this file? And exactly what directory is it in? It should be 'd:\oracle\homevega10g\rdbms\%ORACLE_SID%\%ORACLE_SID%\trace\alert%ORACLE_SID%.log'. There is nothing in the content you present that identifies what database it is from, and without the full path/file name of the alert, we can't trust it.

Fri Feb 19 08:22:09 2016
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Windows NT Version V5.2 Service Pack 2
CPU             : 2 - type 586, 2 Physical Cores
Process Affinity: 0x00000000
Memory (A/P)    : PH:3238M/4095M, PG:5159M/5977M, VA:1958M/2047M
Fri Feb 19 08:22:09 2016
Running without dynamic strand for Non-Enterprise Edition
Fri Feb 19 08:22:09 2016
Starting ORACLE instance (normal)
Fri Feb 19 08:22:09 2016
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_1 parameter default value as D:\oracle\HomeVega10G\RDBMS
Autotune of undo retention is turned on. 
Running with 1 strand for Non-Enterprise Edition
Dynamic strands is set to FALSE
Running with 1 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled


Quote:
I don't know if GIMA database is up and online now. How can i check this ?

[Updated on: Sun, 21 February 2016 13:40]

Report message to a moderator

Previous Topic: Create DB Script
Next Topic: Oracle Database 11g R2 enterprise manager configuration warnings
Goto Forum:
  


Current Time: Thu Mar 28 16:11:07 CDT 2024