Re: Oracle 8i on linux ORA-12514

jmnpst_at_aol.com (JMNpst) writes:

> I am trying to connect to our Oracle Linux Server from a client. I
> loaded the linux client version, but cannot connect using SQLPLUS,
> nor NET8 assistant. I am sure everything is set up correctly -
> TNSNAMES.ORA, LISTENER.ORA on both machines. Just to be sure that
> linux is not the problem, I loaded the client version of Oracle 8i
> on another machine using W98. I was able to connect. But then we
> rebooted the linux server and now I cannot connect anymore. When
> trying to connect using SQLPLUS, I get ORA-12514 Cannot reslove to
> SERVICE NAME. I can ping the server using tnsping, so thats not the
> problem. On the server side, is there something I am supposed to do
> to start oracle, like some services, or run any kind of script?

Are you certain that the listener is running?

$ su - oracle -c 'lsnrctl start'

-- 
The wheel is turning but the hamster is dead.
Craig Kelley  -- kellcrai_at_isu.edu
http://www.isu.edu/~kellcrai finger ink@inconnu.isu.edu for PGP block