Question Re: installation 4.7 in Technology Q&A

installation 4.7

Former Member — Fri, 14 Mar 2008 12:49:35 GMT

Dear Expert,

I am trying to install a SAP 4.7 oracle 9.2 32 bits into a Windows 2003 64 bits machine. I have installed the java 32 bits too and i am using domain administrator to perform the installation.

While installation process, until ORACLE Database build system prompt me this error message

ORA-12546 TNS:Permission Denied.

I have checked the TNSPING sid.world, good ping . And I event restarted the Oracle listener services too.

Oracle environment are properly set too.

Please help urgently.

Thank you

Re: installation 4.7

Former Member — Fri, 14 Mar 2008 13:03:08 GMT

Pls check if these note are useful

Note 583861 - UNIX: Errors due to Oracle executable

Note 396873 - UNIX: Error due to socket authorizations

Note 722966 - Composite SAP Note: ORA-12546

Regards

Shaji

Re: installation 4.7

Former Member — Fri, 14 Mar 2008 13:15:10 GMT

Dear Shaji,

my environment is Windows NT. I have checked the note given problem is not listed in. I have check my setting TNSPING SID working. and TNSPING SID.WORLD working.

Thank you

Re: installation 4.7

Former Member — Fri, 14 Mar 2008 14:20:37 GMT

check file sqlnet.ora and change parameter to:

SQLNET.AUTHENTICATION_SERVICES = (NTS)

Re: installation 4.7

Former Member — Fri, 14 Mar 2008 14:44:42 GMT

Hi,

Checked. The parameter is exist in the sqlnet.ora file.

Re: installation 4.7

Former Member — Fri, 14 Mar 2008 14:47:11 GMT

Can you please paste the error log here.

Also check the permission associated with the listerner services.

ORA-12546: TNS:permission denied

Cause: User has insufficient privileges to perform the requested operation.

Action: Acquire necessary privileges and try again.

Regards

Shaji

Edited by: Shaji Jacob on Mar 14, 2008 2:53 PM

Re: installation 4.7

Former Member — Fri, 14 Mar 2008 15:05:35 GMT

2008-03-14, 19:49:26 SAPINST ORACLE start logging for

connect / as sysdba ;

STARTUP NOMOUNT;

exit;

Output of SQL executing program:

SQL*Plus: Release 9.2.0.2.0 - Production on Fri Mar 14 19:49:26 2008

ERROR:

ORA-12546: TNS:permission denied

SAPINST: End of output of SQL executing program D:\oracle\HCD\ORA92/bin/sqlplus.exe.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2008-03-14, 19:49:27 SAPINST ORACLE stop logging

Here the error message.

Re: installation 4.7

Former Member — Fri, 14 Mar 2008 15:10:03 GMT

TRACE

account Administrator exists with parameter domain="RGMI"

TRACE

account hcdadm exists with parameter domain="RGMI"

TRACE

account hcdadm exists with parameter domain="RGMI"

TRACE

Restoring current processenvironment

INFO 2008-03-14 19:55:05

Changed working directory to C:\SAPinst ORACLE SAPINST.

TRACE

CDomainObjectCache::readFromKeyDb: Reading from tOracleErrorPattern WHERE check = 'true' OR check = 'TRUE' OR check = 'True'

TRACE

CDomainObjectCache::readFromKeyDb: Reading from tOracleErrorIgnorePattern WHERE id = ''

TRACE

CDomainObjectCache::readFromKeyDb: Reading from tSqlScriptTemplates WHERE id = 'wrapper'

TRACE

Executable started and waited successfully. Return code = 0

TRACE

COraSQLScriptExecution<LoggingStrategy>::executeScript: Script executed with error message.

TRACE

CDomainObjectCache::readFromKeyDb: Reading from tSqlScriptTemplates WHERE id = 'wrapper'

ERROR 2008-03-14 19:55:06

CJS-00084 SQL Statement or Script failed. Error Message: ORA-12546: TNS:permission denied

ORA-12546: TNS:permission denied

TRACE

JS Callback has thrown exception

ERROR 2008-03-14 19:55:06

FJS-00012 Error when executing script.

TRACE

got notification...

so more

...

Re: installation 4.7

Former Member — Fri, 14 Mar 2008 15:11:47 GMT

TRACE [iaxohsqlx.hpp:531]

COraSQLScriptExecution<LoggingStrategy>::executeScript()

COraSQLScriptExecution<LoggingStrategy>::executeScript: Arguments: </NOLOG @ora_scr_tmp.sql>

TRACE [synxctask.cpp:64]

CEnvironmentJanitor::CEnvironmentJanitor()

Changing current processenvironment

