Re: help connecting to sqlplus

The
c:\oracle\admin\test\pfile\init.ora file should have all the needed data - That's the one being used..so your init<sid>.ora is OK as is...

brian_dellong_at_yahoo.com (brian) wrote:

>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 - 14:16:06 CST