SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-25-2008, 01:56 AM
| ||||
| ||||
 Error ORA-01034 on windows xp Hello, I am getting an error ORA-01034:Oracle not available in 10g, Please help me. I am new to oracle 10g. Also how to start new services. I cannot even connect to oracle sql* plus. The platform is windows and os is xp Thanx in advance      |
|
02-25-2008, 01:56 AM
| |||
| |||
| Re: Error ORA-01034 on windows xp My Discussion wrote: > Hello, > I am getting an error ORA-01034:Oracle not available in 10g, > > > Please help me. > I am new to oracle 10g. > Also how to start new services. > I cannot even connect to oracle sql* plus. > The platform is windows and os is xp > > Thanx in advance Hard to say. You've given us the Oracle version and the OS, but nothing else. What do you mean you cannot "connect to oracle sql*plus"? SQL*Plus is just a tool. You don't 'connect' to it, you just 'start' it, just like you start any other program. Exactly what are you doing when you try to start it, and what feedback is it giving you? You start the new services just like you start any other service in Windows. Go to the services applet in the Windows control panel and take a look. My guess is you don't have the ORACLE_SID environment variable set in the environment in which you are trying to connect to the database. Hmm. Have you even created a database? Installing Oracle is not the same as creating a database. |
|
02-25-2008, 01:57 AM
| ||||
| ||||
| Re: Error ORA-01034 on windows xp My Discussion wrote: > Hello, > I am getting an error ORA-01034:Oracle not available in 10g, > > > Please help me. > I am new to oracle 10g. > Also how to start new services. > I cannot even connect to oracle sql* plus. > The platform is windows and os is xp > > Thanx in advance > Is the Oracle instance running on the same machine as sqlplus? Did this ever work? Did anything change since it last worked? If sqlplus and the instance are on different machines, is the networking configuration set up correctly? Is the listener.ora file on the remote machine referencing the correct instance? There are lots of unanswered questions and unknown variables. Without knowing them it would be impossible to tell you what to do. I am *guessing* that the Oracle instance and sqlplus are both on the same machine. If so then the first thing to check is that the instance is actually running. Check the service list and see if the Oracle services are running. If not, start them and try again. You don't really need the listener service up unless you have users trying to connect over a network. -- To reply by email remove "_nospam" |
Linear Mode