TRACE [synxcaccnt.cpp:87]

iastring CSyAccountImpl::getDomain() const

account hcdadm exists with parameter domain="RGMI"

TRACE [synxcaccnt.cpp:87]

iastring CSyAccountImpl::getDomain() const

account Administrator exists with parameter domain="RGMI"

TRACE [synxcaccnt.cpp:87]

iastring CSyAccountImpl::getDomain() const

account hcdadm exists with parameter domain="RGMI"

TRACE [synxcaccnt.cpp:87]

iastring CSyAccountImpl::getDomain() const

account Administrator exists with parameter domain="RGMI"

TRACE [synxcaccnt.cpp:87]

iastring CSyAccountImpl::getDomain() const

account hcdadm exists with parameter domain="RGMI"

TRACE [synxcaccnt.cpp:87]

iastring CSyAccountImpl::getDomain() const

account hcdadm exists with parameter domain="RGMI"

TRACE [synxctask.cpp:75]

CEnvironmentJanitor::~CEnvironmentJanitor()

Restoring current processenvironment

INFO 2008-03-14 19:55:05 [syxxccuren.hpp:355]

CSyCurrentProcessEnvironmentImpl::setWorkingDirectory(iastring)

Changed working directory to C:\SAPinst ORACLE SAPINST.

TRACE [iaxxhcache.hpp:534]

CDomainObjectCache::readFromKeyDb(iastring, bool, const iastring &)

CDomainObjectCache::readFromKeyDb: Reading from tOracleErrorPattern WHERE check = 'true' OR check = 'TRUE' OR check = 'True'

TRACE [iaxxhcache.hpp:534]

CDomainObjectCache::readFromKeyDb(iastring, bool, const iastring &)

CDomainObjectCache::readFromKeyDb: Reading from tOracleErrorIgnorePattern WHERE id = ''

TRACE [iaxxhcache.hpp:534]

CDomainObjectCache::readFromKeyDb(iastring, bool, const iastring &)

CDomainObjectCache::readFromKeyDb: Reading from tSqlScriptTemplates WHERE id = 'wrapper'

TRACE [iaxohsqlx.hpp:595]

COraSQLScriptExecution<LoggingStrategy>::executeScript()

Executable started and waited successfully. Return code = 0

TRACE [iaxohsqlx.hpp:610]

COraSQLScriptExecution<LoggingStrategy>::executeScript()

COraSQLScriptExecution<LoggingStrategy>::executeScript: Script executed with error message.

TRACE [iaxxhcache.hpp:534]

CDomainObjectCache::readFromKeyDb(iastring, bool, const iastring &)

CDomainObjectCache::readFromKeyDb: Reading from tSqlScriptTemplates WHERE id = 'wrapper'

ERROR 2008-03-14 19:55:06 [iaxxinscbk.cpp:219]

abortInstallation

CJS-00084 SQL Statement or Script failed. Error Message: ORA-12546: TNS:permission denied

ORA-12546: TNS:permission denied

TRACE [iaxxejsbas.hpp:156]

EJS_Base::dispatchFunctionCall()

JS Callback has thrown exception

ERROR 2008-03-14 19:55:06 [iaxxejsctl.cpp:241]

EJS_ControllerImpl::executeScript()

FJS-00012 Error when executing script.

TRACE [iaxxgenimp.cpp:428]

processUserInput()

got notification...

This is the installation log files.....

Re: installation 4.7

Former Member — Fri, 14 Mar 2008 15:15:08 GMT

2008-03-14, 19:55:06 SAPINST Current process environment:

=C:=C:\SAPinst ORACLE SAPINST

ALLUSERSPROFILE=C:\Documents and Settings\All Users

APPDATA=C:\Documents and Settings\administrator.RGMI\Application Data

ClusterLog=C:\WINDOWS\Cluster\cluster.log

CommonProgramFiles=C:\Program Files (x86)\Common Files

CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files

CommonProgramW6432=C:\Program Files\Common Files

COMPUTERNAME=SAPHCDEV01

ComSpec=C:\WINDOWS\system32\cmd.exe

DBMS_TYPE=ORA

DBS_ORA_SCHEMA=SAPHCD

dbs_ora_tnsname=HCD

FP_NO_HOST_CHECK=NO

HOMEDRIVE=C:

HOMEPATH=\Documents and Settings\administrator.abcd

HP_SSL_SHARE=C:\hp\sslshare\

JAVA_HOME=c:\j2sdk1.4.2_04

LOGONSERVER=
SAPADSPRD06

NLS_LANG=AMERICAN_AMERICA.WE8DEC

NUMBER_OF_PROCESSORS=4

