listner problem

[former_member227600]

Hi friends,

I am in serious problem. I am using AIX, oracle 9, sap4.7

I restore the data files ,orarach,redolog from PRD server to Dummy PRD server(both have same SID & same palteform)

now when i start the listner than it gives a error

Started with pid=692428

Error listening on: (ADDRESS=(PROTOCOL=tcp)(PORT=1521))

TNS-12542: TNS:address already in use

TNS-12560: TNS:protocol adapter error

TNS-00512: Address already in use

IBM/AIX RISC System/6000 Error: 67: Address already in use

Please help me

Thanks & Regards

Karan

[Former Member]

Dear Karan,

First check whether you already have Oracle Database instance running on that machine. Then check, if another listener is already run on your dummy machine ?

Finally, check on your /etc/services file, whether listener port 1521 is already used by another process ?

Ardhian

http://sapbasis.wordpress.com

Edited by: Lies Ardhian Inaroka on May 9, 2008 8:43 AM

[Former Member]

Hi. Check another listener that listens to the same port:

"ps -ef | grep lsnr" , also check this port by NETSTAT program. Can you check and post listener.ora and tnsnames.ora files here ? Are any other oracle database installed on this server? Regards.

[former_member227600]

Hi Sergo,

Thanks for reply.

i am using only one oracle database.

Listner.ORA File

1. LISTENER.ORA Network Configuration File: /oracle/PRD/920_64/network/admin/listener.ora

1. Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = tegaprod)(PORT = 1521))

)

)

(DESCRIPTION =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = PRD.WORLD)

)

)

(DESCRIPTION =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = PRD)

)

)

(DESCRIPTION =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = tegaprod)

(PORT = 1521)

)

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /oracle/PRD/920_64)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = PRD)

(ORACLE_HOME = /oracle/PRD/920_64)

(SID_NAME = PRD)

)

(SID_DESC =

(SDU = 32768)

(SID_NAME = PRD)

(ORACLE_HOME = /oracle/PRD/920_64)

)

(SID_DESC =

(SDU = 32768)

(SID_NAME = PRD)

(ORACLE_HOME = /oracle/PRD/920_64)

)

(SID_DESC =

(SDU = 32768)

(SID_NAME = PRD)

(ORACLE_HOME = /oracle/PRD/920_64)

)

(SID_DESC =

(SDU = 32768)

(SID_NAME = PRD)

(ORACLE_HOME = /oracle/PRD/920_64)

)

(SID_DESC =

(SDU = 32768)

(SID_NAME = PRD)

(ORACLE_HOME = /oracle/PRD/920_64)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF*

TNSNAMES.ORA FILE

1. TNSNAMES.ORA Network Configuration File: /oracle/PRD/920_64/network/admin/tnsnames.ora

1. Generated by Oracle configuration tools.

PRD =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = tegaprod)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = PRD)

)

)

INST1_HTTP =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = tegaprod)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = SHARED)

(SERVICE_NAME = MODOSE)

(PRESENTATION = http://HRService)

)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

PRD.WORLD =

(DESCRIPTION =

(SDU = 32768)

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = tegaprod)

(PORT = 1521)

)

)

(CONNECT_DATA =

(SID = PRD)

(GLOBAL_NAME = PRD.WORLD)

)

)*

Thanks & Regards

Karan

[Former Member]

Are you check this port are not use to another program? Check /etc/services and by NETSTAT this port 1521.

Also the "HOST = tegaprod" are the hostname to new Dummy server ? Regards.

[former_member227600]

Hi Sergo,

I check the etc/servece file

I am sending you this file .Please suggest me , what can i do now. I am a new guy on AIX system.

