Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SID given in connect descriptor could not be resolved.

Posted on 2004-10-01
8
2,370 Views
Last Modified: 2008-02-20
When I try logging in using EM the service line has:
Service     sdw1.ccc.edu
In the tnsnames file
sdw1.ccc.edu =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = psdwd.ccc.edu)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = sdw1.ccc.edu )
    )
  )
     
In the listener.ora file

(SID_DESC =
  (GLOBAL_DBNAME = sdw1.ccc.edu)
  (ORACLE_HOME = /u01/app/oracle/product/9.2.0.1.0)
                                                     (SID_NAME = sdw1)
)

When I try going in through EM, I get the message SID given in connect descriptor could no be resolved.
What's the problem?
0
Comment
Question by:xoxomos
8 Comments
 
LVL 1

Expert Comment

by:flevyhara
ID: 12203623
Try:

sdw1.ccc.edu =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = psdwd.ccc.edu)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SID = sdw1)
    )
  )
     
0
 
LVL 12

Expert Comment

by:geotiger
ID: 12203632

Could you use sdw1.ccc.edu  service name on server  psdwd.ccc.edu?
0
 
LVL 10

Assisted Solution

by:SDutta
SDutta earned 125 total points
ID: 12203643
Check your SQLNET.ORA file, if the settings are like this
names.default_domain = world
name.default_zone = world

then you have to set in TNSNAMES.ORA file
sdw1.ccc.edu.world =
  (DESCRIPTION =
....

rest all remains same.

If you dont want to change the TNSNAMES, you can remove the two parameters above from SQLNET.ORA
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:xoxomos
ID: 12203673
Names. default_ domain is ccc.edu
0
 

Author Comment

by:xoxomos
ID: 12203686
No, it does not work even when I'm at the server using EM.  I can use sqlplus fiine.
0
 

Author Comment

by:xoxomos
ID: 12203700
Yes, I do have an entry
sdw1.ccc.edu =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = psdwd.ccc.edu)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SID = sdw1)
    )
  )
0
 
LVL 1

Accepted Solution

by:
flevyhara earned 125 total points
ID: 12203770
Your entry says:
      (SERVER = DEDICATED)
      (SERVICE_NAME = sdw1.ccc.edu )

Instead, My entry says:
      (SERVER = DEDICATED)
      (SID = sdw1)
0
 

Author Comment

by:xoxomos
ID: 12203781
I don't know if it is related, but i just tried the EM at the server.  There I get oracle.net.config serviceAliasException:10.   Seperate question.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle DB monitor SW 21 60
Not able to drop or recreate an Oracle stored procedure 1 38
error in my cursor 5 41
Read XML values 8 41
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question