Thanks & Regards, Sumeet
SCJP 1.4, SCWCD 5, LinkedIn Profile
Sumit Patil wrote:Check your TNSNAMES.ora file, if it contains an entry having service_name as "xe"
Sumit Patil wrote:Check your TNSNAMES.ora file, if it contains an entry having service_name as "xe"
No more Blub for me, thank you, Vicar.
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.
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
No more Blub for me, thank you, Vicar.
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.
Anrd
"One of the best things you could do is to simplify a larger application into a smaller one by reducing its process and complexity - Fowler"
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.