Can't start instance when install NW7.3 (suse11+oracle 11gR2)

[Former Member]

Hello All,

I'm in the installation of  NW7.3 pure ABAP (suse11+oracle 11gR2)

Now I am stuck at the start abap instance step see pic1

this time , it is the ASCS01 that fail to started , it advice me to start it malnually

I use "sapstart all" with kjiadm

it returns the code below in blue

linkate:kjiadm 89> sapstart all

sapstart=>sapparam(1c): No Profile used.

sapstart=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

**** unknown SAPSYSTEMNAME.

(26095) Exiting with Return-Code -101. (Unknown Sap-System-Name)

And also I copy the file dev_disp here for your reference

Could you experts help to check what's wrong with my ABAP instance?

Thank you very much in advance.

Kate JI

dev_disp.zip

[Former Member · Accepted solution]

if you could paste output of ifconfig

and as u said listerner is up

😆 sqlplus / as sysdba

😆 startup

now from sidadm:

😆 R3trans -d

then startsap

[Former Member · Accepted solution]

Hello Nik

I've posted the output here.

----------------------------

linkate:~ # su - orakji -c "lsnrctl start"

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 10-NOV-2012 09:28:50

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

TNS-01106: Listener using listener name LISTENER has already been started
linkate:~ # su - kjiadm
linkate:kjiadm 51> startsap
No instance profiles found

please send the tracefile /home/kjiadm/startsap.trc to support

linkate:kjiadm 52> R3trans -d
This is R3trans version 6.19 (release 720 - 24.08.10 - 14:38:42).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'KJI'"
R3trans finished (0012).

----------------------------

