db_name chnage

[Former Member]

Dear all

i have change the db_name

then i have found follwing error 0ra-01103 database name prd in control file is not bar

i can oprn the database please guide

thanks

with best regards

venkat

[Former Member]

Dear all

i have change the db_name prd to bar

when i sap up following error find out.

<ES> client 0 initializing ....

X Using implementation flat

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M

M Tue Mar 04 18:18:33 2008

M calling db_connect ...

C Got ORACLE_HOME=c:\oracle\ora92 from environment

C Client NLS settings: AMERICAN_AMERICA.UTF8

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

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

C Attaching to DB Server BAR (con_hdl=0,svchp=07EC345C,svrhp=04C2A514)

C Starting user session (con_hdl=0,svchp=07EC345C,srvhp=04C2A514,usrhp=07EC8F04)

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

[dboci.c 3720]

C Detaching from DB Server (con_hdl=0,svchp=07EC345C,srvhp=04C2A514)

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

[dbsloci.c 9750]

C Try to connect with default password

C Connecting as SAPBAR/<pwd>@BAR on connection 0 ...

C Attaching to DB Server BAR (con_hdl=0,svchp=07EC345C,svrhp=04C2A514)

C Starting user session (con_hdl=0,svchp=07EC345C,srvhp=04C2A514,usrhp=07EC8F04)

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

[dboci.c 3720]

C Detaching from DB Server (con_hdl=0,svchp=07EC345C,srvhp=04C2A514)

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

[dbsloci.c 9750]

B ***LOG BV3=> severe db error 1033 ; work process is stopped [dbsh#2 @ 1195] [dbsh 1195 ]

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

B ***LOG BY0=> ORA-01033: ORACLE initialization or shutdown in progress [dblink#1 @ 419] [dblink 0419 ]

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

M in_ThErrHandle: 1

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

M

M Info for wp 0

but when i am going to through brtools

change of the sapbar passord sap,

but he select automaticaly sapprd please guide how can reset the sapbar password through brtools.

thanks

regards

venkat

[Former Member]

Hi Venkat,

Where did you change the DB_NAME, in the spfile/pfile of the database?

Why did you rename the database?

Did you already try to rename it back the way you renamed it the first time? Does it work again then?

Kind regards,

Beate