Now this is the environment that i am into. I am creating a database for demo purpose. I have installed Oracle Enterprise Edition 8.1.6 in Windows NT machine. During the creation of the database the system was connected in LAN. But i have created the database in my machine locally. So when i remove my machine for the LAN i am not able to login into my database. The database is in my machine. I am using a laptop. Could u assist me in knowing the problem. It is urgent.
Go to your services and check whether there are oracle services, and they had been started. If not start them (like listeners and etc) then make sure that your database is up. Using oradim, start your database instance. then try connecting to the instance. From the sql for a fresh install it would be
If you've installed Oracle 8i on your laptop then it has nothing to do with the network. Is the database up..? Pls check the background processes and the alert log for details.
Have you configured your listener.ora ?
it means that some user is still connected to your Oracle server and is waiting for it to disconnect. Pls kill any sessions which is still connected to your DB. This will bring down the Instance/DB.
Startup again. This should work fine.