It's strange , Lsnrctl is up but SAP can't detect it , as i replied to Roman, i suggest it is some wrong config of 3 "*.ora" files(i've attach them in the reply of roman)

And here i attach the ifconifg.

Thank you very much

ifconfig.txt.zip

[Former Member · Accepted solution]

Kate,

can you tell me what kind of system setup you following .

i suppose you are on virtual machine.(host & guest)

-----------

i am not sure on why you don't have a static host name ip address for eth0, DHCP should be disabled.

check on below link for testing your system for few entries.

http://www.cyberciti.biz/faq/linux-creating-or-adding-new-network-alias-to-a-network-card-nic/

also again let me know if ping hostname is working good.

attach trans .log

[Former Member · Accepted solution]

Hello Nik,

Sorry for replying late.

Seems, it's a little bit complicated for me.

Pls , Give me some time.

Thank you and Have a nice day!

Kate

[Former Member · Accepted solution]

Hello Nik,

Sorry I've no time for this last week.

I'm now reviewing what you said.

So you mean i should bind a IP addr to my eth0?

But my Question is IP addr=????

I've no idea

-------------for reference------

linkate:/oracle/client # ifconfig
br0       Link encap:Ethernet  HWaddr 00:0C:29:8D:AE:B6 
          inet addr:192.168.142.128  Bcast:192.168.142.255  Mask:255.255.255.0
          inet6 addr: fe80::20c:29ff:fe8d:aeb6/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:1582 errors:0 dropped:0 overruns:0 frame:0
          TX packets:525 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:241284 (235.6 Kb)  TX bytes:53778 (52.5 Kb)

eth0      Link encap:Ethernet  HWaddr 00:0C:29:8D:AE:B6
          inet6 addr: fe80::20c:29ff:fe8d:aeb6/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:1917 errors:0 dropped:3 overruns:0 frame:0
          TX packets:575 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000
          RX bytes:293978 (287.0 Kb)  TX bytes:51638 (50.4 Kb)

lo        Link encap:Local Loopback
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:3855 errors:0 dropped:0 overruns:0 frame:0
          TX packets:3855 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:262233 (256.0 Kb)  TX bytes:262233 (256.0 Kb)

linkate:/oracle/client # service network restart
Shutting down network interfaces:
    br0                                                                                                                             done
    eth0      device: Intel Corporation 82545EM Gigabit Ethernet Co                                                                 done
Shutting down service network  .  .  .  .  .  .  .  .  .                                                                            done
Hint: you may set mandatory devices in /etc/sysconfig/network/config
Setting up network interfaces:
    eth0      device: Intel Corporation 82545EM Gigabit Ethernet Co
    eth0      IP address: 0.0.0.0/32                                                                                                done
    br0
    br0       Ports: [eth0]
    br0       forwarddelay (see man ifcfg-bridge) ... ready
    br0       Starting DHCP4+DHCP6 client. . . . . . . .
    br0       IP address: 192.168.142.128/24
    br0       DHCP6 continues in background                                                                                         done
Setting up service network  .  .  .  .  .  .  .  .  .  .                                                                            done
linkate:/oracle/client # ping linkate
PING linkate (192.168.52.2) 56(84) bytes of data.
From 192.168.52.1: icmp_seq=3 Destination Host Unreachable
From 192.168.52.1 icmp_seq=3 Destination Host Unreachable
64 bytes from linkate (192.168.52.2): icmp_seq=4 ttl=128 time=217 ms

-------------------

BR,

Kate

[Former Member · Accepted solution]

Hello Nik,

Thank you for your hint, it was the pb of network,

I've change my IP of linkate , made it the same as IP br0.

And all goes right!

Merci bcp!!!

Kate

[Former Member · Accepted solution]

sorry i was not able to access SCN , great you moved ahead from your problem.

[Former Member]

Please attach KJI_ASCS01_linkate and KJI_DVEBMGS00_linkate profiles from /usr/sap/KJI/SYS/profile directory.

Regards,

Roman

[Former Member]

Hello Roman,

Nice to see you again,

And as I replied to Nik and Rableen.

All the log indicates that there is no tns listener. so I attached 3 related files here.

Because i've once made changes to thoses files.and i'm not sure if there is something wrong or not.

Thank you all in advance to help me correct them

I'll attach the 2 profiles here just behind since one post only allow 3 attachments

BR,

kate

listener_ora.txt.zip

tnsnames_ora.txt.zip

sqlnet_ora.txt.zip

[Former Member]

Hello Roman,

here is 2 pfiles

Thank you !

Kate

KJI_DVEBMGS00_linkate.txt.zip

KJI_ASCS01_linkate.txt.zip

[Former Member]

You need to start your sap system with startsap command not sapstart (see your first message). This is the root cause of error:

sapstart=>sapparam(1c): No Profile used.

sapstart=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

**** unknown SAPSYSTEMNAME.

(26095) Exiting with Return-Code -101. (Unknown Sap-System-Name)

Now please try to start your sap system with

# su - orakji -c "lsnrctl start"

# su - kjiadm

> startsap

and paste output here.

Regards,

Roman

[Former Member]

Hello Roman,

The result is as below , and i attach the file

linkate:~ # su - orakji -c "lsnrctl start"

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 10-NOV-2012 09:28:50

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

TNS-01106: Listener using listener name LISTENER has already been started
linkate:~ # su - kjiadm
linkate:kjiadm 51> startsap
No instance profiles found

please send the tracefile /home/kjiadm/startsap.trc to support

I'm afraid it is related to my wrong config of 3 files (tnsnames.ora&sqlnet.ora&listener.ora) , i attach them again here, could you all help me to check them ?

Thank you very much

Kate

startsap_trc (2).txt.zip

[Former Member]

Please paste the output from the following command:

> ls /usr/sap/KJI/SYS/profile

and attach your hosts file.

Regards,
Roman

[Former Member]

Hello Roman,

here is the result

--------

linkate:/usr/sap/KJI/SYS/profile # ll

total 36

-rw-r--r-- 1 kjiadm sapsys  326 Oct  3 17:35 DEFAULT.1.PFL

-rw-r--r-- 1 kjiadm sapsys  392 Oct 31 18:31 DEFAULT.PFL

-rw-r--r-- 1 kjiadm sapsys 2126 Oct 31 18:27 KJI_ASCS01_linkate

-rw-r--r-- 1 kjiadm sapsys 2364 Oct 31 18:29 KJI_DVEBMGS00_linkate

-rw-r--r-- 1 kjiadm sapsys 2306 Oct 31 18:29 KJI_DVEBMGS00_linkate.1

drwxr-xr-x 2 kjiadm sapsys 4096 Oct 14 22:05 oracle

-rw-r--r-- 1 kjiadm sapsys 9828 Nov  9 21:52 trans.log

--------

what do you mean by hosts file? i past /etc/hosts here(just 3 lines)

-------------

127.0.0.1  localhost.localdomain localhost

192.168.52.2 linkate

::1      ipv6-localhost ipv6-loopback

----------------

Thank you

Kate

[Former Member]

Please paste the content of /etc/host.conf file also.

Regards,

Roman

[Former Member]

Hi

Did you restart the system during the installation?

If so please check the below.

All the file systems mounted properly after restart.

What kernel your on. Can you please update the kernel to the latest and restart the installation.

I also see the below error in ur work process log

failed with SQL error 12541:

C     ORA-12541: TNS:no listener

Can you please confirm your listener is up

Thanks

Kiran Nekkanti

[Former Member]

hello Roman,

Sorry for the delay. I've had a big report to finish last week...

Below is host.conf

---------

#
# /etc/host.conf - resolver configuration file
#
# Please read the manual page host.conf(5) for more information.
#
#
# The following option is only used by binaries linked against
# libc4 or libc5. This line should be in sync with the "hosts"
# option in /etc/nsswitch.conf.
#
order hosts, bind
#
# The following options are used by the resolver library:
#
multi on

---------end------------

Regards,

Kate

[Former Member]

Hello Kiran Nekkanti,

Sorry for the delay , i've had a bif report to finish last week...

Nekkanti, i've ever updated the kernel ?

Could you send me some instruction to follow ?

Thank you very much!

Best Regards,

Kate

[Former Member]

Hi kate ji,

Can you try to start with

linkate:~ # su - kjiadm

linkate:kjiadm 51> startsap linkate     

And let us know the result.

Rableen

[Former Member]

Helle Rableen,

I feel so glad that all of you are so kindto help me.Thank you all very much!

now here is the result,

------------------------------------------------

linkate:kjiadm 63> startsap linkate
Checking KJI Database
Database is not available via R3trans
-------------------------------------------
Trying to start KJI database ...
Log file: /home/kjiadm/startdb.log

No SQL*Net V2 connect to KJI available.
Check that the listener is running: "lsnrctl status".
Start the listener as user orakji: "lsnrctl start".

/usr/sap/KJI/SYS/exe/run/startdb: Terminating with error code 14
DB startup failed

please send the tracefile /home/kjiadm/startsap.trc to support

---------------------------------------

-----but I check the listener it is OK------pls see below-and I also attach the files------------------

linkate:orakji 17> lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 09-NOV-2012 21:30:10

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=KJI.WORLD))
STATUS of the LISTENER
------------------------
Alias                    LISTENER
Version                  TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                09-NOV-2012 16:23:53
Uptime                    0 days 5 hr. 6 min. 17 sec
Trace Level              off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File  /oracle/KJI/112_64/network/admin/listener.ora
Listener Log File        /oracle/diag/tnslsnr/linkate/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=KJI.WORLD)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=KJI)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linkate)(PORT=1527)))
Services Summary...
Service "KJI" has 1 instance(s).
  Instance "KJI", status UNKNOWN, has 2 handler(s) for this service...
