Re: help connecting to sqlplus

about the init<sid>.ora file

it only has one line IFILE='c:\oracle\admin\test\pfile\init.ora' where test is SID

i heard that it needs another line as well db_name=database_name

is that correct ?

Global db name is "test.us.acme.com"
and SID is "test"

what would be the correct database_name ?

TurkBear <john.greco_at_dot.state.mn.us> wrote in message news:<p7sptugahruv2vijh8u925a1qnf50jfcq9_at_4ax.com>...
> Do a shutdown abort - then a startup nomount then a shutdown normal, startup pfile=yourinit<sid>.ora -
> If this does not help, ( I do not remember if you are on Windows, but if so, set the Oracle services to Manual first) ,
> reboot and try again after manually starting the Listener then the OracleInstance service )..
> Ig=f thta takes care of it, reset the services to Automatic ( make the Oracle one dependent on the Listener) - again assuming
> Windows
>
> If it stills gives that error, contact Oracle support to help debug your init<sid>.ora file as something there may be causing
> the 'hang'
>
> brian_dellong_at_yahoo.com (brian) wrote:
>
> >yes, the instance was not started.
> >now when the instance has been started i get a different error
> >i have tried doing shutdown immediate and then again startup but still
> >this error comes up.
> >
> >"error ORA-01033: ORACLE initialization or shutdown in progress"
> >
> >
> >
> >
> >TurkBear <john.greco_at_dot.state.mn.us> wrote in message news:<4i0otusholp3t7mefnq7vg4svenkd09rjj_at_4ax.com>...
> >> In addition to that, are you sure the INSTANCE is started...
> >> The tnsping just tries to contact the host's listener specified in tnsnames.ora but does not indicate that the Oracle
> >> database is actually up and running..
> >>
> >> Karsten Farrell <kfarrell_at_belgariad.com> wrote:
> >>
> >> >brian wrote:
> >> >> trying to connect to sqlplus and getting an error
> >> >> Error: ORA-01034 : Oracle not available
> >> >>
> >> >> tnsping to global database name is successful
> >> >>
> >> >> since this is a fresh install i am logging in as
> >> >> username: SYSTEM
> >> >> passwd : manager
> >> >> HostString: global db name (and tnsping to this is successful)
> >> >> (all services running, except managememt server service)
> >> >Question: Are you and your server on opposite sides of a firewall? When
> >> >tnsping works, but sqlplus doesn't, usually the problem occurs after
> >> >you've successfully carried out a handshake with the listener (which is
> >> >all tnsping really does). The "conversation" with sqlplus takes place on
> >> >a randomly-chosen port (not 1521).
Received on Thu Nov 21 2002 - 13:50:43 CST