Re: Oracle 10g startup problem

Dan,
As soon as I logged in the VMware, I checked the service
"OracleServiceMAXIMO". Its Status was "Started" and its Startup Type
was "Automatic". I tried to connect to the MAXIMO database in SQLPlus
and got the error message:

ORA-01034: ORACLE not available
ORA-27101: Shared memory realm does not exist

Then I followed your suggestion to open a command prompt and run "net
start oracleserviceMAXIMO". The problem persisted, I got the same error
in SQLPlus ... Only after manually doing a startup of the database I
could successfully connect in SQLPlus.

My understanding is that the service was running, BUT somehow the
database is not being automatically started... Any other suggestion?

PS: fyi, the service OracleDBConsoleMAXIMO had the same status
(STARTED) and statup type (AUTOMATIC) when I logged in the VMware.

Many Thanks for the help!
Ana

Patrox wrote:

1) Oracle.exe was running
it is not enough on windows, you must also start the oracleMySID service
to have the db up and running + the listener if you plan remote
connections (usually ...)

2) No problems in the alert.log of the database
does it tells "instance started" at the end ?

Any ideas?
can you connect via a command line window with
sqlplus "sys as sysdba"
?

good luck,
Patrice Castet
Sr Oracle DBA

.

Relevant Pages

  • RE: Breakable
    ... One of the problems with this is that sqlplus assumes that the user must ... permissions to run svrmgrl as the oracle user so they can ... at least pose some other security risks. ... the database rather than the client also suggests to me that Oracle's ...
    (Bugtraq)
  • Re: Oracle 10g startup problem
    ... As soon as I logged in the VMware, ... I tried to connect to the MAXIMO database in SQLPlus ... Do you have more than one Oracle environment? ...
    (comp.databases.oracle.server)
  • Re: SQLPlus with Perl
    ... I've been assigned a project involving SQLplus calls to an Oracle ... database within Perl code. ... now need to perform a select statement to check values in the database. ...
    (comp.lang.perl.misc)
  • Re: Oracle 10g startup problem
    ... I tried to connect to the MAXIMO database in SQLPlus ... Only after manually doing a startup of the database I ... moved to Oracle without engaging more than a handful of synapses. ...
    (comp.databases.oracle.server)
  • RE: Breakable
    ... SQLPLUS into a remote database, and I use the host command, it breaks me ... Same goes for any local shell commands. ... covered quite clearly in the "how to secure your database" documentation. ... I think it comes right down to the fact that Oracle is an extremely ...
    (Bugtraq)
Loading