1. @(#)27 1.29 src/bos/etc/services/services, cmdnet, bos52B, b2003_03C6 11/8/02 07:37:05

2. IBM_PROLOG_BEGIN_TAG

3. This is an automatically generated prolog.

5. bos52B src/bos/etc/services/services 1.29

7. Licensed Materials - Property of IBM

9. (C) COPYRIGHT International Business Machines Corp. 1988,1989

10. All Rights Reserved

12. US Government Users Restricted Rights - Use, duplication or

13. disclosure restricted by GSA ADP Schedule Contract with IBM Corp.

15. IBM_PROLOG_END_TAG

#

1. COMPONENT_NAME: (CMDNET) Network commands.

3. FUNCTIONS:

#

1. ORIGINS: 26 27

#

1. (C) COPYRIGHT International Business Machines Corp. 1988, 1989

2. All Rights Reserved

3. Licensed Materials - Property of IBM

#

1. US Government Users Restricted Rights - Use, duplication or

2. disclosure restricted by GSA ADP Schedule Contract with IBM Corp.

#

1. Network services, Internet style

#

tcpmux 1/tcp # TCP Port Service Multiplexer

tcpmux 1/udp # TCP Port Service Multiplexer

compressnet 2/tcp # Management Utility

compressnet 2/udp # Management Utility

compressnet 3/tcp # Compression Process

compressnet 3/udp # Compression Process

echo 7/tcp

echo 7/udp

discard 9/tcp sink null

discard 9/udp sink null

systat 11/tcp users

daytime 13/tcp

daytime 13/udp

netstat 15/tcp

qotd 17/tcp quote

msp 18/tcp # Message Send Protocol

msp 18/udp # Message Send Protocol

chargen 19/tcp ttytst source

chargen 19/udp ttytst source

ftp-data 20/tcp

ftp 21/tcp

ssh 22/tcp # SSH Remote Login Protocol

ssh 22/udp # SSH Remote Login Protocol

telnet 23/tcp

smtp 25/tcp mail

nsw-fe 27/tcp # NSW User System FE

nsw-fe 27/udp # NSW User System E

msg-icp 29/tcp # MSG ICP

msg-icp 29/udp # MSG ICP

msg-auth 31/tcp # MSG Authentication

msg-auth 31/udp # MSG Authentication

dsp 33/tcp # Display Support Protocol

dsp 33/udp # Display Support Protocol

time 37/tcp timserver

time 37/udp timserver

rlp 39/udp resource # resource location

graphics 41/tcp # Graphics

graphics 41/udp # Graphics

nameserver 42/udp name # IEN 116

whois 43/tcp nicname

mpm-flags 44/tcp # MPM FLAGS Protocol

mpm-flags 44/udp # MPM FLAGS Protocol

mpm 45/tcp # Message Processing Module

mpm 45/udp # Message Processing Module

mpm-snd 46/tcp # MPM [default send]

mpm-snd 46/udp # MPM [default send]

ni-ftp 47/tcp # NI FTP

ni-ftp 47/udp # NI FTP

re-mail-ck 50/tcp # Remote Mail Checking Protocol

re-mail-ck 50/udp # Remote Mail Checking Protocol

la-maint 51/tcp # IMP Logical Address Maint

la-maint 51/udp # IMP Logical Address Maint

xns-time 52/tcp # XNS Time Protocol

xns-time 52/udp # XNS Time Protocol

domain 53/tcp nameserver # name-domain server

domain 53/udp nameserver

xns-ch 54/tcp # XNS Clearinghouse

xns-ch 54/udp # XNS Clearinghouse

isi-gl 55/tcp # ISI Graphics Language

isi-gl 55/udp # ISI Graphics Language

xns-auth 56/tcp # XNS Authentication

xns-auth 56/udp # XNS Authentication

mtp 57/tcp # deprecated

xns-mail 58/tcp # XNS Mail

xns-mail 58/udp # XNS Mail

ni-mail 61/tcp # NI MAIL

ni-mail 61/udp # NI MAIL

acas 62/tcp # ACA Services

acas 62/udp # ACA Services

via-ftp 63/tcp # VIA Systems - FTP

via-ftp 63/udp # VIA Systems - FTP

covia 64/tcp # Communications Integrator

covia 64/udp # Communications Integrator

tacacs-ds 65/tcp # TACACS-Database Service

tacacs-ds 65/udp # TACACS-Database Service

sqlnet 66/tcp # Oracle SQLNET

sqlnet 66/udp # Oracle SQLNET

bootps 67/udp # bootp server port

bootpc 68/udp # bootp client port

tftp 69/udp

gopher 70/tcp # Gopher

gopher 70/udp # Gopher

rje 77/tcp netrjs

vettcp 78/tcp # vettcp

vettcp 78/udp # vettcp

finger 79/tcp

www 80/tcp # World Wide Web HTTP

www 80/udp # World Wide Web HTTP

hosts2-ns 81/tcp # HOSTS2 Name Server

hosts2-ns 81/udp # HOSTS2 Name Server

xfer 82/tcp # XFER Utility

xfer 82/udp # XFER Utility

mit-ml-dev 83/tcp # MIT ML Device

mit-ml-dev 83/udp # MIT ML Device

ctf 84/tcp # Common Trace Facility

ctf 84/udp # Common Trace Facility

mit-ml-dev 85/tcp # MIT ML Device

mit-ml-dev 85/udp # MIT ML Device

mfcobol 86/tcp # Micro Focus Cobol

mfcobol 86/udp # Micro Focus Cobol

link 87/tcp ttylink

kerberos 88/tcp # Kerberos

kerberos 88/udp # Kerberos

su-mit-tg 89/tcp # SU/MIT Telnet Gateway

su-mit-tg 89/udp # SU/MIT Telnet Gateway

dnsix 90/tcp # DNSIX Security Attr. Token Map

dnsix 90/udp # DNSIX Security Attr. Token Map

mit-dov 91/tcp # MIT Dover Spooler

mit-dov 91/udp # MIT Dover Spooler

npp 92/tcp # Network Printing Protocol

npp 92/udp # Network Printing Protocol

dcp 93/tcp # Device Control Protocol

dcp 93/udp # Device Control Protocol

objcall 94/tcp # Tivoli Object Dispatcher

objcall 94/udp # Tivoli Object Dispatcher

supdup 95/tcp

dixie 96/tcp # DIXIE Protocol Specification

dixie 96/udp # DIXIE Protocol Specification

swift-rvf 97/tcp # Swift Remote Vitural File Pro.

swift-rvf 97/udp # Swift Remote Vitural File Pro.

tacnews 98/tcp # TAC News

tacnews 98/udp # TAC News

metagram 99/tcp # Metagram Relay

metagram 99/udp # Metagram Relay

hostnames 101/tcp hostname # usually from sri-nic

iso_tsap 102/tcp

x400 103/tcp

x400-snd 104/tcp

csnet-ns 105/tcp

3com-tsmux 106/tcp # 3COM-TSMUX

3com-tsmux 106/udp # 3COM-TSMUX

rtelnet 107/tcp # Remote Telnet Service

rtelnet 107/udp # Remote Telnet Service

snagas 108/tcp # SNA Gateway Access Server

snagas 108/udp # SNA Gateway Access Server

pop 109/tcp postoffice # Post Office Protocol Ver. 2

pop3 110/tcp postoffice3 # Post Office Protocol Ver. 3

sunrpc 111/tcp

sunrpc 111/udp

mcidas 112/tcp # McIDAS Data Transmission Prot.

mcidas 112/udp # McIDAS Data Transmission Prot.

auth 113/tcp authentication

audionews 114/tcp # Audio News Multicast

audionews 114/udp # Audio News Multicast

sftp 115/tcp

ansanotify 116/tcp # ANSA REX Notify

ansanotify 116/udp # ANSA REX Notify

uucp-path 117/tcp

sqlserv 118/tcp # SQL Services

sqlserv 118/udp # SQL Services

nntp 119/tcp readnews untp # USENET News Transfer Protocol

cfdptkt 120/tcp # CFDPTKT

cfdptkt 120/udp # CFDPTKT

erpc 121/tcp # Encore Expedited Remote Pro.

erpc 121/udp # Encore Expedited Remote Pro.

smakynet 122/tcp # SMAKYNET

smakynet 122/udp # SMAKYNET

ntp 123/tcp # Network Time Protocol

ntp 123/udp # Network Time Protocol

ansatrader 124/tcp # ANSA REX Trader

ansatrader 124/udp # ANSA REX Trader

locus-map 125/tcp # Locus PC-Interface Net Map Ser

locus-map 125/udp # Locus PC-Interface Net Map Ser

unitary 126/tcp # Unisys Unitary Login

unitary 126/udp # Unisys Unitary Login

locus-con 127/tcp # Locus PC-Interface Conn Server

locus-con 127/udp # Locus PC-Interface Conn Server

gss-xlicen 128/tcp # GSS X License Verification

gss-xlicen 128/udp # GSS X License Verification

pwdgen 129/tcp # Password Generator Protocol

pwdgen 129/udp # Password Generator Protocol

cisco-fna 130/tcp # cisco FNATIVE

cisco-fna 130/udp # cisco FNATIVE

cisco-tna 131/tcp # cisco TNATIVE

cisco-tna 131/udp # cisco TNATIVE

cisco-sys 132/tcp # cisco SYSMAINT

cisco-sys 132/udp # cisco SYSMAINT

statsrv 133/tcp # Statistics Service

statsrv 133/udp # Statistics Service

ingres-net 134/tcp # INGRES-NET Service

ingres-net 134/udp # INGRES-NET Service

loc-srv 135/tcp # Location Service

loc-srv 135/udp # Location Service

profile 136/tcp # PROFILE Naming System

profile 136/udp # PROFILE Naming System

netbios-ns 137/tcp # NETBIOS Name Service

netbios-ns 137/udp # NETBIOS Name Service

netbios-dgm 138/tcp # NETBIOS Datagram Service

netbios-dgm 138/udp # NETBIOS Datagram Service

netbios-ssn 139/tcp # NETBIOS Session Service

netbios-ssn 139/udp # NETBIOS Session Service

emfis-data 140/tcp # EMFIS Data Service

emfis-data 140/udp # EMFIS Data Service

emfis-cntl 141/tcp # EMFIS Control Service

emfis-cntl 141/udp # EMFIS Control Service

bl-idm 142/tcp # Britton-Lee IDM

bl-idm 142/udp # Britton-Lee IDM

imap2 143/tcp # Interim Mail Access Pro. v2

imap2 143/udp # Interim Mail Access Pro. v2

NeWS 144/tcp

uaac 145/tcp # UAAC Protocol

uaac 145/udp # UAAC Protocol

iso-tp0 146/tcp # ISO-IP0

iso-tp0 146/udp # ISO-IP0

iso-ip 147/tcp # ISO-IP

iso-ip 147/udp # ISO-IP

cronus 148/tcp # CRONUS-SUPPORT

cronus 148/udp # CRONUS-SUPPORT

aed-512 149/tcp # AED 512 Emulation Service

aed-512 149/udp # AED 512 Emulation Service

sql-net 150/tcp # SQL-NET

sql-net 150/udp # SQL-NET

hems 151/tcp # HEMS

hems 151/udp # HEMS

bftp 152/tcp # Background File Transfer Prg

bftp 152/udp # Background File Transfer Prg

sgmp 153/tcp # SGMP

sgmp 153/udp # SGMP

netsc-prod 154/tcp # NETSC

netsc-prod 154/udp # NETSC

netsc-dev 155/tcp # NETSC

netsc-dev 155/udp # NETSC

sqlsrv 156/tcp # SQL Service

sqlsrv 156/udp # SQL Service

knet-cmp 157/tcp # KNET/VM Command/Message Pro.

knet-cmp 157/udp # KNET/VM Command/Message Pro.

pcmail-srv 158/tcp # PCMail Server

pcmail-srv 158/udp # PCMail Server

nss-routing 159/tcp # NSS-Routing

nss-routing 159/udp # NSS-Routing

sgmp-traps 160/tcp # SGMP-TRAPS

sgmp-traps 160/udp # SGMP-TRAPS

snmp 161/tcp # snmp request port

snmp 161/udp # snmp request port

snmp-trap 162/tcp # snmp monitor trap port

snmp-trap 162/udp # snmp monitor trap port

cmip-man 163/tcp # CMIP/TCP Manager

cmip-man 163/udp # CMIP/TCP Manager

cmip-agent 164/tcp # CMIP/TCP Agent

cmip-agent 164/udp # CMIP/TCP Agent

xns-courier 165/tcp # Xerox

xns-courier 165/udp # Xerox

s-net 166/tcp # Sirius Systems

s-net 166/udp # Sirius Systems

namp 167/tcp # NAMP

namp 167/udp # NAMP

rsvd 168/tcp # RSVD

rsvd 168/udp # RSVD

send 169/tcp # SEND

send 169/udp # SEND

print-srv 170/tcp # Network PostScript

print-srv 170/udp # Network PostScript

multiplex 171/tcp # Network Innovations Multiplex

multiplex 171/udp # Network Innovations Multiplex

xyplex-mux 173/tcp # Xyplex

xyplex-mux 173/udp # Xyplex

mailq 174/tcp # MAILQ

mailq 174/udp # MAILQ

vmnet 175/tcp # VMNET

vmnet 175/udp # VMNET

genrad-mux 176/tcp # GENRAD-MUX

genrad-mux 176/udp # GENRAD-MUX

xdmcp 177/tcp # X Display Manager Control Pro.

xdmcp 177/udp # X Display Manager Control Pro.

nextstep 178/tcp # NextStep Window Server

NextStep 178/udp # NextStep Window Server

bgp 179/tcp # Border Gateway Protocol

bgp 179/udp # Border Gateway Protocol

ris 180/tcp # Intergraph

ris 180/udp # Intergraph

unify 181/tcp # Unify

unify 181/udp # Unify

audit 182/tcp # Unisys Audit SITP

audit 182/udp # Unisys Audit SITP

ocbinder 183/tcp # OCBinder

ocbinder 183/udp # OCBinder

ocserver 184/tcp # OCServer

ocserver 184/udp # OCServer

remote-kis 185/tcp # Remote-KIS

remote-kis 185/udp # Remote-KIS

kis 186/tcp # KIS Protocol

kis 186/udp # KIS Protocol

aci 187/tcp # Application Comm. Interface

aci 187/udp # Application Comm. Interface

mumps 188/tcp # Plus Five's MUMPS

mumps 188/udp # Plus Five's MUMPS

qft 189/tcp # Queued File Transport

qft 189/udp # Queued File Transport

gacp 190/tcp # Gateway Access Control Pro.

cacp 190/udp # Gateway Access Control Pro.

prospero 191/tcp # Prospero

prospero 191/udp # Prospero

osu-nms 192/tcp # OSU Network Monitoring System

osu-nms 192/udp # OSU Network Monitoring System

srmp 193/tcp # Spider Remote Monitoring Pro.

srmp 193/udp # Spider Remote Monitoring Pro.

irc 194/tcp # Internet Relay Chat Protocol

irc 194/udp # Internet Relay Chat Protocol

dn6-nlm-aud 195/tcp # DNSIX Net. Level Module Audit

dn6-nlm-aud 195/udp # DNSIX Net. Level Module Audit

dn6-smm-red 196/tcp # DNSIX Sess. Mgt Mod. Audit

dn6-smm-red 196/udp # DNSIX Sess. Mgt Mod. Audit

dls 197/tcp # Directory Location Service

dls 197/udp # Directory Location Service

dls-mon 198/tcp # Directory Location Serv. Mon.

dls-mon 198/udp # Directory Location Serv. Mon.

smux 199/tcp # snmpd smux port

src 200/udp # IBM System Resource controller

at-rtmp 201/tcp # AppleTalk Routing Maint.

at-rtmp 201/udp # AppleTalk Routing Maint.

at-nbp 202/tcp # AppleTalk Name Binding

at-nbp 202/udp # AppleTalk Name Binding

at-3 203/tcp # AppleTalk Unused

at-3 203/udp # AppleTalk Unused

at-echo 204/tcp # AppleTalk Echo

at-echo 204/udp # AppleTalk Echo

at-5 205/tcp # AppleTalk Unused

at-5 205/udp # AppleTalk Unused

at-zis 206/tcp # AppleTalk Zone Information

at-zis 206/udp # AppleTalk Zone Information

at-7 207/tcp # AppleTalk Unused

at-7 207/udp # AppleTalk Unused

at-8 208/tcp # AppleTalk Unused

at-8 208/udp # AppleTalk Unused

tam 209/tcp # Trivial Auth. Mail Protocol

tam 209/udp # Trivial Auth. Mail Protocol

z39.50 210/tcp # ANSI Z39.50

z39.50 210/udp # ANSI Z39.50

anet 212/tcp # ATEXSSTR

anet 212/udp # ATEXSSTR

ipx 213/tcp # IPX

ipx 213/udp # IPX

vmpwscs 214/tcp # VM PWSCS

vmpwscs 214/udp # VM PWSCS

softpc 215/tcp # Insignia Solutions

softpc 215/udp # Insignia Solutions

atls 216/tcp # Access Tech. License Server

atls 216/udp # Access Tech. License Server

dbase 217/tcp # dBASE Unix

dbase 217/udp # dBASE Unix

mpp 218/tcp # Netix Message Posting Protocol

mpp 218/udp # Netix Message Posting Protocol

uarps 219/tcp # Unisys ARPs

uarps 219/udp # Unisys ARPs

imap3 220/tcp # Interactive Mail Acces Pro. v3

imap3 220/udp # Interactive Mail Acces Pro. v3

fln-spx 221/tcp # Berkeley rlogind w/ SPX Auth.

fln-spx 221/udp # Berkeley rlogind w/ SPX Auth.

fsh-spx 222/tcp # Berkeley rshd w/ SPX Auth.

fsh-spx 222/udp # Berkeley rshd w/ SPX Auth.

cdc 223/tcp # Certificate Dist. Center

cdc 223/udp # Certificate Dist. Center

sur-meas 243/tcp # Survey Measurement

sur-meas 243/udp # Survey Measurement

dsp3270 246/tcp # Display System Protocol

dsp3270 246/udp # Display System Protocol

pawserv 345/tcp # Perf Analysis Workbench

pawserv 345/udp # Perf Analysis Workbench

zserv 346/tcp # Zebra Server

zserv 346/udp # Zebra Server

fatserv 347/tcp # Fatmen Server

fatserv 347/udp # Fatmen Server

clearcase 371/tcp # Clearcase

clearcase 371/udp # Clearcase

ulistserv 372/tcp # Unix Listserv

ulistserv 372/udp # Unix Listserv

legent-1 373/tcp # Legent Corporation

legent-1 373/udp # Legent Corporation

legent-2 374/tcp # Legent Corporation

legent-2 374/udp # Legent Corporation

#

1. UNIX specific services

#

exec 512/tcp

biff 512/udp comsat

login 513/tcp

who 513/udp whod

shell 514/tcp cmd # no passwords used

syslog 514/udp

printer 515/tcp spooler # line printer spooler

talk 517/udp

ntalk 518/udp

utime 519/tcp # unixtime

utime 519/udp # unixtime

efs 520/tcp # for LucasFilm

route 520/udp router routed

timed 525/udp timeserver

tempo 526/tcp newdate

courier 530/tcp rpc

conference 531/tcp chat

netnews 532/tcp readnews

netwall 533/udp # -for emergency broadcasts

uucp 540/tcp uucpd # uucp daemon

klogin 543/tcp

kshell 544/tcp krcmd

new-rwho 550/udp

dsf 555/tcp

dsf 555/udp

remotefs 556/tcp rfs_server rfs # Brunhoff remote filesystem

rmonitor 560/udp

monitor 561/udp

chshell 562/tcp chcmd

chshell 562/udp chcmd

9pfs 564/tcp # plan 9 file service

9pfs 564/udp # plan 9 file service

whoami 565/tcp

whoami 565/udp

meter 570/tcp demon

meter 570/udp demon

meter 571/tcp udemon

meter 571/udp udemon

ipcserver 600/tcp # Sun IPC Server

ipcserver 600/udp # Sun IPC Server

nqs 607/tcp

nqs 607/udp

rmc 657/tcp

rmc 657/udp

mdqs 666/tcp

mdqs 666/udp

elcsd 704/tcp # errlog copy/server daemon

elcsd 704/udp # errlog copy/server daemon

netcp 740/tcp # NETscout Control Protocol

netcp 740/udp # NETscout Control Protocol

netgw 741/tcp # netGW

netgw 741/udp # netGW

netrcs 742/tcp # Network Based Rev. Cont Sys.

netrcs 742/udp # Network Based Rev. Cont Sys.

flexlm 744/tcp # Flexible License Manager

flexlm 744/udp # Flexible License Manager

fujitsu-dev 747/tcp # Fujitsu Device Control

fujitsu-dev 747/udp # Fujitsu Device Control

ris-cm 748/tcp # Russell Info Sci Calendar Man.

ris-cm 748/udp # Russell Info Sci Calendar Man.

kerberos-adm 749/tcp # kerberos administration

kerberos-adm 749/udp # kerberos administration

rfile 750/tcp

loadav 750/udp

pump 751/tcp

pump 751/udp

qrh 752/tcp

qrh 752/udp

rrh 753/tcp

rrh 753/udp

tell 754/tcp

tell 754/udp

nlogin 758/tcp

nlogin 758/udp

con 759/tcp

con 759/udp

ns 760/tcp

ns 760/udp

rxe 761/tcp

rxe 761/udp

quotad 762/tcp

quotad 762/udp

cycleserv 763/tcp

cycleserv 763/udp

omserv 764/tcp

omserv 764/udp

webster 765/tcp

webster 765/udp

phonebook 767/tcp phone

phonebook 767/udp phone

vid 769/tcp

vid 769/udp

cadlock 770/tcp

cadlock 770/udp

rtip 771/tcp

rtip 771/udp

cycleserv2 772/tcp

cycleserv2 772/udp

submit 773/tcp

notify 773/udp

rpasswd 774/tcp

acmaint_dbd 774/udp

entomb 775/tcp

acmaint_transd 775/udp

wpages 776/tcp

wpages 776/udp

wpgs 780/tcp

wpgs 780/udp

hp-collector 781/tcp # HP Perf. Data Collector

hp-collector 781/udp # HP Perf. Data Collector

hp-managed-node 782/tcp # HP Perf. Data Managed Node

hp-managed-node 782/udp # HP Perf. Data Managed Node

hp-alarm-mgr 783/tcp # HP Perf. Data Alarm Manager

hp-alarm-mgr 783/udp # HP Perf. Data Alarm Manager

mdbs_daemon 800/tcp

mdbs_daemon 800/udp

device 801/tcp

device 801/udp

vsinet 996/tcp

vsinet 996/udp

maitrd 997/tcp

maitrd 997/udp

busboy 998/tcp

puparp 998/udp

garcon 999/tcp

applix 999/udp # Applix ac

puprouter 999/tcp

puprouter 999/udp

ock 1000/udp

#

blackjack 1025/tcp # Network BlackJack

blackjack 1025/udp # Network BlackJack

nim 1058/tcp # Network Installation Management (NIM)

nim 1058/udp # Network Installation Management (NIM)

nimreg 1059/tcp # Network Installation Management (NIM)

nimreg 1059/udp # Network Installation Management (NIM)

instsrv 1234/tcp # Network Install Service

hermes 1248/tcp

hermes 1248/udp

bbn-mmc 1347/tcp # multi Media Conferencing

bbn-mmc 1347/udp # multi Media Conferencing

bbn-mmx 1348/tcp # multi Media Conferencing

bbn-mmx 1348/udp # multi Media Conferencing

sbook 1349/tcp # Registration Network Protocol

sbook 1349/udp # Registration Network Protocol

editbench 1350/tcp # Registration Network Protocol

editbench 1350/udp # Registration Network Protocol

equationbuilder 1351/tcp # Digital Tool Works (MIT)

equationbuilder 1351/udp # Digital Tool Works (MIT)

lotusnote 1352/tcp # Lotus Note

lotusnote 1352/udp # Lotus Note

ingreslock 1524/tcp # ingres

orasrv 1525/tcp # oracle

orasrv 1525/udp # oracle

prospero-np 1525/tcp # prospero non-privileged

prospero-np 1525/udp # prospero non-privileged

tlisrv 1527/tcp # oracle

tlisrv 1527/udp # oracle

coauthor 1529/tcp # oracle

coauthor 1529/udp # oracle

issd 1600/tcp

issd 1600/udp

nkd 1650/tcp

nkd 1650/udp

callbook 2000/tcp

callbook 2000/udp

dc 2001/tcp

wizard 2001/udp curry

globe 2002/tcp

globe 2002/udp

mailbox 2004/tcp

emce 2004/udp # CCWS mm conf

berknet 2005/tcp

oracle 2005/udp

invokator 2006/tcp

raid-cc 2006/udp

dectalk 2007/tcp

raid-am 2007/udp

conf 2008/tcp

terminaldb 2008/udp

news 2009/tcp

whosockami 2009/udp

search 2010/tcp

pipe_server 2010/udp

raid-cc 2011/tcp

servserv 2011/udp

ttyinfo 2012/tcp

raid-ac 2012/udp

raid-am 2013/tcp

raid-cd 2013/udp

troff 2014/tcp

raid-sf 2014/udp

cypress 2015/tcp

raid-cs 2015/udp

bootserver 2016/tcp

bootserver 2016/udp

cypress-stat 2017/tcp

bootclient 2017/udp

terminaldb 2018/tcp

rellpack 2018/udp

whosockami 2019/tcp

about 2019/udp

xinupageserver 2020/tcp

xinupageserver 2020/udp

servexec 2021/tcp

xinuexpansion1 2021/udp

down 2022/tcp

xinuexpansion2 2022/udp

xinuexpansion3 2023/tcp

xinuexpansion3 2023/udp

xinuexpansion4 2024/tcp

xinuexpansion4 2024/udp

ellpack 2025/tcp

xribs 2025/udp

scrabble 2026/tcp

scrabble 2026/udp

shadowserver 2027/tcp

shadowserver 2027/udp

submitserver 2028/tcp

submitserver 2028/udp

device2 2030/tcp

device2 2030/udp

blackboard 2032/tcp

blackboard 2032/udp

glogger 2033/tcp

glogger 2033/udp

scoremgr 2034/tcp

scoremgr 2034/udp

imsldoc 2035/tcp

imsldoc 2035/udp

objectmanager 2038/tcp

objectmanager 2038/udp

lam 2040/tcp

lam 2040/udp

interbase 2041/tcp

interbase 2041/udp

isis 2042/tcp

isis 2042/udp

isis-bcast 2043/tcp

isis-bcast 2043/udp

rimsl 2044/tcp

rimsl 2044/udp

cdfunc 2045/tcp

cdfunc 2045/udp

sdfunc 2046/tcp

sdfunc 2046/udp

shilp 2049/tcp

shilp 2049/udp

xmquery 2279/udp # xmquery (PTX/PAIDE protocol)

writesrv 1334/tcp

writesrv 1334/udp

www-dev 2784/tcp # World Wide Web - development

www-dev 2784/udp # World Wide Web - development

NSWS 3049/tcp

NSWS 3049/udp

diaghttp 3997/tcp # Diagnostics Port

diagdctrl 3998/tcp # Diagnostics Port

diagtask 3999/tcp # Diagnostics Port

rfa 4672/tcp # Remote File Access Server

rfa 4672/udp # Remote File Access Server

commplex-main 5000/tcp

commplex-main 5000/udp

commplex-link 5001/tcp

commplex-link 5001/udp

rfe 5002/tcp # Radio Free Ethernet

rfe 5002/udp # Radio Free Ethernet

rmonitor_secure 5145/tcp

rmonitor_secure 5145/udp

padl2sim 5236/tcp

padl2sim 5236/udp

sub-process 6111/tcp # HP SoftBench Sub-Process Cntl.

sub-process 6111/udp # HP SoftBench Sub-Process Cntl.

xdsxdm 6558/udp

xdsxdm 6558/tcp

afs3-fileserver 7000/tcp # File Server Itself

afs3-fileserver 7000/udp # File Server Itself

afs3-callback 7001/tcp # Callbacks to Cache Managers

afs3-callback 7001/udp # Callbacks to Cache Managers

afs3-prserver 7002/tcp # Users & Groups Database

afs3-prserver 7002/udp # Users & Groups Database

afs3-vlserver 7003/tcp # Volume Location Database

afs3-vlserver 7003/udp # Volume Location Database

afs3-kaserver 7004/tcp # AFS/Kerberos Auth. Service

afs3-kaserver 7004/udp # AFS/Kerberos Auth. Service

afs3-volser 7005/tcp # Volume Managment Server

afs3-volser 7005/udp # Volume Managment Server

afs3-errors 7006/tcp # Error Interpretation Service

afs3-errors 7006/udp # Error Interpretation Service

afs3-bos 7007/tcp # Basic Overseer Process

afs3-bos 7007/udp # Basic Overseer Process

afs3-update 7008/tcp # Server-To-Server Updater

afs3-update 7008/udp # Server-To-Server Updater

afs3-rmtsys 7009/tcp # Remote Cache Manager Service

afs3-rmtsys 7009/udp # Remote Cache Manager Service

graPHIGS 8000/tcp # graPHIGS Remote Nucleus

man 9535/tcp

man 9535/udp

isode-dua 17007/tcp

isode-dua 17007/udp

sco_printer 70000/tcp sco_spooler # For System V print IPC

sco_s5_port 70001/tcp lpNet_s5_port # For future use

ipsec_sk_master 1011/udp

ipsec_sk_engine_s 4001/udp

isakmp 500/udp

tmd_isakmpd 54687/tcp

tmd_app 54688/tcp

dtspc 6112/tcp

wsmserver 9090/tcp

sapmsPRD 3600/tcp # SAP System Message Port

sapdp00 3200/tcp # SAP System Dispatcher Port

sapdp00s 4700/tcp # SAP System Dispatcher Security Port

sapgw00 3300/tcp # SAP System Gateway Central Instance Port

sapgw00s 4800/tcp # SAP System Gateway Security Port

sapgw10 3310/tcp

sapdp99 3299/tcp

Please help me.

Thanks & Regards

Karan

[Former Member]

Can you say the hostname of your dummy server ? In services file the 1521 port are not used. Are you can to press : "netstat -a" command on your dummy server and check if port 1521 are used? Regards.

[former_member227600]

Hi Sergo,

Thanks for fastest reply.

My hostname is tegaprod . Ang i check the "netstat -a".I did not see the port 1521 in the file. I am paste the information :-

1. netstat -a

Active Internet connections (including servers)

Proto Recv-Q Send-Q Local Address Foreign Address (state)

tcp4 0 0 *.daytime . LISTEN

tcp 0 0 *.ftp . LISTEN

tcp 0 0 *.telnet . LISTEN

tcp4 0 0 *.smtp . LISTEN

tcp4 0 0 *.time . LISTEN

tcp4 0 0 *.sunrpc . LISTEN

tcp4 0 0 *.smux . LISTEN

tcp 0 0 *.exec . LISTEN

tcp 0 0 *.login . LISTEN

tcp 0 0 *.shell . LISTEN

tcp4 0 0 *.klogin . LISTEN

tcp4 0 0 *.kshell . LISTEN

tcp4 0 0 *.rmc . LISTEN

tcp4 0 0 *.writesrv . LISTEN

tcp4 0 0 *.shilp . LISTEN

tcp4 0 0 *.dtspc . LISTEN

tcp4 0 1325 tegaprod.telnet 192.168.70.77.1137 ESTABLI

tcp4 0 0 *.32768 . LISTEN

tcp4 0 0 *.32769 . LISTEN

tcp4 0 0 *.32770 . LISTEN

tcp4 0 0 *.32775 . LISTEN

tcp4 0 0 *.32776 . LISTEN

tcp4 0 0 *.32777 . LISTEN

tcp4 0 0 *.wsmserve . LISTEN

tcp4 0 0 loopback.smux loopback.32774 ESTABLI

tcp4 0 0 loopback.32774 loopback.smux ESTABLI

tcp4 0 0 tegaprod.32770 tegaprod.32771 ESTABLI

tcp4 0 0 tegaprod.32771 tegaprod.32770 ESTABLI

tcp4 0 0 tegaprod.32770 tegaprod.32772 ESTABLI

tcp4 0 0 tegaprod.32772 tegaprod.32770 ESTABLI

tcp4 0 0 tegaprod.32770 tegaprod.32773 ESTABLI

tcp4 0 0 tegaprod.32773 tegaprod.32770 ESTABLI

udp4 0 0 *.daytime .

udp4 0 0 *.time .

udp4 0 0 *.sunrpc .

udp4 0 0 *.snmp .

udp4 0 0 *.xdmcp .

udp4 0 0 *.syslog .

udp4 0 0 *.ntalk .

udp4 0 0 *.608 .

udp4 0 0 *.609 .

udp4 0 0 *.610 .

udp4 0 0 *.rmc .

udp4 0 0 *.1515 .

udp4 0 0 *.shilp .

udp4 0 0 *.32768 .

udp4 0 0 *.32769 .

udp4 0 0 *.32782 .

udp4 0 0 *.32783 .

udp4 0 0 *.32786 .

udp4 0 0 *.12999 .

Active UNIX domain sockets

SADR/PCB Type Recv-Q Send-Q Inode Conn

s Nextref Addr

f1000089c038d800 dgram 0 0 f10000f0103263c8 0

0 0 /dev/.SRC-unix/SRCFlQg7b

f1000089c0389400

f1000089c0394400 dgram 0 0 f10000f010305fc8 0 f1

c0115e00 0 /dev/log

f1000089c0115700

f1000089c0845800 dgram 0 0 f10000f010304fc8 0

0 0 /dev/SRC

f1000089c0115d80

f1000089c0385000 dgram 0 0 0 f1000089c0115700

0 0

f1000089c0115e00

f1000089c0846800 dgram 0 0 f10000f010339fc8 0

0 0 /dev/.SRC-unix/SRCZ0Qg7e

f1000089c0115480

f1000089c08cf800 dgram 0 0 f10000f01030afc8 0

0 0 /dev/.SRC-unix/SRCcxQg7f

f1000089c0389100

f1000089c0845c00 dgram 0 0 f10000f010305bc8 0

0 0 /dev/.SRC-unix/SRCAhQg7a

f1000089c0115880

f1000089c08d4000 dgram 0 0 f10000f01034b3c8 0

0 0 /dev/.SRC-unix/SRCg_Qg7g

f1000089c0389080

f1000089c0846000 dgram 0 0 f10000f010306fc8 0

0 0 /dev/.SRC-unix/SRCOOQg7c

f1000089c0115580

f1000089c08cf000 stream 0 0 f10000f010319fc8 0

0 0 /tmp/dpi_socket

f1000089c0389200

f1000089c0394800 dgram 0 0 f10000f01032bbc8 0

0 0 /dev/.SRC-unix/SRClTQg7h

f1000089c0115400

f1000089c0846400 dgram 0 0 f10000f0103177c8 0

0 0 /dev/.SRC-unix/SRCUHQg7d

f1000089c0115680

f1000089c1414c00 stream 0 0 0 f1000089c1325b00

0 0 /var/ct/IW/soc/mc/RMIBM.ERRM.0

f1000089c1325900

f1000089c346ec00 stream 0 0 0 f1000089c0115500

0 0 /var/ct/IW/soc/mc/RMIBM.CSMAgentRM.0

f1000089c0115180

f1000089c140d400 stream 0 0 f10000f01078f7c8 0

0 0 /var/ct/IW/soc/mc/RMIBM.CSMAgentRM.0

f1000089c1325780

f1000089c346e000 stream 0 0 f10000f0106fd3c8 0

0 0 /var/ct/IW/soc/mc/clsrv

f1000089c0115280

f1000089c1457800 dgram 0 0 f10000f0106ba3c8 0

0 0 /dev/.SRC-unix/SRC8_Qg7i

f1000089c1325c00

f1000089c346c800 stream 0 0 f10000f01070d3c8 0

0 0 /var/ct/IW/soc/mc/rmsrv

f1000089c0115200

f1000089c140c800 stream 0 0 0 f1000089c1325880

0 0 /var/ct/IW/soc/mc/clsrv

f1000089c1325800

f1000089c140bc00 stream 0 0 f10000f01078cfc8 0

0 0 /var/ct/IW/soc/mc/RMIBM.ERRM.0

f1000089c1325a80

f1000089c3476c00 dgram 0 0 f10000f01076dfc8 0

0 0 /dev/.SRC-unix/SRCh1Qg7l

f1000089c0115300

f1000089c3473400 stream 0 0 0 f1000089c3469f00

0 0

f1000089c3469f80

f1000089c1414800 stream 0 0 0 f1000089c1325900

0 0

f1000089c1325b00

f1000089c0394000 dgram 0 0 f10000f0107b2bc8 0

0 0 /dev/.SRC-unix/SRCilQg7m

f1000089c0115100

f1000089c1414400 dgram 0 0 f10000f0107a07c8 0

0 0 /dev/.SRC-unix/SRCg5Qg7k

f1000089c1325980

f1000089c140c400 stream 0 0 f10000f0107b13c8 f1000089c1325800

0 0 /tmp/.ct_mc_221296_sec36070148240512381241da

f1000089c1325880

f1000089c1457c00 stream 0 0 f10000f0107a97c8 0

0 0 /var/ct/IW/soc/mc/RMIBM.ServiceRM.0

f1000089c0389180

f1000089c145a800 stream 0 0 f10000f01076e7c8 0

0 0 /var/ct/IW/soc/mc/RMIBM.AuditRM.0

f1000089c1325a00

f1000089c08cf400 dgram 0 0 f10000f0106ff3c8 0

0 0 /dev/.SRC-unix/SRCAGQg7j

f1000089c1325d00

f1000089c140b000 stream 0 0 0 f1000089c1325b80

0 0

f1000089c1325c80

f1000089c140b400 stream 0 0 0 f1000089c1325c80

0 0 /var/ct/IW/soc/mc/RMIBM.ServiceRM.0

f1000089c1325b80

f1000089c3473000 stream 0 0 0 f1000089c0115180

0 0

f1000089c0115500

f1000089c346f000 stream 0 0 0 f1000089c3469f80

0 0 /var/ct/IW/soc/mc/RMIBM.AuditRM.0

f1000089c3469f00

Thanks & Regards

Karan

[Former Member]

Can you reboot the server , and after try to start listener ? Also check the "lsnrctl status" , the tnsnames.ora and listener.ora are copied from your productive server (the server have same name ?) . The dummy server are separate host or how ? Try to reboot.

[former_member227600]

Hi Sergo,

I restart the server twice but i get the same result.i am sending you the lsnrctl status report.

tegaprod:oraprd 1> lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.4.0 - Production on 09-MAY-2

008 13:25:26

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))

