Startup problem

[Database Administrator]

QDL schreef:
> Hello,
>
>> 1 I meant the alert log of Oracle, probably something like alert_xe.log
>> If this is a default install, it should be in the directory
>> %ORACLE_HOME%\database.
>> There should be a file called oradim.log in the same directory. This
>> tracks down service problems.
>
> In oradim.log there is one error for every startup:
> ORA-12560: TNS: error in protocol adapter
>
>> 2 Oracle is implemented as a service. You have a service called
>> OracleService on your system. SID can be anything, but for Oracle
>> Express it is always XE.
> Ok, thanks
>
>> 3 If you fire up a DOS box, and issuse
>> set ORACLE_SID=XE
>> sqlplus /nolog
>> connect / as sysdba
>> what happens (right after rebooting, that is)?
> The same error...
>
> Thanx for your support, I learnt a lot of things on Oracle structure
> Paolo
>
>
Did you start the service?

net start oracleservicexe

--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

[Database Administrator]

QDL schrieb:
[...]

> --- SQLNET ---
> # This file is actually generated by netca. But if customers choose to
> # install "Software Only", this file wont exist and without the native
> # authentication, they will not be able to connect to the database on NT.
>

Change

SQLNET.AUTHENTICATION_SERVICES = (NTS)

to

SQLNET.AUTHENTICATION_SERVICES = (NONE)

That works for me (W2k3, 10g SEO).

But with this change, on the command-line,

sqlplus / as sysdba

is not longer possible.

You must always use

sqlplus / as sysdba


HTH CW

[Database Administrator]

QDL schrieb:
[...]

> --- SQLNET ---
> # This file is actually generated by netca. But if customers choose to
> # install "Software Only", this file wont exist and without the native
> # authentication, they will not be able to connect to the database on NT.
>

Change

SQLNET.AUTHENTICATION_SERVICES = (NTS)

to

SQLNET.AUTHENTICATION_SERVICES = (NONE)

That works for me (W2k3, 10g SEO).

But with this change, on the command-line,

sqlplus / as sysdba

is not longer possible.

You must always use

sqlplus / as sysdba


HTH CW