Re: troubles with dbstart in oracle 8.1.6

Oracle's way of letting their customers know about a problem is via burying it in a ton of documentation on their web site. If you call them with a problem whey will enter keywords describing your problem into an app that will pull up previously documented problems containing those keywords to see if they can find a match.

My advice to you is that prior to *ever* changing *anything* with your installation go to metalink and under the "bug" section type in keywords related to what you want to do to see what issues await you. Had I been more consistent in following my own advice I would get lots more sleep than I do.

Not saying this would have helped you head off the dbstart issue, just general advice that in my opinion will help avoid some problems down the road.

--
Dave A


"Kirill Ponomarew" <ponomare_at_uni-duesseldorf.de> wrote in message
news:8scskp$ek6_at_poseidon.rz.uni-duesseldorf.de...


> ok it's working now, I have changed the lines

> /PL\/SQL (Release|Version)/ {substr($3,1,3) and print

 substr($3,1,3)}'`-->>


> /Oracle8i/ {substr($5,1,3) ;

> and print substr($3,1,3)}'` -->> print substr($5,1,3)}'`

> very strange that oracle didn't announce this error

>

> Bastorff <nospam_at_localhost.zz> wrote:

> >

> > The dbstart script says something like,

> >> Database "ora6" warm started.

> > But that's just a line of text. Nothing has started or "warm started".

> > This is in 8.1.6 and as stated below.

> >

> > Regards,

> > /fad

> >

> >

> > "Dave A" <dave_and_vanna_at_hotmail.com> wrote in message

> > news:sugm5c7c5g8a8c_at_corp.supernews.com...

> >> This is a common problem it would seem.  Apparently the dbstart script

 needs


> >> to be modified or it will only warm start the instance.  Specifically

 the


> >> script is looking for a string containing the "PL/SQL" and under 8.1.6,

 it


> >> doesn't appear anymore.  Basically you need to edit the dbstart script.

> >> Documentation on this has ben posted about 3-4 days ago, try dejanews

 or


> >> Metalink.

> >>

> >> --

> >> Dave A

> >>

> >>

> >> "Kirill Ponomarew" <ponomare_at_uni-duesseldorf.de> wrote in message

> >> news:8s9dl2$kgj_at_poseidon.rz.uni-duesseldorf.de...

> >> > Hallo all

> >> >

> >> > I have troubles to start "dbstart" in our Oracle server that works

 under


> >> > RedHat 6.2

> >> > I have checked all shell variables but they seem to be ok:

> >> >

> >> > ORACLE_HOME=/oracle

> >> > ORACLE_SID=ora6

> >> > ORA_NLS33=/oracle/ocommon/nls/admin/data

> >> >

> >> > If I start dbstart I got the following message:

> >> > [oracle_at_db bin]$ dbstart

> >> >

> >> > Database "ora6" warm started.

> >> >

> >> > [oracle_at_db bin]$ ps aux

> >> > USER       PID %CPU %MEM   VSZ  RSS TTY      STAT START   TIME

 COMMAND


> >> > root         1  0.0  0.0  1120  476 ?        S    Oct01   0:00 init

 [3]


> >> > root         2  0.0  0.0     0    0 ?        SW   Oct01   0:03

 [kflushd]


> >> > root         3  0.0  0.0     0    0 ?        SW   Oct01   0:04

 [kupdate]


> >> > root         4  0.0  0.0     0    0 ?        SW   Oct01   0:00

 [kpiod]


> >> > root         5  0.0  0.0     0    0 ?        SW   Oct01   0:03

 [kswapd]


> >> > root         6  0.0  0.0     0    0 ?        SW   Oct01   0:00

 [scsi_eh_1]


> >> > root       333  0.0  0.0  1172  472 ?        S    Oct01   0:00

 syslogd -m
 0


> >> > root       342  0.0  0.0  1384  432 ?        S    Oct01   0:00 klogd

> >> > daemon     356  0.0  0.0  1144  296 ?        S    Oct01   0:00

 /usr/sbin/atd


> >> > root       370  0.0  0.1  1328  564 ?        S    Oct01   0:00 crond

> >> > root       379  0.0  0.1  1704  540 ?        S    Oct01   0:05

 /usr/sbin/sshd


> >> > xfs        429  0.0  0.0  1860   60 ?        S    Oct01   0:00

 xfs -droppriv -da


> >> > root       464  0.0  0.0  1092  408 tty2     S    Oct01   0:00

 /sbin/mingetty tt


> >> > root       465  0.0  0.0  1092  408 tty3     S    Oct01   0:00

 /sbin/mingetty tt


> >> > root       466  0.0  0.0  1092  408 tty4     S    Oct01   0:00

 /sbin/mingetty tt


> >> > root       467  0.0  0.0  1092  408 tty5     S    Oct01   0:00

 /sbin/mingetty tt


> >> > root       468  0.0  0.0  1092  408 tty6     S    Oct01   0:00

 /sbin/mingetty tt


> >> > root       495  0.0  0.0  1092  408 tty1     S    Oct01   0:00

 /sbin/mingetty tt


> >> > root     18568  0.0  0.2  2384 1204 ?        S    20:42   0:00

 /usr/sbin/sshd


> >> > root     18587  0.0  0.1  2156  952 pts/0    S    20:42   0:00 su -

> >> > root     18588  0.0  0.1  1728  968 pts/0    S    20:42   0:00 -bash

> >> > root     18609  0.0  0.1  2152  884 pts/0    S    20:42   0:00 su -

 oracle


> >> > oracle   18610  0.0  0.2  2060 1208 pts/0    S    20:42   0:00 -bash2

> >> > oracle   18671  0.0  0.1  2324  692 pts/0    R    20:48   0:00 ps aux

> >> >

> >> >

> >> > ORACLE_SID is in /databases/oradata/ora6

> >> > there are the following files:

> >> > -rw-rw-r--    1 oracle   oracle   20979712 Okt 12 23:40 drsys01.dbf

> >> > -rw-rw-r--    1 oracle   oracle   20979712 Okt 12 23:40 indx01.dbf

> >> > -rw-rw-r--    1 oracle   oracle   73408512 Okt 12 23:40 rbs01.dbf

> >> > -rw-rw-r--    1 oracle   oracle   246030336 Okt 12 23:39 system01.dbf

> >> > -rw-rw-r--    1 oracle   oracle   20979712 Okt 12 23:39 temp01.dbf

> >> > -rw-rw-r--    1 oracle   oracle   10493952 Okt 12 23:40 tools01.dbf

> >> > -rw-rw-r--    1 oracle   oracle   20979712 Okt 12 23:40 users01.dbf

> >> >

> >> >

> >> >

> >> > --

> >> > Kirill Ponomarew

> >> >

> >> >

> >>

> >>

> >

> >

>

> --

> Kirill Ponomarew

>

>