on 07-22-2009 1:02 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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>
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
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.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.