unable to access sapdba

[Former Member]

Hi to all,

I have installed SAP 4.7EE successfully on windows 2k3. with Oracle 9i as database. but the problem is am unable to access SAPDBA thru cmd.exe. can any one help me in this regard.

With regards,

ramkrishna

[Former Member]

Hi Rama krishna,

Have you set the ORACLE_HOME path ?.Try through the <sid>adm user their will be no ora<sid> user in the windows platform.

Regards,

Rakesh.R

[Former Member]

Hi

You need to ADD the oracle binary path /oracle/<SID>/920_64/bin in environment variables-PATH.

PATH includes the list of all binary directories

Regards

Madhu

[Former Member]

where are on Windows.

%ORACLE_HOME%\bin is always part of the environment variable path.

[Former Member]

Hi,

I think it is a bit pointless to continue "shooting" suggestions until "ramkrishna" clarify exactly what is the issue, what he means with

<quote>

but the problem is am unable to access SAPDBA thru cmd.exe.

<quote>

[Former Member]

I think it was mentioned before, but if you need some help you have to provide some information, please

<quote>

the problem is am unable to access SAPDBA thru cmd.exe.

<quote>

what do you mean with this statement?

Are you getting this error?:

<i>'SAPDBA' is not recognized as an internal or external command,

operable program or batch file.</i>

or are you getting other error? If so, please, indicate wich one?

I assume it is the first one, in that case, please, check if the program SAPDBA.EXE is located on your kernel directory.

SAPDBA is very old/outdated and not delivered any more. It has been 100% replaced by the BR* tools and you should not use it anymore.

[Former Member]

Hi Rama,

Please check the environment variables,there kernel directory path is there are not,if not please set that path.this is also one of the reason.

regards,

Pulla rao.

[former_member185954]

Rama,

Can you post the error u get when you try starting sapdba ?

Regards,

Siddhesh

[former_member185954]

Hi,

Which user are u trying to start the sapdba with ?

Use the ora<sid> user.

Use the following link to find more information on starting sapdba.

Regards,

Siddhesh

[Former Member]

there is no ora<sid> user on Windows!

but he should use <sid>adm.

are you providing username password of a dbuser when you invoke sapdba?

As far as i know sapdba is only working without password if system has the standard password manager which should be changed...

otherwise you have to specify user/name password of a db user which has dba rights in the database.

peter

[former_member185954]

ah...

haven't seen sap on windows for couple of years now.. am bit rusty

you are right there is no ora<sid> on window indeed !

[Former Member]

Hi,

when you are accessing SAPDBA in cmd.exe you need to provide full path of RUN directory and execute sapdaba command.

i hope it will help you.

kiran kumar.v

[Former Member]

hi kiran kumar,

thanx for the reply. but i saw my friend using sapdba in run directory with any path. he successfully using it. but in my system am unable to use it. can u pls tell me from where i can find the path. ur help would be appreciated.

with regards,

ramkrishna