cancel
Showing results for 
Search instead for 
Did you mean: 

Error connecting to database during installation

Former Member
0 Kudos

Hello,

My Oracle problems continue on this NW Mobile 7.1 Windows/Oracle (x64) installation.

I have now reached the SAPINST step Perform Oracle Post Load Activities.

It ends with an error.

Brconnect.log:

BR0801I BRCONNECT 7.10 (3)

BR0280I BRCONNECT time stamp: 2009-07-22 13.42.02

BR0301E SQL error -12560 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-12560: TNS:protocol adapter error

BR0310E Connect to database instance PMD failed

BR0280I BRCONNECT time stamp: 2009-07-22 13.42.02

BR0804I BRCONNECT terminated with errors

Sqlnet.log:

***********************************************************************

Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oraclePMD)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=PMD)(CID=(PROGRAM=H:\usr\sap\PMD\SYS\exe\uc\NTAMD64\brconnect.exe)(HOST=AUDVSAP3)(USER=pmdadm))))

VERSION INFORMATION:

TNS for 64-bit Windows: Version 10.2.0.2.0 - Production

Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 10.2.0.2.0 - Production

Time: 22-JUL-2009 13:42:02

Tracing not turned on.

Tns error struct:

ns main err code: 12560

TNS-12560: TNS:protocol adapter error

ns secondary err code: 0

nt main err code: 530

TNS-00530: Protocol adapter error

nt secondary err code: 193

nt OS err code: 0

***********************************************************************

Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oraclePMD)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=PMD)(CID=(PROGRAM=H:\usr\sap\PMD\SYS\exe\uc\NTAMD64\brconnect.exe)(HOST=AUDVSAP3)(USER=pmdadm))))

VERSION INFORMATION:

TNS for 64-bit Windows: Version 10.2.0.2.0 - Production

Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 10.2.0.2.0 - Production

Time: 22-JUL-2009 13:42:02

Tracing not turned on.

Tns error struct:

ns main err code: 12560

TNS-12560: TNS:protocol adapter error

ns secondary err code: 0

nt main err code: 530

TNS-00530: Protocol adapter error

nt secondary err code: 193

nt OS err code: 0

If I run R3trans u2013dw as <sid>adm then it return ok (0)

If I run the same command as the SAPINST:

brconnect.exe -u / -c -f crsyn -o SAPSR3

Then I get the same error as above.

If I connect to the database as:

Sqlplus as / sysdba

The I get connected without any problems, and can start and stop the DB etc.

If the database is shut down and i connect to the database as SAPSR3 or SYSTEM via sqlplus, then I get this error:

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

If I start the database (as /) and connect to the database as SYSTEM or SAPSR3, then I get the error:

ERROR:

ORA-01017: invalid username/password; logon denied

Even though I know I am giving the correct password.

What can this be?

Regards,

Kenneth

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

May be your ORACLE_HOME is not set properly,login with SIDadm

start>Run>cmd->set ORACLE_HOME=<Your oracle home directory>

after that set ORACLE_SID=<Your datbase SID>

then execute this command sqlplus "/as sysdba"

sql>select username, account_status from dba_users;

see whether any user got locked

Let me know what is the out of that

Regards

Uday

Former Member
0 Kudos

ORACLE_HOME and ORACLE_SID is set correct.

As i said, it is only if i run sqlplus from another drive directory than fx. c: ... Very starnge.

Here is the result:

USERNAME ACCOUNT_STATUS

-


-


SYS OPEN

SYSTEM OPEN

OPS$BANE\SAPSERVICEPMD OPEN

OPS$BANE\PMDADM OPEN

SAPSR3 OPEN

OUTLN LOCKED

DBSNMP EXPIRED & LOCKED

TSMSYS EXPIRED & LOCKED

DIP EXPIRED & LOCKED

9 rows selected.

SQL>

Former Member
0 Kudos

I have just discovered something more starnge.

After i have installed the new system (partial), then no of the other systems on the server is working, they cant start their listener:

Other system:

************************

C:\Documents and Settings\pedadm>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.2.0 - Production on 24-JUL-2009 07:29

