Home » RDBMS Server » Server Administration » problems with oracle 10 on linux after reboot
problems with oracle 10 on linux after reboot [message #245261] Fri, 15 June 2007 12:41 Go to next message
deratze
Messages: 3
Registered: June 2007
Location: Berlin
Junior Member
Hi Guys,

Maybe I get some hints here to solve my issues, I am working with Oracle rarely thus I stuck currently.

I installed Oracle 10.2.0.1 at an Ubuntu Linux box, everything was working fine until I did a reboot.

I fixed already some other errors, but now I stuck at...

Let me first show something about by environment:
- Evironment varibales are set up
env | grep ORACLE
ORACLE_BASE=/home/oracle/oracle/
ORACLE_HOME_LISTENER=$ORACLE_BASE/product/10.2.0/db_1/bin//tnslsnr
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
ORACLE_SID=orcl



- User is oracle and it is in all oracle groups
admin:x:114:oracle
oinstall:x:1001:oracle
dba:x:1002:oracle


- Permission is also OK I think
drwxr-x--- 64 oracle dba 4096 2007-06-15 17:00 db_1

- dbstart command starts the database but gives me a permission issue, I start it as user oracle and look to startup.log

./dbstart: Starting up database "orcl"
Fr 15. Jun 14:38:26 CEST 2007
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jun 15 14:38:27 2007
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
SQL> ERROR:
ORA-01031: insufficient privileges
SQL> ORA-01031: insufficient privileges
SQL>
./dbstart: Database instance "orcl" warm started.


I wonder why?

- lsnrctl services shows me that my db are up:
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "orcl" has 1 instance(s).
  Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:1 refused:0
         LOCAL SERVER


- but if I try sqlplus user/password@orcl I get an Oracle not avalaible errror

oracle@dedbs4:~/oracle/product/10.2.0/db_1$ sqlplus us/pw@orcl
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jun 15 19:18:16 2007
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory



I don't know if the permission errors and the Oracle not available errors are related.

But maybe someone from this board could show me the way in into the right direction.

Thanks in advance!
Re: problems with oracle 10 on linux after reboot [message #245263 is a reply to message #245261] Fri, 15 June 2007 12:49 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
decent post
Alternative way to start DB is as follows:
as user "oracle" do
$ id
$ sqlplus
/ as sysdba
startup
exit

do CUT & PASTE with results from above

[Updated on: Fri, 15 June 2007 13:08] by Moderator

Report message to a moderator

Re: problems with oracle 10 on linux after reboot [message #245274 is a reply to message #245261] Fri, 15 June 2007 13:21 Go to previous messageGo to next message
deratze
Messages: 3
Registered: June 2007
Location: Berlin
Junior Member
well, if I need help I guess I should spend some time to explain my issue Wink

Anyway looks like your way solved the issue.

THX a lot

 sqlplus sys/PW@orcl as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jun 15 20:12:32 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1218292 bytes
Variable Size              96471308 bytes
Database Buffers           62914560 bytes
Redo Buffers                7168000 bytes
Database mounted.
Database opened.
SQL> quit


So the issue looks for me that dbstart command doens't start my db properly.

Do you / does somebody how to start the db right away with dbstart command?

My key issue is now that the db should start properly when I am not on site after a reboot.
Re: problems with oracle 10 on linux after reboot [message #245276 is a reply to message #245274] Fri, 15 June 2007 13:26 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
You can create script for checking Availiblity of DATABASE..listener..oem wheather they are up are down?
if they go down the script back them up.
It should be scheduled for every 5 or 10 mins.

[Updated on: Fri, 15 June 2007 13:27]

Report message to a moderator

Re: problems with oracle 10 on linux after reboot [message #245278 is a reply to message #245276] Fri, 15 June 2007 13:35 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Quote:

You can create script for checking Availiblity of DATABASE..listener..oem wheather they are up are down?
if they go down the script back them up.
It should be scheduled for every 5 or 10 mins.



Hmmm. I definetely wouldn't like the idea of a script trying to re-start a database regularly when there could be any number of reasons for the database to have shut down. If it's down because of a hardware problem or a broken filesystem trying to re-start it could make things much worse.

As for dbstart after reboot :

what dbstart basicly does is check /etc/oratab and tries to start all dbs that are listed there with a "Y" at the end.

The way it does it is based on the version that is also present in /etc/oratab.

Could you check if what is listed in /etc/oratab actually matches what really is installed on the machine?

If for instance the version in /etc/oratab doesn't match the version that is really installed, dbstart might try to start the db with wrong commands.
Re: problems with oracle 10 on linux after reboot [message #245281 is a reply to message #245261] Fri, 15 June 2007 13:49 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Tradeoffs!
I NEVER autostart any database upon system boot; always manual startup.
If a database server is crashing, you have more serious problems to resolve than starting the database.
IMO, a database server should only be booted by operator intervention.
Of course, your server your rule. My servers, my rule.
Re: problems with oracle 10 on linux after reboot [message #245283 is a reply to message #245261] Fri, 15 June 2007 14:06 Go to previous message
deratze
Messages: 3
Registered: June 2007
Location: Berlin
Junior Member
I think as well a script that checks/restart database on demand is also not what I would like to do, beside a crash purpose this server will host up to 20 databases, where only 2-3 are active at the same time...

The oratab in /etc is set up properly with Y and its a new box for Oracle 10 only.

The server is just used for testing applications and if a db get corrupt I don't care, just recreate it Wink

One thing is odd.

With Oracle 9.2 on Linux it was a crux to install it and in fact it was just working after applying patches.

At Oracle 10.2 on Linux the installation was like a charm and every thing was working, but after a reboot I has the issues....

Its quite late in Germany and I think I should start with the weekend Smile

Thanks a lot for all the tips and hints so far!

May I get next week some time to proceed.

[Updated on: Fri, 15 June 2007 14:07]

Report message to a moderator

Previous Topic: Util
Next Topic: Set Password for SYS
Goto Forum:
  


Current Time: Thu Dec 05 12:42:20 CST 2024