After Installing Oracle 9i and started "SQL plus" ,after entering name:scott,psw:tiger, it is showing an error(i.e.,#ERROR:
ORA-12560: TNS:protocol adapter error#) so plz tell me how to
1) Uninstall oracle 9i
2)Re-install Oracle 9i perfectly inorder to work Sql plus
plz tell me(host Id's,names etc., i hav to mention while i installing oracle 9i)
2006-08-04 01:35:01 · 4 answers · asked by sandeep 1 in Computers & Internet ➔ Programming & Design
it sounds like something went wrong with your installation process. i would make sure you have all the system requirements, unistall it (make sure its completely removed int he add/remove software section) and reinstall it and read everything carefully that it might as you or give you options for.
2006-08-04 01:56:05 · answer #1 · answered by Anonymous · 0⤊ 1⤋
This could be many things. Don't waste time reinstalling yet. You aren't getting what looks like a fatal error to me, just a TNS error.
* Do you have a database created?
* Is it up and running
* How did you configure the tnsnames.ora and listener.ora?
* Does your sqlnet.ora force you to use .world or .domain.com for your TNS entries?
* ensure your ORACLE_SID is set?
if this is UNIX: $ echo $ORACLE_SID
if this is windows, look for the environment variable
* Verify that your listener is up and running and is listening for this database (this step is not critical as you did NOT do scott/tiger@DTABS).
If you installed the server and you are having errors, then reinstalling it is not going to necessarily fix your problems. If this is a client only installation, it will be VERY easy to fix, because you really can't do that wrong.
2006-08-05 15:33:33 · answer #2 · answered by xamayca.com 4 · 0⤊ 1⤋
The Problem you are facing is similar to what i faced when i tried to do the same. I even tried Installing all different types i.e client side, Lite Edition and all. It works fine until you dont reboot your computer but after the reboot, it goes haywire. I tried hard but I couldnt get going. Sorry, But I cant help you, do post the answer if you get one to siiidakash@yahoo.co.in
2006-08-04 09:43:31 · answer #3 · answered by ccsCoder 3 · 0⤊ 1⤋
kitne baar puchega.... kise technecian ko bula le.yaha gaand marana jarure hai kya?
2006-08-04 08:40:31 · answer #4 · answered by j_akshat9899 2 · 0⤊ 1⤋