sql plus - login

[shica]

hi
yesterday i have installed oracle 8i personal edition on my computer. At first i logged on to sql plus using username scott and password tiger,it worked.Then today when i tried to log in using the same username and password, it says oracle not available.
please help me ASAP

thanks

[MAK]

see whether major servies of Oracle services like oracleorahome8listener is running

start-run- services.msc

[shica]

thanks for ur reply
i checked, it is like this

oracleorahome81nslistener started automatic local system

what i should do
hope to hear from u soon
thanks

[MAK]

are you giving the right "Host String"

look in to the
oracle\ora81\network\tnsnames.ora and see whats your service name


try system/manager if you have accidentally changed the password.

[shica]

i looked into oracle\ora81\network\names, it is empty

i tried system/manager, i am getting the same message 'oracle not available'

looking forward for ur reply
thanks

[shica]

when i checked here --- Oracle\Ora81\network\admin\tnsnames.ora
service_name = shica

[skhanal]

What is the connection name for service name shica?

If it is also shica, try using TNSPING (it should be in your bin directory, may be named TNSPING80) utility to test the connection from command prompt.

tnsping shica

If you can't connect, check if your listener.ora file is listening for correct SID or Service Name. At command prompt start

lsnrctl

then run status to see what service name the listener listening on. If it is different from the service name listed in tnsnames.ora, that is your problem. You can correct either of them and restart the listener.

[shica]

when i tried lsnrctl(status), it gave status of LISTENER.
listener using listener name LISTENER has already been started
should i need to change anything? if yes, how to change???

[skhanal]

Did it list your database's service name?

If not the database may not have been started (even if service is started). Stop and start Oracle database service or in command prompt start server manager with

svrmgr30

connect internal/manager (assuming manager is the password for internal account)

select * from v$instance;

this should show you the status of database, if it is not started start it or open it as the case may be.

To start up type
startup

to open

alter database open

[shica]

Today when i tried to log in using user name scott, password tiger, i got an error message
TNS protocol adapter error
what does it mean and how to solve it?

also when i checked in services, the status of oracleservicesSHICA is as STARTING not STARTED,what i should do?
hope to hear from u soon
thanks

[skhanal]

Try to start it from command prompt using Server Manager. Or you can use the startup.bat file in orant\bin directory.

[shica]

i 've started the listener.
now i am getting another error message
TNS PROTOCOL ADAPTER ERROR

what should i do
thanks

[skhanal]

Check your listerner.ora file to see what protocols are enabled and verify you have drivers installed for those protocols.