cancel
Showing results for 
Search instead for 
Did you mean: 

NW 2004s installation, Error in step 17 ABAP import

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hello,

Our JDK version is between 1.4.2.12 to 1.4.2.17.

I change the IP-Adresse to Hostname, but i get the same error message.

I don't know what can i do.

I have everything done what you told me but the result was the same.

Regards

Theodor

stefan_koehler
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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)

stefan_koehler
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

stefan_koehler
Active Contributor
0 Kudos

Hello Alexander,

yes the environment seems to be ok.

But please post the content of the trans.log file, after you have executed "R3trans -d"... this logfile includes more information.

Regards

Stefan

Former Member
0 Kudos

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

stefan_koehler
Active Contributor
0 Kudos

Hello Alexander,

thanks for the log.

Please post the following files from the folder "/oracle/AT3/102_64/network/admin/":

- listener.ora

- tnsnames.ora

- sqlnet.ora

And please post the result of the following command:

> shell> su - oraat3

> shell> lsnrctl status

Regards

Stefan

Former Member
0 Kudos

okay Stefan,

the result of listener.ora:

################

  1. Filename......: template listener.ora

  2. Name..........:

  3. 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

  1. tnsnames.ora Network Configuration File: /oracle/RV4/102_64/network/admin/tnsn

ames.ora

  1. 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)

)

)

################

  1. Filename......: tnsnames.ora

  2. Name..........: LOCAL_REGION.world

  3. 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:

################

  1. Filename......: template sqlnet.ora

  2. Name..........:

  3. 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

stefan_koehler
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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'"

stefan_koehler
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hello Stefan,

i copy and paste the output without blanks

i edit the tnsnames.ora with blanks.

Sooooo i get the same error message ;-(

Regards

;-(

stefan_koehler
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hey Stefan,

thanks for your help;-)

but where are you from?

Regards

Alexander

stefan_koehler
Active Contributor
0 Kudos

Hello Alexander,

Germany - take a look at my profile

Regards

Stefan

Former Member
0 Kudos

Hi Alexander Theodor. We had a similar situation, the password for your DB users contains the @ symbol or not?.

Regards.

Former Member
0 Kudos

Hi,

also check Note 443867 - ORA-12154 Collective SAP note

regards,

kaushal

Former Member
0 Kudos

Hey Stefan,

ich komme auch aus Deutschland;-)

man ist das kompliziert, bin noch nicht alt solange in dem Geschäft;-)

naja aber es macht riesigen Spaß.

aber ich versteh nicht warum immer dies fehler meldung auftaucht.

Habe schon im service.sap.com nachgeschaut, ich finde nix;-(

MfG

Alexander

Former Member
0 Kudos

Also try in all files (tnsnames sqlnet listener) change the parameter "Host = 194.113.xxx.xxx" -->

"Host = "Your server name" not the IP address. Regards.