central not connect to oracle when install sap4.7ext110

[Former Member]

hi,i install sap4.7 ext1.1 by

standalone way on two hosts.

during the installation step of the

DB instance ,there is a dialog pop

up ,it says 'start up the central

instance ',then i start the central

instance, the disp+work process was

start for a while then down .i

serached notes,and found 400241,also

i initialized the SISADM in the

sapdba tools ,but it did not work .

thanks

-

---

trc file: "dev_w0", trc level: 1, release: "620"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

M

M Wed Mar 12 08:56:36 2008

M systemid 324 (IBM RS/6000 with AIX)

M relno 6200

M patchlevel 0

M patchno 1773

M intno 20020600

M make: single threaded, ASCII, 64 bit

M pid 450812

M

M ***LOG Q01=> tskh_init, WPStart (Workproc 0 1 450812) [thxxhead.c 1060]

M calling db_connect ...

B create_con (con_name=R/3)

B Loading DB library '/usr/sap/R3P/SYS/exe/run/dboraslib.o' ...

B Library '/usr/sap/R3P/SYS/exe/run/dboraslib.o' loaded

B Version of '/usr/sap/R3P/SYS/exe/run/dboraslib.o' is "620.02", patchlevel (0.1603)

B New connection 0 created

C No ORACLE_HOME in environment ==> evaluating profile parameter DIR_ORAHOME

C Setting ORACLE_HOME to '/oracle/R3P/920_64' (profile parameter DIR_ORAHOME)

C Client NLS settings: AMERICAN_AMERICA.US7ASCII

C Logon as OPS$-user to get SAPR3's password

C Connecting as /@R3P on connection 0 ...

C Attaching to DB Server R3P (con_hdl=0,svchp=112164078,svrhp=112165078)

C Starting user session (con_hdl=0,svchp=112164078,srvhp=112165078,usrhp=11216db08)

C Now I'm connected to ORACLE

C *** ERROR => ORA-1403 when accessing table SAPUSER

[dbsloci.c 10065]

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=112164078,usrhp=11216db08)

C Now I'm disconnected from ORACLE

C Try to connect with default password

C Connecting as SAPR3/<pwd>@R3P on connection 0 ...

C Starting user session (con_hdl=0,svchp=112164078,srvhp=112165078,usrhp=11216db08)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

[dboci.c 3878]

C *** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c 9718]

B ***LOG BY2=> sql error 1017 performing CON [dbsh#2 @ 962] [dbsh 0962 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#2 @ 962] [dbsh 0962 ]

B ***LOG BY2=> sql error 1017 performing CON [dblink#1 @ 419] [dblink 0419 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#1 @ 419] [dblink 0419 ]

M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1197]

M in_ThErrHandle: 1

M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 8847]

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M rq_info = 0

M act_reqtype = -1

M tid = -1

M mode = 255

M len = -1

M rq_id = -1

M rq_source = 255

M last_tid = 0

M last_mode = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 672]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 241]

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 450812) [dpuxtool.c 316]

[Former Member]

Have you copied the db? Then you require to set the ora_dbs_schema to the original db from the dos prompt.

C:> set

check for the ora_dbs_schema parameter. If it is the old one then okay otherwise you need to change it.

[Former Member]

Hi,

Please specify whether you have installed CI and DB on two different machines (hosts).

Have you given proper entries when asked about Database Server during your CI installation ? Check the SAPDBHOST parameter in the DEFAULT.PFL

If yes then have you installed oracle client on CI ? You will have to install it.

Please check and reply.

Regards,

Suhas

[former_member204746]

try these SQL command:

insert into "OPS$SAP\[SID]ADM".SAPUSER values ('SAP[SID]','your_password');

grant select, update on "OPS$SAP\[SID]ADM".SAPUSER to "OPS$SAP\SAPSERVICE[SID]";