Listener refused the connection with the following error: ORA-12505

[lalit khera]

hi
i am getting the error as-"Status: Failure - Test Failed: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor"


when instead of xe as sid, i write SIVA it works successfully.

please reply. its urgent

[Sumit Patil]

lalit khera wrote:
please reply. its urgent

Please EaseUp

[Sumit Patil]

Check your TNSNAMES.ora file, if it contains an entry having service_name as "xe"

[lalit khera]

Sumit Patil wrote:Check your TNSNAMES.ora file, if it contains an entry having service_name as "xe"

hi

i am new bee in oracle. please tell me where to find that file and if find what next thing i need to do.

[lalit khera]

Sumit Patil wrote:Check your TNSNAMES.ora file, if it contains an entry having service_name as "xe"

hey thanks sumit i found the file tnsnames.ora and the content of that file is as follows

# tnsnames.ora Network Configuration File: G:\app\windows7\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_SIVU =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

LISTENER_SIVA =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


SIVU =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sivu)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

SIVA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = siva)
)
)



now please tell me what it is all about. what is the significance of using SID during creating new connection using SQL developer.
Does it matter if i use SIVA or XE.

please tell me step by step, what i need to do next.??

thanks

[chris webster]

Oracle RDBMS is the relational database management system i.e. the server software that manages your databases. It can manage several databases (and each database can hold many different schemas), and each database has a different SID. The SID i.e. "XE" or "SIVA" is the name of your database, which is used by Oracle's TNS listener program to connect you to the right database.

"XE" is the name of the database created by the lightweight Oracle Express Edition (XE) RDBMS, but as we discovered last week, Oracle XE 11g doesn't work on 64-bit Windows 7. Presumably you don't have a database called "XE" on your system, which is why the listener is giving you this error.

If you are following a tutorial, it may be expecting you to work with XE, but the same exercises will work on any Oracle database - you just need to specify the right database.

"SIVA" is presumably one of the databases you created last week on your standard Oracle RDBMS installation. If you have put your tables in the "SIVA" database, then you will need to connect to this database in order to work with your tables.

"ORCL" is the default database that gets created with the standard Oracle RDBMS. If you haven't created your schemas yet, or if you are going to use some of the standard Oracle sample schemas (e.g. HR), then you could just use ORCL for your work as it should contain the sample schemas and should have been created properly by Oracle during your installation process.

