isqlplus not starting

Is your oracle instance installed on windows or solaris?

windows xp professional

Go to start --> Control Panel --> Administrative tools --> Services
In there you should look for a service OracleOraDb10g_homeiSQL*PLUS and check if it is started or not.

IT IS ALREADY STARTED ..................

Check the iSQL*Plus log folder for any log files.
$ORACLE_HOME/sqlplus/log/isqlplus

SIR I RESOLVED..INSTEAD OF 5560 PORT IT WAS RUNNING IN PORT 5561...

that's good to know :)

now the problem is username password and connect identifier..
what user name i can user ?
what is the connect identifier.?

try the default oracle username: scott and password: tiger.
The connect identifier would be the SID of the database which is by default orcl but check your tnsnames.ora files if you changed it to something else

i tried both user name:sys password:allstate ci orcl2
and scott   tiger   orcl2

here is my tnsnames.ora   what can you suggest me?
----------------------------------------------------------------
ORCL2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.106)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl2)
    )
  )

ALLSTATE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.106)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = allstate)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

Try
User: scott
password: tiger
connect identifier: ALLSTATE

NO SIR..NOT WORKING

if u don't remember the password then
set oracle_sid=allstate
connect / as sysdba from server
and change the password for both
 

ie
c:> set oracle_sid=allstatec:> sqlplus /nolog
SQL> connect / as sysdba
SQL> alter user sys identified by  <new password>;
SQL> alter user system identified by  <new password>;
 
then try connecting
system@allstate


 

this is the problem with isqlplus only

when i connect to sqlplus if i want to connect to allstate database
i use  sys/allstate@orcl2 as sysdba   which is working fine..
if i want to connect to orcl2 database which is my starter database
is use sys/oracle123@orcl2 as sysdba which is also working fine..
this part "sys/oracle123@orcl2 as sysdba" I enter in user name part
I don't know what is happening with isqlplus....
please help me..
I know the user name and password still I am not able to connect isqlplus....

can u check open_mode from v$database ?

here is what i did


SQL> conn / as sysdba
Connected.
SQL> alter user sys identified by allstate1;

User altered.

SQL> alter user system identified by allstate2;

User altered.

then  in isqlplus

username:system
password:allstate2
connect identifier:orcl2

but still error,....sorry

Sir This is what I did
SQL> conn / as sysdba
Connected.
SQL> select name from v$database;

NAME
---------
ALLSTATE

SQL> select open_mode from v$database;

OPEN_MODE
----------
READ WRITE

CONNECT AS SYSDBA or AS SYSOPER not allowed through iSQL*Plus URL
CONNECT with AS SYSDBA or AS SYSOPER privileges is only permitted through the iSQL*Plus DBA URL

Hey Hey  It is working with this
username:system
password:allstate2

I put connect identifer blank...
Actually what is connect identifier??

it will work as normal user, u can not connect to sys as sysdba thru isqlplus
when u don't specify connection identifier  it will  try to connect a database installed on same machine using bequeth protocol. when u Connect to a remote database(located at some other machines/servers) it require connection identifer.  client softwares (like sqlplus ,toad etc )searches in local tnsnames.ora for connetion identifier . if found it connect  to the emote db as per specification in tnsnames. isqlpus is a webbased tool and runs from server itself. so cleints doesn't require any tnsnames.ora for using the isqlplus

Suppose if this is in a local network
from the tnsnames.ora
How can I find the connect identifier..
Thanks