The command completed successfully
--------------------------

Here it remind me one thing, I've been update the oracle client from 10g to 11g, during that time, I have had to config the tnsnames.ora and listener.ora myself(which i really confused about how to do) in the log files , it mentions the sqlnet.ora.

I guess maybe it is something wrong with these 3 files,

i will attach them later

BR,

Kate

startsap_trc.txt.zip

startdb_log.txt.zip

[Former Member]

paste output for

R3trans -d ( from sidadm user)

[Former Member]

Hi,

////////error////

NiIGetNodeAddr: hostname 'linkate' = addr 192.168.52.2

NiHLGetHostName: found address 192.168.52.2 in cache

NiIGetHostName: addr 192.168.52.2 = hostname 'linkate' (fq)

Tue Nov  6 15:02:46 2012

NiHLGetNodeAddr: hostname 'www.doesnotexist0156.qqq.nxst' not found by operating system

NiHLGetHostName: address 1.0.0.1 not found by operating system

NiSrvLGetServNo: got service name 'http' from operating system

NiIGetServNo: servicename 'http' = port 80

NiSrvLGetServName: got port 8080 from operating system

////////error////

Please check for below:

:>hostname

it should return the hostname

then

:>hostname -f

it shud return FQDN (example : hosntame.example.com)

if not change entry in

/etc/hosts

/etc/sysconfig/network

and type

:>service network restart

after above  steps :

:>ping hostname (in your case linkate ex : ping linkate)

above should ping properly.

thanks.

[Former Member]

Hello Nikhil

Thank you for your answer.

Below is my result

linkate:~ # hostname

linkate

linkate:~ # hostname -f

linkate

P.S. I didn't config the FQDN when installation config.

In this case , what should i do next?

[Former Member]

Kate,

Please paste the contents of hosts and network file.

are you able to ping the hostname.

😆 ping linknate

[Former Member]

Hello Nikhil

result is as below

linkate:~ # ping linkate

PING linkate (192.168.52.2) 56(84) bytes of data.

From 192.168.52.1: icmp_seq=3 Destination Host Unreachable

From 192.168.52.1 icmp_seq=3 Destination Host Unreachable

64 bytes from linkate (192.168.52.2): icmp_seq=4 ttl=128 time=213 ms

64 bytes from linkate (192.168.52.2): icmp_seq=5 ttl=128 time=211 ms

64 bytes from linkate (192.168.52.2): icmp_seq=6 ttl=128 time=212 ms

64 bytes from linkate (192.168.52.2): icmp_seq=11 ttl=128 time=211 ms

-------------/etc/hosts

127.0.0.1  localhost.localdomain localhost