:50

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

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PED.WORLD))

TNS-12557: TNS:protocol adapter not loadable

TNS-12560: TNS:protocol adapter error

TNS-00527: Protocol Adapter not loadable

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PED))

TNS-12557: TNS:protocol adapter not loadable

TNS-12560: TNS:protocol adapter error

TNS-00527: Protocol Adapter not loadable

Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=AUDVSAP3)(PORT=1

527))

TNS-12557: TNS:protocol adapter not loadable

TNS-12560: TNS:protocol adapter error

TNS-00527: Protocol Adapter not loadable

C:\Documents and Settings\pedadm>lsnrctl start

LSNRCTL for 32-bit Windows: Version 10.2.0.2.0 - Production on 24-JUL-2009 07:29

:54

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

Starting tnslsnr: please wait...

TNS-12557: TNS:protocol adapter not loadable

TNS-12560: TNS:protocol adapter error

TNS-00527: Protocol Adapter not loadable

C:\Documents and Settings\pedadm>

************************

If i uninstall the new system and oracle, then the problem with the existing system goes away.. What is happening here?

EDIT: The new system is NW 7.1 the existing systems are NW 7.0

Edited by: Kenneth Nielsen on Jul 24, 2009 7:35 AM

Former Member
0 Kudos

Hi,

Check the below note.

Note 723147 - ORA-12542: TNS: address already in use

Other terms

ora-12542, ora-12560, ora-00512, ora-512, tns-512, 12542, 12560, 512

Reason and Prerequisites

The system will issue an ORA-12542 error message if a port that is defined in the listener.ora file is already used by another process.

Solution

Check whether you are already executing another listener that listens to the same port:

ps -ef | grep lsnr

Ensure that you are only executing one listener or that the current listeners do not use the same port numbers.

If the error cannot be explained with concurrent listeners, the port may be locked by another process. You can determine the ports that are being used with operating system tools such as NETSTAT, and you should ensure that the listener.ora and tnsnames.ora configuration files do not contain any ports that are used by other processes.

Former Member
0 Kudos

Hello,

If this was just Unix, then i would be happy

How do i check for if port is in use on windows? I have not installed a windows SAP system for several years.

Thanks

Former Member
0 Kudos

Go to the run, typ cmd and then netstat /?.

It will tell you what commands you can use with netstat and what each of the commands do.

Netstat command can list currently used ports, Use the -an switch to show all connections and listening ports in numeric form.

C:\> netstat -an

Regards,

Ravi

Former Member
0 Kudos

I have discovered, that as soon as i have installed the new oracle home, then the other oracle homes listener becomes unawailable.

And this is even before the new listener is defined in sapinst. If i uninstall the new oracle, then the other listeners work fine again...

This is so strange.

Former Member
0 Kudos

May be the same port used by second listner. Check out the following note help you.

[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=153835]

Former Member
0 Kudos

Hello,

The problem happens just as the oracle sofware is getting installed for the new oracle home. So this is before the new listener service is even created (happens with SAPINST).

So as soon as i finish installing the Oracle Software, then the other systems stop to worrk.

As soon as i uninstall the new oracle home, the others start to work again.

/Kenneth

Former Member
0 Kudos

Did you try to configure first listner with 1528 (non - default) listner port and then install second one.

Former Member
0 Kudos

I have discovered that if i run sqlplus from ORACLE_HOME/bin, then it works fine, but if i run the one provided with SAP kernel, then i get the TNS error.

Brconnect and brtools also get this error. Is it problems with the 7.1 kernel??

I have tried to patch to the highest kernel level without any luck.

/Kenneth

Former Member
0 Kudos

Hi Kenneth,

Its been a long time since this query is been posted.

I face the same issue, what was the solution you found out.

Mysteriuosly this post is marked as Answered even though it wasnt.

Thanks,

Mohan.

Former Member
0 Kudos

Hi All,

I have found the solution for my issue. Ours was a different case. SAP System was 64 bit and DB was 32 bit. We changed the brtools under sap system (by copying from DB DVD for 32 bit) and it worked fine.

Thank you,

