Re: Oracle 10g startup problem

Ana Ribeiro wrote:
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

That means nothing. Windows is a brain-dead operating system and will
tell you whatever it wants whether that reflects reality is quite
another matter entirely.

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.

Go back to the command prompt. Do the following:

net stop oracleserviceMAXIMO
verify the database is down using SQL*Plus
net start oracleserviceMAXIMO
verify if the database is up using SQL*Plus

If it is not, which appears to be the case, drop the service using
oradim and then recreate it.

Oradim help can be found in Morgan's Library at www.psoug.org under ORADIM.

PS: Maximo? You have my sympathy. Another piece of mainframe software
moved to Oracle without engaging more than a handful of synapses.
--
Puget Sound Oracle Users Group
.

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: 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
    ... As soon as I logged in the VMware, ... I tried to connect to the MAXIMO database in SQLPlus ... ORA-01034: ORACLE not available ... Only after manually doing a startup of the database I ...
    (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)
  • Re: What so special about PostgreSQL and other RDBMS?
    ... That's exactly the link the licence agreement for the database points to when it ... comes to what wecan expect for paying support. ... > "Oracle may provide additional releases or versions of its programs ... If the requirements are volatile I'd do a long term contract detailing what ...
    (comp.lang.php)
Loading