ORACLE_HOME=D:\oracle\HCD\ORA92

ORACLE_SID=HCD

OS=Windows_NT

Path=D:\oracle\HCD\ORA92\bin;$PATH$

PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH

PEGASUS_HOME=C:\Program Files\The Open Group\WMI Mapper\

PEGASUS_PLATFORM=WIN32_IX86_MSVC

PROCESSOR_ARCHITECTURE=x86

PROCESSOR_ARCHITEW6432=x86

PROCESSOR_IDENTIFIER=ia64 Family 32 Model 0 Stepping 7, GenuineIntel

PROCESSOR_LEVEL=32

PROCESSOR_REVISION=0007

ProgramFiles=C:\Program Files (x86)

ProgramFiles(x86)=C:\Program Files (x86)

ProgramW6432=C:\Program Files

SAPDATA_HOME=F:\oracle\HCD

SAPEXE=D:\usr\sap\HCD\SYS\exe\run

SAPLOCALHOST=SAPHCDEV01

SAPSYSTEMNAME=HCD

SESSIONNAME=Console

SystemDrive=C:

SystemRoot=C:\WINDOWS

TEMP=C:\WINDOWS\TEMP

TMP=C:\WINDOWS\TEMP

USERDNSDOMAIN=abcd.IDC

USERDOMAIN=abcd

USERNAME=administrator

USERPROFILE=C:\Documents and Settings\administrator.abcd

windir=C:\WINDOWS

__COMPAT_LAYER=EnableNXShowUI

SAPINST: End of current process environment.

This the environment file captured by sapinst.

Re: installation 4.7

Former Member — Fri, 14 Mar 2008 15:16:43 GMT

Fatal NI connect error 12546, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleHCD)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=HCD)(CID=(PROGRAM=D:\oracle\HCD\ORA92\bin\sqlplus.exe)(HOST=SAPHCDEV01)(USER=hcdadm))))

VERSION INFORMATION:

TNS for 32-bit Windows: Version 9.2.0.2.0 - Production

Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.2.0.2.0 - Production

Time: 14-MAR-2008 19:52:58

Tracing not turned on.

Tns error struct:

nr err code: 0

ns main err code: 12546

TNS-12546: TNS:permission denied

ns secondary err code: 12560

nt main err code: 516

TNS-00516: Permission denied

nt secondary err code: 5

nt OS err code: 0

This is the sqlnet.log file message.

Re: installation 4.7

Former Member — Fri, 14 Mar 2008 15:17:05 GMT

Is it because you are installing 32 bit oracle on 64 bit OS ?

Thanks

Prince Jose

Re: installation 4.7

Former Member — Fri, 14 Mar 2008 15:20:22 GMT

HI,

Can to over come the 64 bits hardware and 32 bits sap problem?

Thank you

Re: installation 4.7

Former Member — Fri, 14 Mar 2008 15:49:36 GMT

why not install 64-bit software as your hardware supports it?

Re: installation 4.7

Former Member — Fri, 14 Mar 2008 15:51:53 GMT

I am thinking about it..

Could you please tell me more or link where i can get the documentation on upgrade from 32 bits to 64 bits.

Thank you

Re: installation 4.7

Former Member — Fri, 14 Mar 2008 17:40:19 GMT

you are installing from scratch? then, go get the 640bit installations package from http://service.sap.com/installations

Re: installation 4.7

Former Member — Sat, 15 Mar 2008 09:56:24 GMT

Dear Expert,

Some one told me that, sap 32 bits is able to run in 64 bits hardware. Wish to know what is the configuration on this.

Please assist.

Re: installation 4.7

Former Member — Sat, 15 Mar 2008 10:14:28 GMT

Yes, you can install 32bit version on 64 bit, but you wont get the full capability of a 64 bit, perfromance wise.

To check whether you OS is 32bit or 64 bit

1. Click Start, click Run, type winmsd.exe, and then click OK.

2. In the details pane, locate Processor under Item. Note the value.

• If the value that corresponds to Processor starts with x86, the computer is running a 32-bit version of the Windows operating system.

• If the value that corresponds to Processor starts with EM64T or ia64, the computer is running a 64-bit version of the Windows operating system.

Shaji

Re: installation 4.7

Former Member — Sat, 15 Mar 2008 11:24:30 GMT

Thanks. Then what is the java version that i need to install 32 bit or 64 bit?

Re: installation 4.7

Former Member — Sat, 15 Mar 2008 11:35:04 GMT

Atleast Java verion 1.4.2_12 is recommended. You can use either of them 32 or 64 bit. Better to go with 64bit.

Note 716604 - Access to Sun J2SE and recommended J2SE options

Shaji