Mohan.

Former Member
0 Kudos

Don't know what is happening with the formatting in OP...

My Oracle problems continue on this NW Mobile 7.1 Windows/Oracle (x64) installation.

I have now reached the SAPINST step Perform Oracle Post Load Activities.

It ends with an error.

<errors above>

If I run R3trans u2013dw as <sid>adm then it return ok (0)

If I run the same command as the SAPINST:

brconnect.exe -u / -c -f crsyn -o SAPSR3

Then I get the same error.

If I connect to the database as:

Sqlplus as / sysdba

The I get connected without any problems, and can start and stop the DB etc.

If the database is shut down and i connect to the database as SAPSR3 or SYSTEM via sqlplus, then I get this error:

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

If I start the database (as /) and connect to the database as SYSTEM or SAPSR3, then I get the error:

ERROR:

ORA-01017: invalid username/password; logon denied

Even though I know I am giving the correct password.

What can this be?

Regards,

Kenneth

Former Member
0 Kudos

Brconnect.log:

BR0801I BRCONNECT 7.10 (3)

BR0280I BRCONNECT time stamp: 2009-07-22 13.42.02

BR0301E SQL error -12560 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-12560: TNS:protocol adapter error

BR0310E Connect to database instance PMD failed

BR0280I BRCONNECT time stamp: 2009-07-22 13.42.02

BR0804I BRCONNECT terminated with errors

Sqlnet.log:

***********************************************************************

Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oraclePMD)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=PMD)(CID=(PROGRAM=H:\usr\sap\PMD\SYS\exe\uc\NTAMD64\brconnect.exe)(HOST=AUDVSAP3)(USER=pmdadm))))

VERSION INFORMATION:

TNS for 64-bit Windows: Version 10.2.0.2.0 - Production

Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 10.2.0.2.0 - Production

Time: 22-JUL-2009 13:42:02

Tracing not turned on.

Tns error struct:

ns main err code: 12560

TNS-12560: TNS:protocol adapter error

ns secondary err code: 0

nt main err code: 530

TNS-00530: Protocol adapter error

nt secondary err code: 193

nt OS err code: 0

***********************************************************************

Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oraclePMD)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=PMD)(CID=(PROGRAM=H:\usr\sap\PMD\SYS\exe\uc\NTAMD64\brconnect.exe)(HOST=AUDVSAP3)(USER=pmdadm))))

VERSION INFORMATION:

TNS for 64-bit Windows: Version 10.2.0.2.0 - Production

Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 10.2.0.2.0 - Production

Time: 22-JUL-2009 13:42:02

Tracing not turned on.

Tns error struct:

ns main err code: 12560

TNS-12560: TNS:protocol adapter error

ns secondary err code: 0

nt main err code: 530

TNS-00530: Protocol adapter error

nt secondary err code: 193

nt OS err code: 0

Former Member
0 Kudos

Did u check the note

Note 441518 - ORA-12560 composite SAP Note

.If the error occurs during a new installation of the database, the scripts for creating the database ("CREATE DATABASE") may not have run correctly.

7. See Note 384839.

8. See Note 304467.

9. See Note 48087.

See sometime rebooting may work. Try to reboot the server and start

Regards,

Ravi

Former Member
0 Kudos

Hi,

Have u tried connecting with SAPSR3/sap?

You can even change your SAPSR3 password via brtools & check..this worked for me once.

Thanks,

Have a nice day,

S

Former Member
0 Kudos

When i run sqlplus / as sysdba from one folder then everything is okay, but when i run in from another folder then i get a strange error.

1. Ok

***********

Microsoft Windows [Version 5.2.3790]

(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\pmdadm>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Jul 23 22:31:33 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL>

***********

2. Error:

***********

H:\usr\sap\PMD\SYS\exe\uc\NTAMD64>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Jul 23 22:33:23 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

ERROR:

ORA-12560: TNS:protocol adapter error

Enter user-name:

***********

Why is that?

Edit: I suspect that is what is happening to the installation tool, since it is the same error it gets..

Edited by: Kenneth Nielsen on Jul 23, 2009 10:38 PM