192.168.52.2 linkate

::1      ipv6-localhost ipv6-loopback

• -------/etc/sysconfig/network  --> pls tell me which file you want to see, i attach 2 files here

linkate:~ # cd /etc/sysconfig/network

linkate:/etc/sysconfig/network # ll

total 100

-rw-r--r-- 1 root root 13895 Oct  3 12:31 config

-rw-r--r-- 1 root root  9956 Oct  3 12:31 dhcp

-rw-r--r-- 1 root root    91 Apr  2  2011 dhcp6r

-rw-r--r-- 1 root root    85 Apr  2  2011 dhcp6s

drwxr-xr-x 2 root root  4096 Oct  3 12:16 if-down.d

drwxr-xr-x 2 root root  4096 Oct  3 12:16 if-up.d

-rw-r--r-- 1 root root   215 Oct  3 12:31 ifcfg-br0

-rw-r--r-- 1 root root   216 Oct  3 12:31 ifcfg-eth0

-rw------- 1 root root   172 Feb  1  2012 ifcfg-lo

-rw-r--r-- 1 root root 29333 Feb  1  2012 ifcfg.template

-rw-r--r-- 1 root root   239 Feb  1  2012 ifroute-lo

drwx------ 2 root root  4096 May  5  2010 providers

drwxr-xr-x 2 root root  4096 Oct  3 12:16 scripts

BR,

Kate

ifcfg-eth0.zip

ifcfg-lo.zip

config.zip

[Former Member]

Kate,

I assume this is to do with eth0 configuration.

as i see nothing have been defined for eth0

can you manually configure eth0  from network setting.( no setting exist currently for it)

pls set for below

ip address :

netmask :

gateway  

pls do use

:>service network restart

after you change any settings

to apply the setting

i am not a pro in linux , but this seems to be an issue with linux

and try to start stop sap completely. once

then

start listener

database

sap (startsap as )

----------------

check contents of

/usr/sap/SID/SYS/profile/

DEFAULT.PFL, START PROFILE.

should consist of

SAPSYSTEMNAME = SID

thanks.

[Former Member]

also from sidadm

use command:

R3trans -d

and paste the output

[Former Member]

Hello Nikhil,

I've too little knowledge to config the eth0.

Could you show me in details how to config it ?

And for the profile.

I've checked it is OK.

Thank you again.

Kate

[Former Member]

Hello Nik

the result is depressing

--------------------

linkate:kjiadm 67> R3trans -d

This is R3trans version 6.19 (release 720 - 24.08.10 - 14:38:42).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'KJI'"

R3trans finished (0012).

-------------------

It's strange, before I succeeded in doing this command...

I will search and  attach the oracle config files soon

[Former Member]

HI,

Restart the installation and everything including OS .Hope it will work then.

Rableen

[Former Member]

Hello all,

I've corrected the /etc/hosts. Thank you Sujit.

but it is always the same error.

Is there someone can help me to check the attachment dev_disp.log? Hope there can have some clue.

Thank you all

Kate

dev_disp.zip

[Former Member]

Hello Kate,

the Dispatcher Log indicates that the workprocesses died, so you should provide the trace of a workproces, dev_w0 for example.

Edgar

[Former Member]

Hello Edgar,

Glad to see you again.

I've try another way to start the sap from which the error seems become more obvious. please see as below

----------------

linkate:~ # su - kjiadm
linkate:kjiadm 51> startsap
No instance profiles found

please send the tracefile /home/kjiadm/startsap.trc to support

-----------------

I attach the trc file here

Thank you for giving me some hint in advance.

BR,

Kate

startsap.trc.zip

[Former Member]

Hello Edgar,

I've tried 2 time to restart the server and start DB lsnrctl +DB +SAP

but only to find no dev_w0.log is generated.

the existing dev_w0.log was Nov.6

That means no new dev_* file generated when i restart today.

I've attach the dev_w0.log of Nov.6

BR,

Kate

dev_w0.zip

[sujit_sharma]

Hi Kate,

Please check the /etc/hosts file and make sure the hostname is available in the file (if not then add it and then click on "OK" to continue with SAPinst).

sapstart=>sapparam(1c): No Profile used.
sapstart=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
**** unknown SAPSYSTEMNAME.
(26095) Exiting with Return-Code -101. (Unknown Sap-System-Name)

On Suse 11, by default the hosts file contains the following lines,sometimes this also creates issue:

127.0.0.1 localhost localhost.mydomain
::1 localhost ipv6-localhost ipv6-loopback

Edit the hosts file to remove the extraneous short name entry, in this case localhost. The updated file should now contain the following lines:

127.0.0.1 localhost localhost.mydomain
::1 ipv6-localhost ipv6-loopback

Regards,

Sujit