Question:
Installation problem IDES 4.6B
Installation order
1) installation of Windows 2000 on a PC Harddisk 120 GB, 512 ram)
Question: - it is IDES 4.6B in the installation guide they say it runs on Windows NT does it run on
Windows 2000 to?
- Do i need to install service packs on windows 2000?
2) installation oracle 8.0.5
patch 8.0.5.2.2
my listener in the services is running, so i think everythin is OK.
Do i need to create a database or will SAP do that?
Then i am installing SAP IDES 4.6B (as in the installation guide)
3) I am running from the kernel cd :\NT\COMMON\R3setup.bat: That run's just fine
4) Install the central instance using the standard template CENTRAL.R3S
That runs also ok
5) I copy the install script DB_IDES.R3S to DATABASE.R3S
6) I run the installation script and it does create an error on DATABASEINSTANCE_NT_IND
SAPLOC=\\@CIHOSTNAME@\SAPMNT (RI_GIKY_NA_COM_SAPLOC, entry { { label RI_GIKY_NA_COM_SAPMNT_LABEL } { regexp ^[A-Z][:]?$ } } )
SAPMNT=\\@CIHOSTNAME@\SAPMNT
It can't find those directories. I looked in the help and change them
to <DRIVE>:\USR\SAP => that works but is it right?
7) I run the installation script and it doesn't create an error anymore. But it would't go
any further than around the 50 %
The item it is than running is (see last item database.log)
INFO 2003-08-17 18:28:07 DBRESETDATABASE_NT_ORA SyCoprocessCreate:928
Creating coprocess F:\orant\bin\svrmgr30.exe ...
I waited for around 15 hours but nothing is changing
In the install directory i see it has created an .sql file (orascr.sql), the first
command in that script is "CONNECT INTERNAL". If i try to run that script manually
the first thing it asks is for a password. Could it be that it is waiting for an input password in the
installation script? How can i put that in the script? Could somobody send me an installation script of IDES 4.6B
that works well...
Where can i see if it is doing something?
Can you help me?
Thank you
Chris Vandewiele
Answer:
there was a similar problem some days before in the forum. Look for it something with password.
Answer:
Thank you
but could that be the problem why it is hanging on that part?
Could you send installation scripts that work for IDES 4.6b
Thank you
Chris Vandewiele
Answer:
In the meantime i have found someone with the same problem, here it is:
"Please tell me if u have problem with 'Connect Internal' I mean if ur
system hangs in DBRESTDATABASE_NT_ORA..to solve this there is
oneOSS note .I dont know the exact no..but search
Connect intenal on win2k.
meawhile i will look for the note and post it.(This is OS problem)
Tks
Jones
Please take a look at OSS Note No:417561,hopefully this will solve ur
problem"
So could somebody send me the Note No:417561, this would be off great help
Thank you
wheelsoftware2000@hotmail.com
Answer:
hi,
For "Connect internal" to be successful
1. Your login should be <sid>adm
2. <sid>adm should belong to the proper groups.DBA, OPER
3. Environment variables should be properly set..Oracle_sid, Oracle_home
4. Listener and Oracle Service should be started by System Account.
rgds
Nainesh
Answer:
how do i create//change these environment variables. Are these
like normal windows variables?
Will "connect internal" not be asking for a password anymore?
I don't understand i tought sap r3s had to create a line like this
connect internal\ORACLE => so he is sure of the password?
Or am i wrong?
wheelsoftware2000@hotmail.com
Answer:
hi,
Please recheck your os level groups..and if they <sid>adm is properly assigned to them...
Set the variable manually at dos level and then
use svrmgrl at the os level and try to connect as internal...
What error code it gives..
You have to set the environment variables like normal windows variables...
Check if you have sqlnet.ora in /oracle_home/network/admin -directory
If still u face the problem..then post the ORA error
rgds
Nainesh
Answer:
Hi nainesh,
I am also facing the same problem.I am in mumbai.Can u plese give me ur contact no or mail id to contact u.
vidya.
My id is "vidyadhar.reddy@seepz.tcs.co.in"
vidya
Answer:
Hi nainesh,
I looked for all the thinks you asked for yesterday. Everything seems allright.
But it wouldn 't work either. therefore I took a print of all the important files
1) Listener.ora
################
# Filename......: listener.ora
# Created.......: created by SAP AG, R/3 Rel. >= 4.0A
# Name..........:
# Date..........:
################
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL=IPC)
(KEY= C11.WORLD)
)
(ADDRESS=
(PROTOCOL=IPC)
(KEY= C11)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = pc-wheel)
(PORT = 1527)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SDU = 32768)
(SID_NAME = C11)
(ORACLE_HOME = F:\orant)
)
)
2) TNSNAMES.ORA
# TNSNAMES.ORA Configuration for SERVER
# Generated by Oracle Net8 Assistant
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = PC-WHEEL)
(PORT = 1521)
)
(CONNECT_DATA = (SID = ORCL)
)
)
oratcp.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = PC-WHEEL)
(PORT = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
oralocal.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = NMP)
(Server = PC-WHEEL)
(Pipe = ORAPIPE)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
C11.WORLD=
(DESCRIPTION =
(SDU = 32768)
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = pc-wheel)
(PORT = 1527)
)
)
(CONNECT_DATA =
(SID = C11)
(GLOBAL_NAME = C11.WORLD)
)
)
3) SQLNET.ORA
TRACE_LEVEL_CLIENT = OFF
#sqlnet.authentication_services = (NONE)
names.directory_path = (TNSNAMES, HOSTNAME)
NAMES.DEFAULT_DOMAIN = WORLD
NAME.DEFAULT_ZONE = WORLD
AUTOMATIC_IPC = ON
SQLNET.AUTHENTICATION_SERVICES = (NTS)
SQLNET.EXPIRE_TIME = 0
4) Protocol.ora
tcp.nodelay = true
5) Environment variables when logged in as c11adm
DBMS_TYPE = ORA
dbms_ora_tnsname= C11
NLS_LANG = AMERICAN_AMERICA.WE8DEC
ORACLE_HOME = F:\orant
ORACLE_SID = C11
PATH = ;F:\usr\sap\C11\sys\exe\run;F:\orant\bin
SAPARCH = F:\oracle\C11\saparch
SAPBACKUP = F:\oracle\C11\sapbackup
SAPCHECK = F:\oracle\C11\sapcheck
SAPDATA_HOME = F:\oracle\C11
SAPDATA1 = F:\oracle\C11\sapdata1
SAPDATA2 = F:\oracle\C11\sapdata2
SAPDATA3 = F:\oracle\C11\sapdata3
SAPDATA4 = F:\oracle\C11\sapdata4
SAPDATA5 = F:\oracle\C11\sapdata5
SAPDATA6 = F:\oracle\C11\sapdata6
SAPLOCALHOST = pc-wheel
SAPREORG = F:\oracle\C11\sapreorg
SAPTRACE = F:\oracle\C11\saptrace
TEMP = %USERPROFILE%\Local Settings\Temp
TMP = %USERPROFILE%\Local Settings\Temp
6) c11adm belongs to the groups.DBA, OPER has even administrator rights!!
7) services listener, serviceC11 is running but
when i tried manually
with NET 8easy config
Connecting....
The test did not succeed.
ORA-01034: ORACLE not available
There may be an error in the fields entered
or the server may not be ready for a connection.
You can check the server and retry, or continue.
SVRMGR30 (=> ORACLE
CONNECT INTERNAL it is the same!!!
Test with Database.R3s hangs on DBRESETDATABASE_NT_ORA
This is the last part of the logfile...
INFO 2003-08-25 20:13:18
Restarting the ORACLE Listener
INFO 2003-08-25 20:13:18
Getting Minimal Size of the Database
INFO 2003-08-25 20:13:18 DBRESETDATABASE_NT_ORA OracleOpsCheck:0
KEY: OPS VALUE: NO is set.
INFO 2003-08-25 20:13:18 DBRESETDATABASE_NT_ORA OracleRawCheck:0
KEY: RAWDEVICE VALUE: NO is set.
INFO 2003-08-25 20:13:18
Resetting the Database
INFO 2003-08-25 20:13:18 DBRESETDATABASE_NT_ORA InternalInstallationDo:0
Shutdown Database abort.
INFO 2003-08-25 20:13:18 DBRESETDATABASE_NT_ORA OracleCmd:0
Shutdown Database abort.
INFO 2003-08-25 20:13:18 DBRESETDATABASE_NT_ORA SyPermissionSet:2186
Changing permission for file orascr.sql from 777 to 666.
INFO 2003-08-25 20:13:18 DBRESETDATABASE_NT_ORA SyCoprocessCreate:928
Creating coprocess F:\orant\bin\svrmgr30.exe ...
Hopefully i have given you all the things you need to find an answer on this one???
Otherwise, could you send the right files listener.ora, tnsNames.ora, protocol.ora,
sqlNet.ora or other file to my emailadress wheelsoftware2000@hotmail.com
Thank you
Chris Vandewiele
Answer:
wheelsoftware2000,
One of the fun things about Oracle errors is that you could have fixed the problem already but one old thread out there could make it appear to still be broken.
Shut down all your Oracle related services: TNSListener, Agent, <SID>_00, etc. Then reboot your box.
Now, log on as the <sid>adm and start the TNSListener service. Go to a DOS command box and type the following:
svrmgrl
connect internal
If you have no errors, you are probably now OK. If you see TNS adapter errors, etc. there are a ton of OSS notes out there on what you should look for.
Now (you should still be in svrmgrl) type:
startup mount;
alter database open;
Your database is up and ready to go. Log off and back on your installation ID.
BTW, if any installation is being done via terminal server or any other remote emulation software, you need to add the LOCAL=<SID> environmental variable to your installation and <sid>adm users.