English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

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:33:09 · 1 answers · asked by sandeep 1 in Computers & Internet Other - Computers

1 answers

While Installing Oracle, did you select create database option? If yes, Oracle will create a Database and configure Networking Services i.e. add a name for service. Did you remember giving any name for something like Global SID or Service Identifier? If yes, while using SQL*PLUS, you need to use that name in connect string.

1) Check whether Oracle Service with Service Id name is existing in Services applet. If yes, you have Oracle DB. Start it and then connect using SQL*PLUS.
2) Un-installing Oracle is easy. Launch Oracle universal installer and select de-install option.
3) Install it again. But select create database option.

Host id is done in network configuration. It starts automatically after installing Oracle. There you specify localhost as hostname.

2006-08-04 01:39:15 · answer #1 · answered by Indian_Male 4 · 0 0

fedest.com, questions and answers