on 03-26-2008 7:41 AM
Hello all,
can anybody help me??
I want to install Nw2000s on IBM P52 (AIX5.3 with Oracle 10g) and in step 17 of the sapinst i got an error message.
The content of the error messege is:
sapparam: sapargv( argc, argv) has not been called.
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
/usr/sap/AT3/SYS/exe/run/R3load: START OF LOG: 20080326071646
/usr/sap/AT3/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R
R3ldmain.c#13 $ SAP
/usr/sap/AT3/SYS/exe/run/R3load: version R7.00/V1.4
Compiled Jul 14 2007 03:11:05
/usr/sap/AT3/SYS/exe/run/R3load -testconnect
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/AT3/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/AT3/SYS/exe/run/R3load: END OF LOG: 20080326071646
Regards
Hope your JDK version is between 1.4.2.12 to 1.4.2.17
Try dump your DVD's on your HDD and execute from there
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Alexander,
> DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
The ORA-12541 (http://ora-12541.ora-code.com/) means that no listener is running or that the name resolution is not correct.
Please check if your listener is running and test your TNS configuration with a tnsping
> shell> su - oraat3
> shell> lsnrctl status
> shell> tnsping AT3
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Stefan,
thank you for your answer.
i checked the listener with tnsping AT3 and the listener return is ok
TNS Ping Utility for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production o
n 26-MAR-2008 10:02:13
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/oracle/AT3/102_64/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (COMMUNITY = sap.world)(PROTOCOL
= TCP)(Host = 194.113.168.xxx)(Port = 1527)) (CONNECT_DATA = (SERVER = DEDICATE
D) (SERVICE_NAME = AT3.world)))
OK (10 msec)
Hello Alexander,
ok then maybe the user at3adm has a different environment.
Please check this with:
> shell> su - at3adm
> shell> env | grep -i dbs_ora_
> shell> env | grep -i TNS
If the TNS_ADMIN variable points to a different location.. please check the settings in that folder.
If everything seems to be ok, please execute "R3trans -d" as at3adm and post the trans.log
Regards
Stefan
Hey Stefan,
the output of the commands:
at3adm 1> env | grep -i dbs_ora_
dbs_ora_tnsname=AT3
dbs_ora_schema=SAPSR3
and
at3adm 2> env | grep -i TNS
dbs_ora_tnsname=AT3
TNS_ADMIN=/oracle/AT3/102_64/network/admin
That is right or?
Here is the output of R3trans -d as <at3adm>
This is ./R3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_
ra_tnsname = 'AT3'"
./R3trans finished (0012).
Regards
Edited by: Alexander Theodor on Mar 26, 2008 10:53 AM
ohhh sorry.
trans.log:
4 ETW000 ./R3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 26.03.2008 - 11:04:06
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: ./R3trans -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Wed Mar 26 11:04:06 2008
65 0.000065
4 ETW000 [dev trc ,00000] db_con_init called
10 0.000075
4 ETW000 [dev trc ,00000] create_con (con_name=R/3)
30 0.000105
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/AT3/SYS/exe/run/dbo
raslib.o' ...
4 ETW000
36 0.000141
4 ETW000 [dev trc ,00000] load shared library (/usr/sap/AT3/SYS/exe/run/db
oraslib.o), hdl 0
4 ETW000
5282 0.005423
4 ETW000 [dev trc ,00000] Library '/usr/sap/AT3/SYS/exe/run/dboraslib.o' l
oaded
4 ETW000
16 0.005439
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sa
p/AT3/SYS/exe/run/dboraslib.o
4 ETW000
20 0.005459
4 ETW000 [dev trc ,00000] Version of '/usr/sap/AT3/SYS/exe/run/dboraslib.o
' is "700.08", patchlevel (0.107)
4 ETW000
218 0.005677
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/s
ap/AT3/SYS/exe/run/dboraslib.o
4 ETW000
18 0.005695
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/
sap/AT3/SYS/exe/run/dboraslib.o
4 ETW000
36 0.005731
4 ETW000 [dev trc ,00000] New connection 0 created
15 0.005746
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCO
NNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, oc
c = NO
4 ETW000
23 0.005769
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3)
30 0.005799
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection
for reuse:
4 ETW000
16 0.005815
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCON
NECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ
= NO
4 ETW000
20 0.005835
4 ETW000 [dev trc ,00000] Got LIBPATH=/usr/lib:/lib:/usr/sap/AT3/SYS/exe/r
un:/oracle/client/10x_64/instantclient from environment
4 ETW000
269 0.006104
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0'
49 0.006153
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0)
11 0.006164
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC
1679 0.007843
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password
19 0.007862
4 ETW000 [dev trc ,00000] Connecting as /@AT3 on connection 0 (nls_hdl 0)
... (dbsl 700 250407)
4 ETW000
17 0.007879
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet
C EnvHp ErrHp ErrHpBatch
4 ETW000
19 0.007898
4 ETW000 [dev trc ,00000] 0 WE8DEC
1 110974400 11097fa98 11097f348
4 ETW000
28 0.007926
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0
12 0.007938
4 ETW000 [dev trc ,00000] Allocating server context handle
13 0.007951
4 ETW000 [dev trc ,00000] Attaching to DB Server AT3 (con_hdl=0,svchp=1109
7cdd8,srvhp=110981db8)
4 ETW000
48 0.007999
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed w
ith rc=12514
4 ETW000
3526 0.011525
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1251
4'
4 ETW000
30 0.011555
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12514
11 0.011566
4 ETW000 [dev trc ,00000] Try to connect with default password
11 0.011577
4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@AT3 on connection 0 (
nls_hdl 0) ... (dbsl 700 250407)
4 ETW000
19 0.011596
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet
C EnvHp ErrHp ErrHpBatch
4 ETW000
18 0.011614
4 ETW000 [dev trc ,00000] 0 WE8DEC
1 110974400 11097fa98 11097f348
4 ETW000
19 0.011633
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=110981d
4 ETW000
17 0.011650
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=110
dd8,srvhp=110981db8)
4 ETW000
17 0.011667
4 ETW000 [dev trc ,00000] Deallocating server context handle 110981db8
13 0.011680
4 ETW000 [dev trc ,00000] Allocating server context handle
13 0.011693
4 ETW000 [dev trc ,00000] Attaching to DB Server AT3 (con_hdl=0,svchp=1
7cdd8,srvhp=110981db8)
4 ETW000
23 0.011716
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' faile
ith rc=12514
4 ETW000
1816 0.013532
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1
4'
4 ETW000
19 0.013551
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1251
10 0.013561
4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 12514 performing CON [
ink#3 @ 431]
4 ETW000
46 0.013607
4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12514: TNS:listener does not
rently know of service requested in connect descriptor [dblink#3 @ 431]
4 ETW000
17 0.013624
2EETW169 no connect possible: "DBMS = ORACLE --- db
ra_tnsname = 'AT3'"
please Stefan
okay Stefan,
the result of listener.ora:
################
Filename......: template listener.ora
Name..........:
Date..........:
################
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL=IPC)
(KEY=AT3.world)
)
(ADDRESS=
(PROTOCOL=IPC)
(KEY= AT3)
)
(ADDRESS =
(COMMUNITY = sap.world)
(PROTOCOL = TCP)
(Host = 194.113.xxx.xxx)
(Port = 1527)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SDU = 4096)
(SID_NAME = AT3)
(ORACLE_HOME = /oracle/AT3/102_64)
(PRESPAWN_MAX = 10)
)
)
the result of tnsnames.ora
tnsnames.ora Network Configuration File: /oracle/RV4/102_64/network/admin/tnsn
ames.ora
Generated by Oracle configuration tools.
AT3.WORLD =
(DESCRIPTION =
(ADDRESS = (COMMUNITY = sap.world)(PROTOCOL = TCP)(Host = 194.113.xxx.xxx)(P
ort = 1527))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = AT3.world)
)
)
################
Filename......: tnsnames.ora
Name..........: LOCAL_REGION.world
Date..........: 29-MAY-96 11:51:26
################
LISTENER_AT3.WORLD =
(ADDRESS = (COMMUNITY = sap.world)(PROTOCOL = TCP)(Host = 194.113.xxx.xxx)(Por
t = 1527))
and the last result of sqlnet.ora:
################
Filename......: template sqlnet.ora
Name..........:
Date..........:
################
AUTOMATIC_IPC = ON
TRACE_LEVEL_CLIENT = OFF
SQLNET.EXPIRE_TIME = 0
NAMES.DIRECTORY_PATH = (TNSNAMES)
#eingebaut lt. Hinweis 443867
NAMES.DEFAULT_DOMAIN = world
NAME.DEFAULT_ZONE = world
#SQLNET.AUTHENTICATION_SERVICES = (ALL)
and here the outout of lsnrctl status:
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production on 26-MAR-
2008 11:24:39
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=AT3.world))
STATUS of the LISTENER
-
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.2
.0 - Production
Start Date 26-MAR-2008 09:56:14
Uptime 0 days 1 hr. 28 min. 25 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /oracle/AT3/102_64/network/admin/listener.ora
Listener Log File /oracle/AT3/102_64/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=AT3.world)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=AT3)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=194.113.xxx.xxx)(PORT=1527)))
Services Summary...
Service "AT3" has 1 instance(s).
Instance "AT3", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
please. I hope we find the solution
Edited by: Alexander Theodor on Mar 26, 2008 11:28 AM
Hello Alexander,
ok please try the following:
1) rename the tnsnames.ora file to tnsnames.ora.save
2) create the tnsnames.ora file with the following content:
-
AT3.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = sap.world)
(PROTOCOL = TCP)
(HOST = 194.113.xxx.xxx)
(PORT = 1527)
)
)
(CONNECT_DATA =
(SID = AT3)
(GLOBAL_NAME = AT3.world)
)
)
LISTENER_AT3.WORLD =
(ADDRESS = (COMMUNITY = sap.world)(PROTOCOL = TCP)(Host = 194.113.xxx.xxx)(Port = 1527))
-
After that try the R3trans -d again.
Regards
Stefan
Hello Stefan,
i do everything, but the result was not successful ;-(
I get the same error message;-(
trans.log:
4 ETW000 ./R3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 26.03.2008 - 12:04:11
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: ./R3trans -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Wed Mar 26 12:04:11 2008
70 0.000070
4 ETW000 [dev trc ,00000] db_con_init called
11 0.000081
4 ETW000 [dev trc ,00000] create_con (con_name=R/3)
30 0.000111
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/AT3/SYS/exe/run/dbo
raslib.o' ...
4 ETW000
37 0.000148
4 ETW000 [dev trc ,00000] load shared library (/usr/sap/AT3/SYS/exe/run/db
oraslib.o), hdl 0
4 ETW000
5428 0.005576
4 ETW000 [dev trc ,00000] Library '/usr/sap/AT3/SYS/exe/run/dboraslib.o' l
oaded
4 ETW000
17 0.005593
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sa
p/AT3/SYS/exe/run/dboraslib.o
4 ETW000
21 0.005614
4 ETW000 [dev trc ,00000] Version of '/usr/sap/AT3/SYS/exe/run/dboraslib.o
' is "700.08", patchlevel (0.107)
4 ETW000
231 0.005845
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/s
ap/AT3/SYS/exe/run/dboraslib.o
4 ETW000
18 0.005863
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/
sap/AT3/SYS/exe/run/dboraslib.o
4 ETW000
38 0.005901
4 ETW000 [dev trc ,00000] New connection 0 created
16 0.005917
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCO
NNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, oc
c = NO
4 ETW000
22 0.005939
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3)
34 0.005973
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection
for reuse:
4 ETW000
17 0.005990
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCON
NECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ
= NO
4 ETW000
20 0.006010
4 ETW000 [dev trc ,00000] Got LIBPATH=/usr/lib:/lib:/usr/sap/AT3/SYS/exe/r
un:/oracle/client/10x_64/instantclient from environment
4 ETW000
271 0.006281
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0'
51 0.006332
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0)
12 0.006344
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC
1692 0.008036
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password
20 0.008056
4 ETW000 [dev trc ,00000] Connecting as /@AT3 on connection 0 (nls_hdl 0)
... (dbsl 700 250407)
4 ETW000
17 0.008073
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet
C EnvHp ErrHp ErrHpBatch
4 ETW000
19 0.008092
4 ETW000 [dev trc ,00000] 0 WE8DEC
1 110974400 11097fa98 11097f348
4 ETW000
29 0.008121
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0
12 0.008133
4 ETW000 [dev trc ,00000] Allocating server context handle
13 0.008146
4 ETW000 [dev trc ,00000] Attaching to DB Server AT3 (con_hdl=0,svchp=1109
7cdd8,srvhp=110981db8)
4 ETW000
50 0.008196
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed w
ith rc=12154
4 ETW000
1500 0.009696
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1215
4'
4 ETW000
29 0.009725
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12154
11 0.009736
4 ETW000 [dev trc ,00000] Try to connect with default password
12 0.009748
4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@AT3 on connection 0 (
nls_hdl 0) ... (dbsl 700 250407)
4 ETW000
19 0.009767
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet
C EnvHp ErrHp ErrHpBatch
4 ETW000
19 0.009786
4 ETW000 [dev trc ,00000] 0 WE8DEC
1 110974400 11097fa98 11097f348
4 ETW000
19 0.009805
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=110981db8)
4 ETW000
17 0.009822
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=11097c
dd8,srvhp=110981db8)
4 ETW000
18 0.009840
4 ETW000 [dev trc ,00000] Deallocating server context handle 110981db8
13 0.009853
4 ETW000 [dev trc ,00000] Allocating server context handle
14 0.009867
4 ETW000 [dev trc ,00000] Attaching to DB Server AT3 (con_hdl=0,svchp=1109
7cdd8,srvhp=110981db8)
4 ETW000
23 0.009890
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed w
ith rc=12154
4 ETW000
519 0.010409
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1215
4'
4 ETW000
18 0.010427
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12154
11 0.010438
4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 12154 performing CON [dbl
ink#3 @ 431]
4 ETW000
47 0.010485
4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12154: TNS:could not resolve the
connect identifier specified [dblink#3 @ 431]
4 ETW000
18 0.010503
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o
ra_tnsname = 'AT3'"
Hello Alexander,
i have build up your tnsnames environment here and found a little "strange" one
SDN Forum is formatting the tnsnames.ora output without the blanks in front of the connect information.
Have you copy & paste it with blanks or not?
The tnsnames.ora entry has to look like:
-
AT3.WORLD =
<blank>(DESCRIPTION =
<blank>(ADDRESS_LIST =
<blank>(ADDRESS =
<blank>(COMMUNITY = sap.world)
<blank>(PROTOCOL = TCP)
<blank>(HOST = 194.113.xxx.xxx)
<blank>(PORT = 1527)
<blank>)
<blank>)
<blank>(CONNECT_DATA =
<blank>(SID = AT3)
<blank>(GLOBAL_NAME = AT3.world)
<blank>)
<blank>)
LISTENER_AT3.WORLD =
(ADDRESS = (COMMUNITY = sap.world)(PROTOCOL = TCP)(Host = 194.113.xxx.xxx)(Port = 1527))
-
With the blanks in front of the connect information.. it is working fine in my environment.. if you don't have the blanks i also receive an "ORA-12154".
Regards
Stefan
Hi Alexander,
then i am sorry to say that.. you have to open a SAP call.. that someone can logon to your system and have a look.
I have copied your ora files and in my environment it is working fine with your configuration. (with blanks)
Without seeing it "live" on the system it is really hard to find the error.
Regards
Stefan
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.