Home » Infrastructure » Unix » Getting errors when starting listener (HP-UX B.11.00 )
Getting errors when starting listener [message #660242] Mon, 13 February 2017 06:22 Go to next message
tsar
Messages: 22
Registered: February 2017
Junior Member
Hi There

I'm currently running on HP-UX box and im new in oracle database. I get the below error when I run lsnrctl status

there is only one instance running on this box.

> lsnrctl status

LSNRCTL for HPUX: Version 8.0.4.0.0 - Production on 13-FEB-17 11:20:25

(c) Copyright 1997 Oracle Corporation. All rights reserved.

Message 1053 not found; No message file for product=NETWORK, facility=TNSMessage 1020 not found; No message file for product=NETWORK, facility=TNSMessage 1021 not found; No message file for product=NETWORK, facility=TNSMessage 1022 not found; No message file for product=NETWORK, facility=TNSMessage 1023 not found; No message file for product=NETWORK, facility=TNSMessage 1026 not found; No message file for product=NETWORK, facility=TNSMessage 1034 not found; No message file for product=NETWORK, facility=TNSMessage 1024 not found; No message file for product=NETWORK, facility=TNSMessage 1025 not found; No message file for product=NETWORK, facility=TNSMessage 1040 not found; No message file for product=NETWORK, facility=TNSMessage 1033 not found; No message file for product=NETWORK, facility=TNSMessage 1028 not found; No message file for product=NETWORK, facility=TNSMessage 1029 not found; No message file for product=NETWORK, facility=TNS Message 1039 not found; No message file for product=NETWORK, facility=TNS




> tnsping AMP

TNS Ping Utility for HPUX: Version 8.0.4.0.0 - Production on 13-FEB-17 12:52:34

(c) Copyright 1997 Oracle Corporation. All rights reserved.

Attempting to contact (ADDRESS=(COMMUNITY=sap.world)(PROTOCOL=TCP)(Host=test)(Port=1521))
Message 3509 not found; No message file for product=NETWORK, facility=TNS



> more listener.ora

################
# Filename......: template listener.ora
# Name..........:
# Date..........:
################
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL=IPC)
(KEY= LISTENER1.world)
)
(ADDRESS=
(PROTOCOL=IPC)
(KEY= AMP)
)
(ADDRESS =
(COMMUNITY = sap.world)
(PROTOCOL = TCP)
(Host = test)
(Port = 1521)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = AMP)
(ORACLE_HOME = /oracle/AMP)
(PRESPAWN_MAX = 10)
)
)




> env | sort
COLUMNS=197
EDITOR=vi
ENV=/oracle/AMP/.kshrc
ERASE=^H
FCEDIT=vi
HISTFILE=/oracle/AMP/.sh_history_dev_pts_0
HOME=/oracle/AMP
LD_LIBRARY_PATH=/oracle/AMP/lib
LIBRARY_PATH=/oracle/AMP
LINES=52
LOGNAME=oraamp
MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/upgrade/share/man /%L:/opt/upgrade/share/man:/usr/dt/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/hparray/share/man:/opt/ignite/share/man/%L:/ opt/ignite/share/man:/opt/aCC/share/man/%L:/opt/aCC/share/man:/opt/audio/share/man:/opt/blinklink/share/man:/opt/ansic/share/man/%L:/ opt/ansic/share/man:/opt/langtools/share/man/%L:/opt/langtools/share/man:/opt/CC/share/man:/opt/imake/man:/opt/perf/man/%L:/opt/perf/ man:/opt/resmon/share/man:/opt/pred/share/man/%L:/opt/pred/share/man:/opt/hpnp//man
NLS_LANG=AMERICAN_AMERICA.US7ASCII
ORACLE_HOME=/oracle/AMP
ORACLE_SID=AMP
ORA_NLS33=/oracle/AMP/ocommon/nls/admin/data
PATH=/oracle/AMP/bin:/oracle/AMP/snapstats:/usr/sap/AMP/SYS/exe/run:/bin:/usr/bin:/usr/sbin:/usr/bin/X11:/usr/ucb:/usr/ccs/bin:/usr/l ocal/bin:/etc:.
oraamp>
PWD=/oracle/AMP
SAPDATA_HOME=/oracle/AMP
SAPSYSTEMNAME=AMP
SHELL=/usr/bin/sh
STAGING_AREA=/oracle/stage/stage_804
TERM=xterm
TNS_ADMIN=/usr/sap/trans
TZ=SAST-2
_=/bin/env
dbs_ora_tnsname=AMP


> ps -ef | grep AMP
oraamp 21392 1 230 Feb 10 ? 221:30 /oracle/AMP/bin/tnslsnr LISTENER -inherit



Please kindly advise if I must supply more details.

Report message to a moderator