Incidentally, if you are using the browser-based Enterprise Manager "Database Control" tool (which will probably have a URL like https://localhost:1158/em) to manage your database, then you may find it points to the "ORCL" database by default, so any users etc that you create with this tool will be created in the ORCL database. This browser interface stinks and is way too complicated for newbies, so I recommend you just use SQL Developer for your work instead, as it's much easier and more flexible for you right now.

[lalit khera]

chris webster wrote:Oracle RDBMS is the relational database management system i.e. the server software that manages your databases. It can manage several databases (and each database can hold many different schemas), and each database has a different SID. The SID i.e. "XE" or "SIVA" is the name of your database, which is used by Oracle's TNS listener program to connect you to the right database.

"XE" is the name of the database created by the lightweight Oracle Express Edition (XE) RDBMS, but as we discovered last week, Oracle XE 11g doesn't work on 64-bit Windows 7. Presumably you don't have a database called "XE" on your system, which is why the listener is giving you this error.

If you are following a tutorial, it may be expecting you to work with XE, but the same exercises will work on any Oracle database - you just need to specify the right database.

"SIVA" is presumably one of the databases you created last week on your standard Oracle RDBMS installation. If you have put your tables in the "SIVA" database, then you will need to connect to this database in order to work with your tables.

"ORCL" is the default database that gets created with the standard Oracle RDBMS. If you haven't created your schemas yet, or if you are going to use some of the standard Oracle sample schemas (e.g. HR), then you could just use ORCL for your work as it should contain the sample schemas and should have been created properly by Oracle during your installation process.

Incidentally, if you are using the browser-based Enterprise Manager "Database Control" tool (which will probably have a URL like https://localhost:1158/em) to manage your database, then you may find it points to the "ORCL" database by default, so any users etc that you create with this tool will be created in the ORCL database. This browser interface stinks and is way too complicated for newbies, so I recommend you just use SQL Developer for your work instead, as it's much easier and more flexible for you right now.

thanks chris.

as you said change the password of system and then login and user orcl as SID. i did so.
now i am getting this error. see attached screenshot

lalit

[chris webster]

lalit khera wrote:as you said change the password of system and then login and user orcl as SID. i did so.
now i am getting this error. see attached screenshot

lalit

I did not tell you to change the SYSTEM password. You are responsible for setting the password, so you should know what it is. There is a SYS account and a SYSTEM account on each database. The Oracle error is telling you that you have entered the wrong username/password combination for this account on this database. Enter the right account details for this database and it should work.

To be honest, Lalit, if you cannot even work out how to log in, then you are obviously so far out of your depth with Oracle that you really need to go right back to basics. Find a simple tutorial or book, and work through it step by step until you have completed a structured set of simple lessons on basic database tasks. Right now you are trying to do too many different things at once, and you are trying to use a highly sophisticated enterprise-class RDBMS without understanding even the simplest concepts - such as how to log in.

Don't keep rushing off to create your own databases where you don't know how to log in. Don't create tables in the wrong schema on the wrong database and then expect to be able to see them by logging into some random schema/database combination. Don't keep changing your passwords and then forgetting which password goes with which account or database. Don't expect to see the results of your transactions on different sessions if you don't understand how COMMIT works.

Oracle RDBMS is a powerful technology platform and you should treat it seriously instead of expecting to learn it all with a few days of random tinkering. Work methodically and patiently through the basics, and you might actually learn something, instead of spending most of your time trouble-shooting and asking for help on Java forums. We can try to help you with specific problems here, but this is not the place to get the "Oracle 101" training you obviously require.

Good luck.

[lalit khera]

chris webster wrote:

lalit khera wrote:as you said change the password of system and then login and user orcl as SID. i did so.
now i am getting this error. see attached screenshot

lalit

I did not tell you to change the SYSTEM password. You are responsible for setting the password, so you should know what it is. There is a SYS account and a SYSTEM account on each database. The Oracle error is telling you that you have entered the wrong username/password combination for this account on this database. Enter the right account details for this database and it should work.

To be honest, Lalit, if you cannot even work out how to log in, then you are obviously so far out of your depth with Oracle that you really need to go right back to basics. Find a simple tutorial or book, and work through it step by step until you have completed a structured set of simple lessons on basic database tasks. Right now you are trying to do too many different things at once, and you are trying to use a highly sophisticated enterprise-class RDBMS without understanding even the simplest concepts - such as how to log in.

Don't keep rushing off to create your own databases where you don't know how to log in. Don't create tables in the wrong schema on the wrong database and then expect to be able to see them by logging into some random schema/database combination. Don't keep changing your passwords and then forgetting which password goes with which account or database. Don't expect to see the results of your transactions on different sessions if you don't understand how COMMIT works.

Oracle RDBMS is a powerful technology platform and you should treat it seriously instead of expecting to learn it all with a few days of random tinkering. Work methodically and patiently through the basics, and you might actually learn something, instead of spending most of your time trouble-shooting and asking for help on Java forums. We can try to help you with specific problems here, but this is not the place to get the "Oracle 101" training you obviously require.

Good luck.

Thanks chris, for telling me that my basics are not good enough. and for your kind information that was the problem i am facing it from few recent days.
Well as far as login into the database is concerned, i know how to do that. i also know how to work with insufficient privileges if logon denied occur.
i am facing problem only with system account login(already granted him for create session privilege via sys account)
But according to me you dont know how to guide a beginner.


well thanks for your cooperation till now and byee.

[Aniruddh Joshi]

Lalit,

I feel you could use below for a better experience at the Ranch -

Post text Not Screenshots
and its good for each Rancher to read this to get great and friendly respond to your questions

believe me it'll be a better place once you're done reading above. Give it a try.

[lalit khera]

Aniruddh Joshi wrote:Lalit,

I feel you could use below for a better experience at the Ranch -

Post text Not Screenshots
and its good for each Rancher to read this to get great and friendly respond to your questions

believe me it'll be a better place once you're done reading above. Give it a try.

thanks for suggesting me.

[Martin Vashko]

There are several conversations going on. It was me who instructed you, Lalit, on changing SYSTEM account password, here. If you had problems with that, you can post an update there. Mixing the problems together in various threads is counterproductive.

In my opinion, Chris was providing you excellent advice and support. Unfortunately, his last post is very true. This is a complicated topic and this forum is not a good place for the kind of tutoring you're looking for.

Earlier, I suggested you to read the Oracle Concepts Guide (I'm suggesting the Concepts Guide because I know it; there may be better books, either in the Oracle's documentation library itself, or elsewhere). It is a must-read if you want to administer your own databases. It might not suffice, but would give you a very good start. Now, this document has some 400 pages. In no way can anyone teach you such an extensive subject on a forum.

If you've got previous experiences with other databases, many things in that book will be familiar to you and you won't need to spend much time over it. If you don't have experiences with other databases - well, you need to read that book all the more (it is actually a good introduction into RDBMS in itself).

I still believe one can learn using and administering Oracle on his own, but certainly not without reading the fine manuals.