STATUS of the LISTENER

-

---

Alias LISTENER

Version TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.4.

0 - Production

Start Date 09-MAY-2008 13:11:07

Uptime 0 days 0 hr. 14 min. 19 sec

Trace Level off

Security OFF

SNMP ON

Listener Log File /oracle/PRD/920_64/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tegaprod)(PORT=1521)))

The listener supports no services

The command completed successfully

Thanks & Reply

Karan

[Former Member]

Can you try the

sqlplus "/ as sysdba"

and after startup. Are you see any error ? I do not know why at you such mistake, wait other comments there can be who know this....

P.S. also try to write this trouble on SAP on Oracle forum.

Regards.....

[Former Member]

Hi karan Singh. Are you here? As i can see on Oracle forum, you have another error after reboot.... Can you explain the PRD server from which you restore all are in ORACLE cluster (RAC) or on this server are 2 oracle database? This error occur in RAC and the listener.ora and tnsnames.ora which at you like the RAC sap on oracle( or 2 oracle database) . Can you answer? Regards.

[former_member227600]

Hi Sergo,

Thanks for reply.

Our PRD sever run on AIX operating system ,oracle9 & sap4.7

this server has only one oracle database.host(tegaprd)

And Dummy server has the same SID with different host (tegapord) this server has AIX operating system,oracle9, sap4.7.

I restore all data file redolog file sapreorg on the dummy server

via FTP.

Thanks & Regards

Karan

[Former Member]

Hi Karan,

Ideally you should have followed a system copy procedure from SAP.

You are trying to copy only SAP and DB directories and files from x to y host. This will not make SAP operational.

There are various files at OS updated while you perform SAP Installation biz services, hosts files, environment variables, OS authorization and etc....

As you see the sapservices entries are also not available on your dummy host /etc/services file.

While it will be available on your Prodcution host.

There are few additional actions that you will need to perform to make SAP and DB operational on your Dummy server.

Refer to this thred:

Regards,

Nilesh