Although the installation was successful, i have been trying to log in SQLPlus since 3 days. I've seen queries regarding Oracle 10 g log in on this site and elsewhere. Nothing worked. I tried logging in:
using sys, system, sysman, dbsnmp as usernames with and/or without password. (I had set a common password "tiger" during installation for all users)
through command prompt typing "sys/as sysdba". But it asks for the password, and again shows a failure message.
- tried logging in with username "system" and password "manager".
The message that appears each time: ORA-12560: TNS protocol adapter error
I have windows 7 32-bit OS. And i tried the right-click drop-down menu's Properties option to change the setting : Run this program in compatibility mode for Windows 98/ Windows ME as well as for Windows 7.
Please help. Thanks in advance.
- I tried starting the service from Services.msc, the OracleServiceORCL when started, shows "Error 1067: The process terminated unexpectedly."
- I could set the SID to ORCL at command prompt(however, it was already named so during installation). But the Net Start command is unrecognized.
- Leniel's idea(as on the page : ORA-12560: TNS:protocol adaptor error ) too did not work with my pc.
- The environment variables have in the PATH all the pathnames required in Oracle. Plus, I also added a TNS_ADMIN variable .
- Could you please tell what the Host String could be? While trying to login, I leave it blank.