Re: Getting errors when starting listener [message #660243 is a reply to message #660242] Mon, 13 February 2017 06:51 Go to previous messageGo to next message
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

It looks as though your ORACLE_HOME and PATH are not set correctly. Perhaps they are pointing to some ancient release 8.0.4 installation, rather than to whatever version you are meant to be running? can you check for another, more recent, Oracle Home?

Report message to a moderator

Re: Getting errors when starting listener [message #660244 is a reply to message #660242] Mon, 13 February 2017 07:18 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
The 'message not found" messages are from the ORACLE_HOME not being correctly set.

And surely if ORACLE_SID=AMP, the ORACLE_HOME=/oracle/AMP is not the correct value for ORACLE_HOME. And I see that ORACLE_BASE is not set. It would normally be at /u01/app/oracle, with ORACLE_HOME then being at $ORACLE_BASE/product/<version number>/dbhome_1/

Is this an installation that you just created yourself?

Show us

cat /etc/oratab
ls -l /oracle/AMP

Report message to a moderator

Re: Getting errors when starting listener [message #660246 is a reply to message #660242] Mon, 13 February 2017 07:29 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 643
Registered: August 2002
Senior Member
remove the old listener and recreate it.

Report message to a moderator

Re: Getting errors when starting listener [message #660249 is a reply to message #660246] Mon, 13 February 2017 07:45 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>LSNRCTL for HPUX: Version 8.0.4.0.0 - Production on 13-FEB-17 11:20:25
REALLY?
Why did you install V8 Oracle on system?
V8 has been oboleted & unsupported this whole Century!
post proof that OS version & Oracle version are compatible with each other.

Report message to a moderator

Re: Getting errors when starting listener [message #660250 is a reply to message #660244] Mon, 13 February 2017 08:03 Go to previous messageGo to next message
tsar
Messages: 22
Registered: February 2017
Junior Member
Thank you very much for quick response

@BlackSwan
This box has been installed many years ago and its been used for references. I searched on internet if its compatible or not but I dint get much on that.

@EdStevens
Is this an installation that you just created yourself? No I did not create it by myself. 

> more /etc/oratab

#

#  This file is used by ORACLE utilities.  It is created by root.sh
#  and updated by the Oracle8 and SQL*Net install procedures.

#
#  A colon, ':', is used as the field terminator.  A new line terminates
#  the entry.  Lines beginning with a pound sign, '#', are comments.
#
#  Entries are of the form:
#      $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
#  The first and second fields are the system identifier and home
#  directory of the database respectively.  The third field indicates
#  to the dbstart utility that the database should, "Y", or should not,
#  "N", be brought up at system boot time.
#
#  Multiple entries with the same $ORACLE_SID are not allowed.
#
#
AMP:/oracle/AMP:N


> ls -l /oracle/AMP
total 392
-rw-r--r--   1 oraamp     dba           7381 Sep  7  1998 .cshrc
-rwxr-xr-x   1 oraamp     dba           1472 Aug 27  1997 .dbenv.csh
-rwxr-xr-x   1 oraamp     dba           1710 Aug  9  1999 .dbenv.sh
drwx------   2 oraamp     dba             96 Aug 18  1998 .elm
-r--r--r--   1 oraamp     dba            347 Apr 13  1997 .exrc
-rwxr-xr-x   1 oraamp     dba           5240 Aug 16  1999 .kshrc
-r--r--r--   1 oraamp     dba           1774 Apr 13  1997 .login
-rw-r--r--   1 oraamp     dba           3909 Sep  7  1998 .profile
-rw-------   1 oraamp     dba             22 Aug 10  1999 .sh_history
-rw-------   1 oraamp     dba           3522 Feb 16  2015 .sh_history_dev_console
drwxr-xr-x   3 oraamp     dba             96 May  9  1999 .sw
drwxrwxrwx   2 oraamp     dba             96 Aug 18  1998 Mail
drwxrwxrwx   2 oraamp     dba           1024 May 11  1999 ORACLESA
drwxr-xr-x   3 oraamp     dba           1024 Jul  4  2016 archtmp
drwxrwxrwx   2 oraamp     dba           3072 Aug  8  1999 bin
-rwxrwxrwx   1 oraamp     dba           4140 Apr 13  1997 bitmap_sap
-rwxrwxrwx   1 oraamp     dba           4140 Apr 13  1997 bitmap_sap.S01
drwxrwxrwx   3 oraamp     dba             96 Apr 13  1997 core3
drwxrwxrwx   3 oraamp     dba           2048 Feb 11 17:18 dbs
-rwxrwxrwx   1 oraamp     dba            538 Aug 16  1999 dev_rout
-rwxrwxrwx   1 oraamp     dba           2048 Jan 23  2000 expdat.dmp
drwxrwxrwx   6 oraamp     dba             96 Apr 13  1997 guicommon2
drwxrwxrwx   3 oraamp     dba           2048 Aug  8  1999 lib
drwxr-xr-x   2 root       root          1024 Oct  2  2014 lost+found
drwxrwxrwx   3 oraamp     dba             96 Aug  7  1999 migrate
drwxrwxrwx   5 oraamp     dba             96 Apr 13  1997 names
drwxrwxrwx   3 oraamp     dba             96 Apr 13  1997 netman
drwxrwxrwx  16 oraamp     dba           1024 Aug  8  1999 network
drwxrwxrwx   3 oraamp     dba             96 Aug  8  1999 nlsrtl
-rwxrwxrwx   1 root       sys           2740 Jul  9  1998 no_of_extents.sql
-rwxrwxrwx   1 oraamp     dba             15 Jul 24  1997 nohup.out
lrwxrwxrwx   1 root       sys             28 Oct  3  2014 oacore -> /oracle/AMD/guicommon/oacore
lrwxrwxrwx   1 root       sys             17 Oct  3  2014 oacore2 -> guicommon2/oacore
drwxrwxrwx   4 oraamp     dba             96 Aug  8  1999 ocommon
drwxrwxrwx   4 oraamp     dba             96 Aug  8  1999 oracore
drwxrwxrwx   5 oraamp     dba           6144 Aug  8  1999 orainst
drwxrwxrwx   5 oraamp     dba           4096 Aug  8  1999 orainst_sap
-rwxrwxrwx   1 oraamp     dba          47455 May  7  1997 oralist
drwxrwxrwx   3 oraamp     dba             96 Aug  8  1999 ord
drwxr-xr-x   3 oraamp     dba           1024 Feb 11 16:44 origlogA
drwxr-xr-x   3 oraamp     dba           1024 Feb 11 16:45 origlogB
drwxrwxrwx   8 oraamp     dba           1024 Aug  8  1999 otrace
drwxr-xr-x   2 root       root            96 Oct 10  2014 passwd
drwxrwxrwx   7 oraamp     dba             96 Aug  8  1999 plsql
drwxrwxrwx   5 oraamp     dba             96 Aug  8  1999 precomp
-rwxrwxrwx   1 oraamp     dba           3897 Apr 13  1997 prof
drwxrwxrwx  10 oraamp     dba           1024 Aug  8  1999 rdbms
-rwxrwxrwx   1 oraamp     dba            541 Nov 14  1997 rollback.sql
drwxr-xr-x   4 oraamp     dba           7168 Jan 19 08:10 saparch
drwxrwxrwx   2 oraamp     dba           1024 Jan 23 12:46 sapbackup
drwxrwxrwx   2 oraamp     dba           1024 Oct 10  2014 sapcheck
drwxr-xr-x  24 oraamp     dba           1024 Oct  2  2014 sapdata1
drwxr-xr-x  20 oraamp     dba           1024 Jun 24  2015 sapdata10
drwxr-xr-x  18 oraamp     dba           1024 Sep  9  2015 sapdata11
drwxr-xr-x  13 oraamp     dba           1024 Oct  2  2014 sapdata12
drwxr-xr-x  12 oraamp     dba           1024 Oct  2  2014 sapdata13
drwxr-xr-x   7 oraamp     dba           1024 Oct  2  2014 sapdata14
drwxr-xr-x   7 oraamp     dba           1024 Oct  2  2014 sapdata15
drwxr-xr-x  15 oraamp     dba           1024 Jan  5  2015 sapdata16
drwxr-xr-x  26 oraamp     dba          24576 Oct  2  2014 sapdata2
drwxr-xr-x  25 oraamp     dba           1024 Oct  2  2014 sapdata3
drwxr-xr-x  27 oraamp     dba           1024 Oct  2  2014 sapdata4
drwxr-xr-x  28 oraamp     dba           1024 Oct  2  2014 sapdata5
drwxr-xr-x  30 oraamp     dba           1024 Oct  2  2014 sapdata6
drwxr-xr-x  16 oraamp     dba           1024 Oct  2  2014 sapdata7
drwxr-xr-x   7 oraamp     dba           1024 Oct  2  2014 sapdata8
drwxr-xr-x  23 oraamp     dba           1024 Oct  2  2014 sapdata9
drwxr-xr-x  16 oraamp     dba          10240 Feb 11 14:23 sapreorg
drwxrwxrwx   2 oraamp     dba             96 Apr 13  1997 sapstat
drwxrwxrwx   4 oraamp     dba             96 Apr 13  1997 saptrace
drwxrwxrwx   4 oraamp     dba           1024 Dec 13  2001 scripts
-rwxrwxrwx   1 oraamp     dba            162 Sep 22  1997 session.lst
-rwxrwxrwx   1 oraamp     dba           2266 Sep 22  1997 session.sql
drwxrwxrwx   2 oraamp     dba           1024 Apr 13  1997 shlib
drwxrwxrwx   4 oraamp     dba             96 Aug  8  1999 slax
drwxrwxrwx   2 oraamp     dba             96 Apr 13  1997 snapstats
-rwxrwxrwx   1 oraamp     dba            324 Apr 13  1997 sqldba.log
drwxrwxrwx   3 oraamp     dba             96 Apr 13  1997 sqllib
drwxrwxrwx   8 oraamp     dba           1024 Aug  8  1999 sqlplus
-rwxrwxrwx   1 oraamp     dba            155 Nov  2  2003 startsap_automdb_00.log
drwxrwxrwx   7 oraamp     dba             96 Aug  7  1999 svrmgr
drwxrwxrwx   4 oraamp     dba             96 Apr 13  1997 tcppa
-rwxrwxrwx   1 oraamp     dba            522 Apr 13  1997 tempfile
-rwxrwxrwx   1 oraamp     dba            678 Aug  8  1999 unix.prd
-rwxrwxrwx   1 oraamp     dba            678 Aug  7  1999 unix.prd.mig
-rwxrwxrwx   1 oraamp     dba            678 Aug  7  1999 unix.prd0
-rwxrwxrwx   1 oraamp     dba            678 Aug  7  1999 unix.prdO


@John
please may you please explain again

--moderator edit: added [code] tags

[Updated on: Mon, 13 February 2017 08:22] by Moderator

Report message to a moderator

Re: Getting errors when starting listener [message #660252 is a reply to message #660250] Mon, 13 February 2017 08:25 Go to previous messageGo to next message
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
Senior Member
please use [code] tags when you paste stuff like that. I've added them for you, this time.

Is this a recent problem? Was everything fine until this morning? Or has the system perhaps been unused for a while?

Report message to a moderator

Re: Getting errors when starting listener [message #660255 is a reply to message #660252] Mon, 13 February 2017 09:09 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post results from OS command below

find / -name oracle -ls 2>/dev/null

Report message to a moderator

Re: Getting errors when starting listener [message #660296 is a reply to message #660252] Tue, 14 February 2017 04:56 Go to previous messageGo to next message
tsar
Messages: 22
Registered: February 2017
Junior Member
Hi John

this system was working fine until last few weeks. we backed up archive logs in January and we had to reboot the box and we were unable to start sap.

Do you think running old and unsupported version might have an impact on this ?


please use [code] tags?

Report message to a moderator

Re: Getting errors when starting listener [message #660297 is a reply to message #660255] Tue, 14 February 2017 05:06 Go to previous messageGo to next message
tsar
Messages: 22
Registered: February 2017
Junior Member
Hi BlackSwan

post results from OS command below

find / -name oracle -ls 2>/dev/null


test1:/> find / -name oracle -ls 2>/dev/null




> find / -name oracle | xargs ls -l
-rwsr-s--x 1 oraamp dba 22020096 Aug 8 1999 /oracle/AMP/bin/oracle

/oracle:
total 6
drwxr-xr-x 60 root root 2048 Oct 2 2014 AMP
drwxrwxrwx 5 oraamp dba 1024 Jul 14 2006 stage

/oracle/AMP/network/agent/events/oracle:
total 0
drwxr-xr-x 5 oraamp dba 96 Aug 7 1999 host
drwxr-xr-x 6 oraamp dba 96 Aug 7 1999 rdbms
drwxr-xr-x 3 oraamp dba 96 Aug 7 1999 sqlnet

/oracle/AMP/network/agent/jobs/oracle:
total 0
drwxr-xr-x 3 oraamp dba 96 Aug 7 1999 host
drwxr-xr-x 3 oraamp dba 96 Aug 7 1999 otrace
drwxr-xr-x 4 oraamp dba 96 Aug 7 1999 rdbms
drwxr-xr-x 3 oraamp dba 96 Aug 7 1999 sqlnet

/oracle/stage/stage_804/oemagent/scripts/unix/events/oracle:
total 0
drwxrwxrwx 5 oraamp dba 96 Mar 20 1998 host
drwxrwxrwx 6 oraamp dba 96 Mar 20 1998 rdbms
drwxrwxrwx 3 oraamp dba 96 Mar 20 1998 sqlnet

/oracle/stage/stage_804/oemagent/scripts/unix/jobs/oracle:
total 0
drwxrwxrwx 3 oraamp dba 96 Mar 20 1998 host
drwxrwxrwx 3 oraamp dba 96 Mar 20 1998 otrace
drwxrwxrwx 4 oraamp dba 96 Mar 20 1998 rdbms
drwxrwxrwx 3 oraamp dba 96 Mar 20 1998 sqlnet

Report message to a moderator

Re: Getting errors when starting listener [message #660298 is a reply to message #660297] Tue, 14 February 2017 05:13 Go to previous messageGo to next message
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
Senior Member
Please use code tags. I've already asked you twice, and given you the link to instructions.

Report message to a moderator

Re: Getting errors when starting listener [message #660299 is a reply to message #660296] Tue, 14 February 2017 05:45 Go to previous messageGo to next message
tsar
Messages: 22
Registered: February 2017
Junior Member
apologies missed the message with the link for code tag but I got it.

please confirm if I used it correctly

test1:/> find / -name oracle -ls 2>/dev/null



 > find / -name oracle | xargs ls -l
 -rwsr-s--x 1 oraamp dba 22020096 Aug 8 1999 /oracle/AMP/bin/oracle

 /oracle:
 total 6
 drwxr-xr-x 60 root root 2048 Oct 2 2014 AMP
 drwxrwxrwx 5 oraamp dba 1024 Jul 14 2006 stage

 /oracle/AMP/network/agent/events/oracle:
 total 0
 drwxr-xr-x 5 oraamp dba 96 Aug 7 1999 host
 drwxr-xr-x 6 oraamp dba 96 Aug 7 1999 rdbms
 drwxr-xr-x 3 oraamp dba 96 Aug 7 1999 sqlnet

 /oracle/AMP/network/agent/jobs/oracle:
 total 0
 drwxr-xr-x 3 oraamp dba 96 Aug 7 1999 host
 drwxr-xr-x 3 oraamp dba 96 Aug 7 1999 otrace
 drwxr-xr-x 4 oraamp dba 96 Aug 7 1999 rdbms
 drwxr-xr-x 3 oraamp dba 96 Aug 7 1999 sqlnet

 /oracle/stage/stage_804/oemagent/scripts/unix/events/oracle:
 total 0
 drwxrwxrwx 5 oraamp dba 96 Mar 20 1998 host
 drwxrwxrwx 6 oraamp dba 96 Mar 20 1998 rdbms
 drwxrwxrwx 3 oraamp dba 96 Mar 20 1998 sqlnet

 /oracle/stage/stage_804/oemagent/scripts/unix/jobs/oracle:
 total 0
 drwxrwxrwx 3 oraamp dba 96 Mar 20 1998 host
 drwxrwxrwx 3 oraamp dba 96 Mar 20 1998 otrace
 drwxrwxrwx 4 oraamp dba 96 Mar 20 1998 rdbms
 drwxrwxrwx 3 oraamp dba 96 Mar 20 1998 sqlnet

Report message to a moderator

Re: Getting errors when starting listener [message #660303 is a reply to message #660299] Tue, 14 February 2017 07:23 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post results of OS commands below

id
env | sort

Report message to a moderator

Re: Getting errors when starting listener [message #660304 is a reply to message #660299] Tue, 14 February 2017 07:32 Go to previous messageGo to next message
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
Senior Member
Your Oracle Home does appear to be set correctly, and the listener is running. Your "errors" are because Oracle can't find the messages file. So all it is giving you is the error numbers:
TNS-01053, TNS-01020, TNS-01021 and so on.
If you look them up, you'll see that they are informative only, telling you that the listener is fine.

The messages file may not be critical, and the directory listings do show a complete Oracle Home. I think. So perhaps all you need to do is start the database instance. Back in release 8.0 you would use the svrmgrl (Server Manager Line Mode) utility, something like this:
svrmgrl
connect internal
startup

Report message to a moderator

Re: Getting errors when starting listener [message #660305 is a reply to message #660244] Tue, 14 February 2017 07:40 Go to previous messageGo to next message
tsar
Messages: 22
Registered: February 2017
Junior Member
 

oraamp> id
uid=3203(oraamp) gid=200(dba) groups=101(oper)


> env | sort
COLUMNS=197
EDITOR=vi
ENV=/oracle/AMP/.kshrc
ERASE=^H
FCEDIT=vi
HISTFILE=/oracle/AMP/.sh_history_dev_pts_2
HOME=/oracle/AMP
LD_LIBRARY_PATH=/oracle/AMP/lib
LIBRARY_PATH=/oracle/AMP
LINES=52
LOGNAME=oraamp
MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/upgrade/share/man/%L:/opt/upgrade/share/man:/usr/dt/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/hparray/share/man:/opt/ignite/share/man/%L:/opt/ignite/share/man:/opt/aCC/share/man/%L:/opt/aCC/share/man:/opt/audio/share/man:/opt/blinklink/share/man:/opt/ansic/share/man/%L:/opt/ansic/share/man:/opt/langtools/share/man/%L:/opt/langtools/share/man:/opt/CC/share/man:/opt/imake/man:/opt/perf/man/%L:/opt/perf/man:/opt/resmon/share/man:/opt/pred/share/man/%L:/opt/pred/share/man:/opt/hpnp//man
NLS_LANG=AMERICAN_AMERICA.US7ASCII
ORACLE_HOME=/oracle/AMP
ORACLE_SID=AMP
ORA_NLS33=/oracle/AMP/ocommon/nls/admin/data
PATH=/oracle/AMP/bin:/oracle/AMP/snapstats:/usr/sap/AMP/SYS/exe/run:/bin:/usr/bin:/usr/sbin:/usr/bin/X11:/usr/ucb:/usr/ccs/bin:/usr/local/bin:/etc:.
oraamp>
PWD=/oracle/AMP
SAPDATA_HOME=/oracle/AMP
SAPSYSTEMNAME=AMP
SHELL=/usr/bin/sh
STAGING_AREA=/oracle/stage/stage_804
TERM=xterm
TNS_ADMIN=/usr/sap/trans
TZ=SAST-2
_=/bin/env
dbs_ora_tnsname=AMP




SVRMGR>
SVRMGR> connect internal
Connected.
SVRMGR>
SVRMGR> startup
ORA-01081: cannot start already-running ORACLE - shut it down first

Report message to a moderator

Re: Getting errors when starting listener [message #660315 is a reply to message #660305] Tue, 14 February 2017 13:35 Go to previous messageGo to next message
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
Senior Member
Well, that looks fine. Does your application have a problem?

Report message to a moderator

Re: Getting errors when starting listener [message #660325 is a reply to message #660315] Tue, 14 February 2017 23:14 Go to previous messageGo to next message
tsar
Messages: 22
Registered: February 2017
Junior Member
database has been started but not mounted. 

SVRMGR> select name from v$database;
NAME
---------
ORA-01507: database not mounted
SVRMGR>


ampadm>R3trans -d
This is R3trans version 5.36 (release 31I - 03.05.99 - 16:11:00).
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'AMP'"
R3trans finished (0012).



> startsap

Starting SAP-Collector Daemon
------------------------------
Starting collector (create new process)
 saposcol on host automdb started

Starting SAP R/3 AMP Database
------------------------------
 Startup-Log is written to /home/ampadm/startdb.log
 Database startup failed!
 See /home/ampadm/startdb.log for Details


ampadm> more /home/ampadm/startdb.log

------------------------------ Wed Feb 15 07:05:31 SAST 2017
LOGFILE FOR STARTING ORACLE


------------------------------ Wed Feb 15 07:05:31 SAST 2017
checking required environment variables

ORACLE_HOME  is >/oracle/AMP<
ORACLE_SID   is >AMP<

------------------------------ Wed Feb 15 07:05:31 SAST 2017
check initora


------------------------------ Wed Feb 15 07:05:31 SAST 2017
check initora


------------------------------ Wed Feb 15 07:05:31 SAST 2017
checking V2 connect


TNS Ping Utility for HPUX: Version 8.0.4.0.0 - Production on 15-FEB-17 07:05:31

(c) Copyright 1997 Oracle Corporation.  All rights reserved.

Not a terminal
Attempting to contact (ADDRESS=(COMMUNITY=sap.world)(PROTOCOL=TCP)(Host=automdb)(Port=1521))
Message 3509 not found; No message file for product=NETWORK, facility=TNS
tnsping: V2 connect to AMP

------------------------------ Wed Feb 15 07:05:31 SAST 2017
Connect to the database to check the database state:

R3trans: connect check finished with return code: 12
Database not available
*** ERROR:Database possibly left running when system
    went down(system crash?).
    Notify Database Administrator.

------------------------------ Wed Feb 15 07:05:42 SAST 2017
/usr/sap/AMP/SYS/exe/run/startdb: Terminating with error code 2

Report message to a moderator

Re: Getting errors when starting listener [message #660332 is a reply to message #660325] Wed, 15 February 2017 01:12 Go to previous messageGo to next message
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
Senior Member
In your svrmgrl session:

alter database mount;
alter database open;

Report message to a moderator

Re: Getting errors when starting listener [message #660334 is a reply to message #660332] Wed, 15 February 2017 01:44 Go to previous messageGo to next message
tsar
Messages: 22
Registered: February 2017
Junior Member
 

SVRMGR> alter database mount;
alter database mount
*
ORA-00600: internal error code, arguments: [1403], [], [], [], [], [], [], []
SVRMGR>
SVRMGR> alter database open;
alter database open
                    *
ORA-00911: invalid character
SVRMGR>
SVRMGR> alter database open;
alter database open
*
ORA-01507: database not mounted
SVRMGR>

Report message to a moderator

Re: Getting errors when starting listener [message #660335 is a reply to message #660334] Wed, 15 February 2017 01:58 Go to previous messageGo to next message
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
Senior Member
An ORA-600 error is seriously bad news. The standard answer is that it is a bug, and therefore requires a patch.
The patch may well exist, but as your system is not under support (I assume) you will not be able to get it

However, you may be able to recover. Most likely it is a problem with your controlfile.
Start by looking at your alert log, it is alert_AMP.log probably in a directory named something like
$ORACLE_HOME/udump and post everything from the last attempted start up.

Then check out your controlfile(s). THis should run, even in nomount mode:
select value from v$parameter where name='control_files';
and then see what Unix has to say about the file(s). There are probably two of them, they must be identical.
Copy them somewhere safe.

What sort of backup of the controlfile(s) do you have? Anything at all?

[Updated on: Wed, 15 February 2017 01:59]

Report message to a moderator

Re: Getting errors when starting listener [message #660338 is a reply to message #660335] Wed, 15 February 2017 02:57 Go to previous messageGo to next message
tsar
Messages: 22
Registered: February 2017
Junior Member
that's really bad new

below is alert_AMP.log
Additional information: 1
Wed Jan 18 16:21:44 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:44 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:45 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:45 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:45 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:46 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:46 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:46 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:47 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:47 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:47 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:48 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:48 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:48 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:49 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:49 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:49 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:50 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:50 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:50 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:51 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:51 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:51 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:52 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:52 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:52 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:53 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:53 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:53 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:54 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:54 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:54 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:55 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:55 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:55 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:56 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:56 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:56 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:57 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:57 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:57 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:58 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:58 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:58 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:59 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:59 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:21:59 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:00 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:00 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:01 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:01 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:01 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:02 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:02 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:02 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:03 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:03 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:03 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:04 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:04 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:04 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:05 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:05 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:05 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:06 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:06 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:06 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:07 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:07 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:07 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:08 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:08 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:08 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'



SVRMGR> select value from v$parameter where name='control_files';
VALUE
--------------------------------------------------------------------------------
?/dbs/cntrlAMP.dbf, ?/sapdata1/cntrl/cntrlAMP.dbf, ?/sapdata2/cntrl/cntrlAMP.dbf
1 row selected.
SVRMGR>



What sort of backup of the controlfile(s) do you have? Anything at all?
looks like there is backup for the control files, see below 
/> find . -name *cntrlAMP* -print
./oracle/AMP/sapdata1/cntrl/cntrlAMP.dbf
./oracle/AMP/sapdata2/cntrl/cntrlAMP.dbf
./oracle/AMP/sapreorg/backupcntrl/cntrlAMP.dbf
./oracle/AMP/sapreorg/cntrl/cntrlAMP.dbf
./oracle/AMP/sapreorg/cntrl/cntrlAMP.dbf.orig
./oracle/AMP/dbs/cntrlAMP.dbf
./oracle/AMP/dbs/cntrlAMP.dbf.18072006
./oracle/AMP/dbs/cntrlAMP.dbf.back.180706
./oracle/AMP/dbs/cntrlAMP.dbf.olone

Report message to a moderator

Re: Getting errors when starting listener [message #660339 is a reply to message #660338] Wed, 15 February 2017 03:20 Go to previous messageGo to next message
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
Senior Member
Are the three controlfile copies listed in v$parameter identical? If so, you may be able to proceed as the
alert log is (to my surprise) reporting errors with an online redo logfile, not a controlfile. Next queries:
select * from v$log;
select * from v$logfile;

Report message to a moderator

Re: Getting errors when starting listener [message #660341 is a reply to message #660338] Wed, 15 February 2017 03:35 Go to previous messageGo to next message
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
Senior Member
One point: you have posted alert log entries from January, is there really nothing since then?

Report message to a moderator

Re: Getting errors when starting listener [message #660342 is a reply to message #660339] Wed, 15 February 2017 03:37 Go to previous messageGo to next message
tsar
Messages: 22
Registered: February 2017
Junior Member
yes they are identical,

/oracle/AMP/sapdata2/cntrl> ls -ltr cntrlAMP.dbf
-rw-r-----   1 oraamp     dba        2891776 Jan 13 06:23 cntrlAMP.dbf


/oracle/AMP/sapdata1/cntrl> ls -ltr cntrlAMP.dbf
-rw-r-----   1 oraamp     dba        2891776 Jan 13 06:23 cntrlAMP.dbf


/oracle/AMP/dbs> ls -ltr cntrlAMP.dbf
-rwxrwxrwx   1 oraamp     dba        2891776 Jan 13 06:23 cntrlAMP.dbf




SVRMGR> select * from v$log;
GROUP#     THREAD#    SEQUENCE#  BYTES      MEMBERS    ARC STATUS           FIRST_CHAN FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ---------- ---------
ORA-01507: database not mounted
SVRMGR>
SVRMGR> select * from v$logfile;
GROUP#     STATUS  MEMBER
---------- ------- --------------------------------------------------------------------------------
ORA-01507: database not mounted

Report message to a moderator

Re: Getting errors when starting listener [message #660343 is a reply to message #660341] Wed, 15 February 2017 03:42 Go to previous messageGo to next message
tsar
Messages: 22
Registered: February 2017
Junior Member
no nothing on the alert_AMP.log log after 18January 

/oracle/AMP/saptrace/background> ls -ltr alert_AMP.log
-rw-r--r--   1 oraamp     dba        2147483647 Jan 18 16:22 alert_AMP.log


tail -10 alert_AMP.log
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 1
Wed Jan 18 16:22:08 2017
Errors in file /oracle/AMP/rdbms/log/ora_1498.trc:
ORA-00333: redo log read error block 1 count 64
ORA-00312: online log 3 thread 1: '/oracle/AMP/origlogA/log_g3_m1.dbf'
ORA-27072:automdb:/oracle/AMP/saptrace/background>
automdb:/oracle/AMP/saptrace/background>
automdb:/oracle/AMP/saptrace/background> ls -ltr alert_AMP.log
-rw-r--r--   1 oraamp     dba        2147483647 Jan 18 16:22 alert_AMP.log

Report message to a moderator

Re: Getting errors when starting listener [message #660344 is a reply to message #660343] Wed, 15 February 2017 03:49 Go to previous messageGo to next message
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
Senior Member
OK, lets try a restart.
It looks as though your alert log and traces are in /oracle/AMP/saptrace/background, so copy them somewhere and remove them.
Then at the svrmgrl prompt:
shutdown abort;
startup;
let's see how far it gets. A new alert log and probably some traces will have been generated, can you upload them here?

Report message to a moderator

Re: Getting errors when starting listener [message #660348 is a reply to message #660344] Wed, 15 February 2017 04:44 Go to previous messageGo to next message
tsar
Messages: 22
Registered: February 2017
Junior Member
kindly see what I have on /oracle/AMP/saptrace/background directory. 

/oracle/AMP/saptrace/background> ls -ltr
total 4194390
-rw-r--r--   1 oraamp     dba           8421 May  9  1999 changes
-rw-r--r--   1 oraamp     dba          17558 May  9  1999 datafiles.AMP
-rw-r--r--   1 oraamp     dba        2147483647 Jan 18 16:22 alert_AMP.log
drwxr-x---   2 oraamp     dba             96 Jan 25 15:20 core_21463
drwxr-x---   2 oraamp     dba             96 Feb 11 17:18 core_23902
drwxr-x---   2 oraamp     dba             96 Feb 13 15:56 core_26297

is it not fine if I rename file instead of moving it to different location ?

Report message to a moderator

Re: Getting errors when starting listener [message #660353 is a reply to message #660344] Wed, 15 February 2017 05:07 Go to previous messageGo to next message
tsar
Messages: 22
Registered: February 2017
Junior Member
Hi John

I have renamed the alert_AMP.log to alert_AMP.log.org

[code]
SVRMGR> connect internal
Connected.
SVRMGR>
SVRMGR> shutdown abort;
ORACLE instance shut down.
SVRMGR>
SVRMGR> select status from v$instance;
select status from v$instance
*
ORA-01034: ORACLE not available
SVRMGR>
SVRMGR> startup
ORACLE instance started.
Total System Global Area 336251628 bytes
Fixed Size 47852 bytes
Variable Size 139259904 bytes
Database Buffers 196608000 bytes
Redo Buffers 335872 bytes
Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oracle/AMP/origlogA/log_g1_m1.dbf'
ORA-27041: unable to open file
HP-UX Error: 13: Permission denied
Additional information: 2
/code]

New alert_AMP.log has been generated I have attached it
:/oracle/AMP/saptrace/background> ls -ltr alert_AMP.log
-rw-r--r--   1 oraamp     dba           2194 Feb 15 12:53 alert_AMP.log
  • Attachment: alert_AMP.log
    (Size: 2.14KB, Downloaded 4103 times)

Report message to a moderator

Re: Getting errors when starting listener [message #660354 is a reply to message #660353] Wed, 15 February 2017 05:11 Go to previous messageGo to next message
tsar
Messages: 22
Registered: February 2017
Junior Member
 


SVRMGR> select status from v$instance;
STATUS
-------
MOUNTED
1 row selected.
SVRMGR>

database mounted, kindly advise if I can startsap

Report message to a moderator

Re: Getting errors when starting listener [message #660355 is a reply to message #660354] Wed, 15 February 2017 05:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

The key information is:
ORA-27041: unable to open file
HP-UX Error: 13: Permission denied

You must start the instance with the owner of the files.

Report message to a moderator

Re: Getting errors when starting listener [message #660356 is a reply to message #660355] Wed, 15 February 2017 05:17 Go to previous messageGo to next message
tsar
Messages: 22
Registered: February 2017
Junior Member
ohk, I think I have to connect / as sydba

must I first shutdown arbot?

Report message to a moderator

Re: Getting errors when starting listener [message #660357 is a reply to message #660356] Wed, 15 February 2017 05:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

No, SYSDBA didn't exist in your version.
Your OS user must be the owner of the file.

ls -l /oracle/AMP/origlogA/log_g1_m1.dbf

Report message to a moderator

Re: Getting errors when starting listener [message #660358 is a reply to message #660357] Wed, 15 February 2017 05:37 Go to previous messageGo to next message
tsar
Messages: 22
Registered: February 2017
Junior Member

log_g1_m1.dbf is owned by root 
/oracle/AMP/origlogA> ls -ltr log_g1_m1.dbf
-rw-r-----   1 root       sys        20972544 Feb 11 16:44 log_g1_m1.dbf


when I ran startup I switched to oracle user which is (oraamp)

Report message to a moderator

Re: Getting errors when starting listener [message #660361 is a reply to message #660358] Wed, 15 February 2017 05:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

This is not correct, change all datafiles to oraamp/dba instead of root/sys.

Report message to a moderator

Re: Getting errors when starting listener [message #660362 is a reply to message #660361] Wed, 15 February 2017 06:19 Go to previous messageGo to next message
tsar
Messages: 22
Registered: February 2017
Junior Member

datafiles changed to oraamp:dba 

:/> ls -ltr /oracle/AMP/origlogA
total 245772
drwxr-xr-x   2 oraamp     dba             96 Oct  2  2014 lost+found
-rw-r-----   1 oraamp     dba        20972544 Jan 13 06:23 log_g1_m1.dbf.orig
-rw-r-----   1 oraamp     dba        20972544 Feb  6 16:21 log_g3_m1.dbf.org
-rw-r-----   1 oraamp     dba        20972544 Feb 11 16:44 log_g1_m1.dbf
-rw-r-----   1 oraamp     dba        20972544 Feb 11 16:44 log_g2_m1.dbf
-rw-r-----   1 oraamp     dba        20972544 Feb 11 16:44 log_g3_m1.dbf
-rw-r-----   1 oraamp     dba        20972544 Feb 11 16:44 log_g4_m1.dbf

/> ls -ltr /oracle/AMP/origlogB
total 245772
drwxr-xr-x   2 oraamp     dba             96 Oct  2  2014 lost+found
-rw-r-----   1 oraamp     dba        20972544 Jan 12 16:00 log_g4_m1.dbf.orig
-rw-r-----   1 oraamp     dba        20972544 Jan 13 06:20 log_g2_m1.dbf.orig
-rw-r-----   1 oraamp     dba        20972544 Feb 11 16:44 log_g1_m1.dbf
-rw-r-----   1 oraamp     dba        20972544 Feb 11 16:44 log_g2_m1.dbf
-rw-r-----   1 oraamp     dba        20972544 Feb 11 16:44 log_g3_m1.dbf
-rw-r-----   1 oraamp     dba        20972544 Feb 11 16:45 log_g4_m1.dbf

reran shutdown and startup 
SVRMGR> shutdown abort;
ORACLE instance shut down.
SVRMGR>
SVRMGR> startup
ORACLE instance started.
Total System Global Area                        336251628 bytes
Fixed Size                                          47852 bytes
Variable Size                                   139259904 bytes
Database Buffers                                196608000 bytes
Redo Buffers                                       335872 bytes
Database mounted.
ORA-00314: log 1 of thread 1, expected sequence# 8638 doesn't match 6702
ORA-00312: online log 1 thread 1: '/oracle/AMP/origlogA/log_g1_m1.dbf'


more alert_AMP.log
Wed Feb 15 14:03:06 2017
Shutting down instance (abort)
License high water mark = 3
Instance terminated by USER, pid = 29370
Wed Feb 15 14:03:54 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.0.4.0.0.
System parameters with non-default values:
  processes                = 130
  sessions                 = 150
  shared_pool_size         = 130000000
  enqueue_resources        = 8000
  control_files            = ?/dbs/cntrlAMP.dbf, ?/sapdata1/cntrl/cntrlAMP.dbf, ?/sapdata2/cntrl/cntrlAMP.dbf
  db_block_buffers         = 24000
  db_block_size            = 8192
  db_block_lru_latches     = 4
  log_archive_start        = TRUE
  log_archive_dest         = ?/saparch/AMParch
  log_buffer               = 327680
  log_checkpoint_interval  = 3000000000
  db_files                 = 254
  db_file_multiblock_read_count= 8
  log_checkpoints_to_alert = TRUE
  temporary_table_locks    = 200
  dml_locks                = 10000
  row_locking              = always
  max_rollback_segments    = 400
  transactions_per_rollback_segment= 10
  rollback_segments        = PRS_1, PRS_2, PRS_3, PRS_4, PRS_5, PRS_6, PRS_7, PRS_8, PRS_9, PRS_10
  transaction_auditing     = FALSE
  row_cache_cursors        = 300
  remote_os_authent        = TRUE
  sort_area_size           = 2097152
  sort_area_retained_size  = 262144
  db_name                  = AMP
  open_cursors             = 800
  optimizer_mode           = rule
  hash_join_enabled        = FALSE
  background_dump_dest     = ?/saptrace/background
  user_dump_dest           = ?/saptrace/usertrace
  max_dump_file_size       = 5000
  core_dump_dest           = ?/saptrace/background
PMON started with pid=2
DBW0 started with pid=3
ARCH started with pid=4
LGWR started with pid=5
CKPT started with pid=6
SMON started with pid=7
RECO started with pid=8
Wed Feb 15 14:03:55 2017
alter database  mount
Wed Feb 15 14:03:55 2017
Successful mount of redo thread 1.
Wed Feb 15 14:03:55 2017
Completed: alter database  mount
Wed Feb 15 14:03:55 2017
alter database open
Beginning crash recovery of 1 threads
Wed Feb 15 14:03:58 2017
Errors in file /oracle/AMP/rdbms/log/ora_29673.trc:
ORA-00314: log 1 of thread 1, expected sequence# 8638 doesn't match 6702
ORA-00312: online log 1 thread 1: '/oracle/AMP/origlogA/log_g1_m1.dbf'
ORA-314 signalled during: alter database open ...

Report message to a moderator

Re: Getting errors when starting listener [message #660363 is a reply to message #660362] Wed, 15 February 2017 06:22 Go to previous messageGo to next message
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
Senior Member
Now that your database is mounted, you can query v$log and v$logfile, to see what it is actually looking for. You are nearly there...

Report message to a moderator

Re: Getting errors when starting listener [message #660365 is a reply to message #660363] Wed, 15 February 2017 06:33 Go to previous messageGo to next message
tsar
Messages: 22
Registered: February 2017
Junior Member
lol that sounds good 

SVRMGR> select * from v$log;
GROUP#     THREAD#    SEQUENCE#  BYTES      MEMBERS    ARC STATUS           FIRST_CHAN FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ---------- ---------
         1          1       8638   20971520          1 NO  CURRENT            85860860 13-JAN-17
         2          1       8637   20971520          1 NO  INACTIVE           85859606 12-JAN-17
         3          1       8635   20971520          1 NO  INACTIVE           85858675 12-JAN-17
         4          1       8636   20971520          1 NO  INACTIVE           85858813 12-JAN-17
4 rows selected.
SVRMGR>
SVRMGR> select * from v$logfile;
GROUP#     STATUS  MEMBER
---------- ------- --------------------------------------------------------------------------------
         4         /oracle/AMP/origlogB/log_g4_m1.dbf
         3         /oracle/AMP/origlogA/log_g3_m1.dbf
         2         /oracle/AMP/origlogB/log_g2_m1.dbf
         1         /oracle/AMP/origlogA/log_g1_m1.dbf
4 rows selected.
SVRMGR>

Report message to a moderator

Re: Getting errors when starting listener [message #660369 is a reply to message #660365] Wed, 15 February 2017 07:38 Go to previous messageGo to next message
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
Senior Member
This tells us that the online logfile /oracle/AMP/origlogA/log_g1_m1.dbf is the incorrect version. It is as though
someone had copied an older version of it over the live version. That is something one should never do, and
unless you can find the correct version of that file you are in trouble. The official story is that if your
current online logfile group is damaged (and yours is) your only recourse is to restore the entire database
from your last whole, closed, backup. Do you have a recent whole closed backup, and are you prepared to lose
all work since? If not, there are hacks that may allow you to open the database, but no promises.

Note that if one file has been "accidentally" restored, others may have the same problem.

Report message to a moderator

Re: Getting errors when starting listener [message #660371 is a reply to message #660369] Wed, 15 February 2017 08:02 Go to previous messageGo to next message
tsar
Messages: 22
Registered: February 2017
Junior Member
Hi John

my colleague copied below files(Feb 11*) from root to origlogA and origlogB.

the original files that were there before this issue are all dbf.orig

/> ls -ltr /oracle/AMP/origlogA
total 245772
drwxr-xr-x   2 oraamp     dba             96 Oct  2  2014 lost+found
-rw-r-----   1 oraamp     dba        20972544 Jan 13 06:23 log_g1_m1.dbf.orig
-rw-r-----   1 oraamp     dba        20972544 Feb  6 16:21 log_g3_m1.dbf.org
-rw-r-----   1 oraamp     dba        20972544 Feb 11 16:44 log_g1_m1.dbf
-rw-r-----   1 oraamp     dba        20972544 Feb 11 16:44 log_g2_m1.dbf
-rw-r-----   1 oraamp     dba        20972544 Feb 11 16:44 log_g3_m1.dbf
-rw-r-----   1 oraamp     dba        20972544 Feb 11 16:44 log_g4_m1.dbf

/> ls -ltr /oracle/AMP/origlogB
total 245772
drwxr-xr-x   2 oraamp     dba             96 Oct  2  2014 lost+found
-rw-r-----   1 oraamp     dba        20972544 Jan 12 16:00 log_g4_m1.dbf.orig
-rw-r-----   1 oraamp     dba        20972544 Jan 13 06:20 log_g2_m1.dbf.orig
-rw-r-----   1 oraamp     dba        20972544 Feb 11 16:44 log_g1_m1.dbf
-rw-r-----   1 oraamp     dba        20972544 Feb 11 16:44 log_g2_m1.dbf
-rw-r-----   1 oraamp     dba        20972544 Feb 11 16:44 log_g3_m1.dbf
-rw-r-----   1 oraamp     dba        20972544 Feb 11 16:45 log_g4_m1.dbf

Remember that you asked me earlier to change owner and group for datafiles, it was due to that move of files and I was unaware. kindly advise if we can move back these files and rename dbf.orig back to its original name.

on Friday the 10th we had only 2 files on origlogA and origlogB

/> ls -ltr /oracle/AMP/origlogB
total 245772
drwxr-xr-x   2 oraamp     dba             96 Oct  2  2014 lost+found
-rw-r-----   1 oraamp     dba        20972544 Jan 12 16:00 log_g4_m1.dbf.orig
-rw-r-----   1 oraamp     dba        20972544 Jan 13 06:20 log_g2_m1.dbf.orig

/> ls -ltr /oracle/AMP/origlogA
total 245772
drwxr-xr-x   2 oraamp     dba             96 Oct  2  2014 lost+found
-rw-r-----   1 oraamp     dba        20972544 Jan 13 06:23 log_g1_m1.dbf.orig
-rw-r-----   1 oraamp     dba        20972544 Feb  6 16:21 log_g3_m1.dbf.org

Report message to a moderator

Re: Getting errors when starting listener [message #660419 is a reply to message #660371] Thu, 16 February 2017 02:55 Go to previous messageGo to previous message
tsar
Messages: 22
Registered: February 2017
Junior Member
Hi John

may you please kindly confirm if we can rename the original online log and move the old ones back to its location.

regards

Report message to a moderator

Previous Topic: ./dbstart: test: argument expected
Next Topic: Function call in Unix to assign value to a refcursor variable
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 30 15:17:13 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.