DBACOCKPIT

[Former Member]

when i try to run the script CREATE.SQL from note:706927. It prompt for a password of SAP SCHEMA, anyone knows the correct entry? SAPDAT (version 6.4)? what will be the default password?

[Former Member]

you should have an SAP DB User like SAPR3 or SAP<SID> or something else.

<b><i>select username from dba_users</i></b>

Did you try to log on the database with the SAP DB User?

<b><i>sqlplus /nolog</i></b>

SQL> <b>connect sap<SID>/PW</b>

if not, you can change the password for this user like that and try again.

brconnect -u system/pw -f chpass -o <SAP DB User> -p pw

and then execute the create.sql and you can give the right password for the SAP DB User.

[Former Member]

thanks for the reply.

I run the scripts as the ORASID user. it has sysdba privilege.

i guess the default passwword for SAPr3 or SAPDAT is 'SAP' but i am not sure which user is exactly i should enter.

have anyone run this before? please let me know which user you have enter as the 'SAP Schema'....

[Former Member]

which user do you have?SAPR3 or SAPDAT? You can find it like that:

<b><i>select username from dba_users</i></b>;

Could you connect to the database with SAP DB User?

If you don't know the password, you can change it with BR*Tools.

I run the script create.sql many times.

Best regards

[Former Member]

ok thanks.

[Former Member]

You can change the password for the SAP DB User like that:

<i><b>brconnect -u system/pw -f chpass -o <SAP DB User> -p pw</b></i>

see please following thread about the DBA Cockpit

best regards

Baran

[Former Member]

Hi,

Pl hv a look at SAPNote 711477 - DB6: Missing authorization in DBA Cockpit during maintenance

Regards

[Former Member]

this note is for remote connection, but i am running for local system.

[Former Member]

Hi Check the following lines

create.sql:

This is the "main script", which calls the two other scripts and executes them one after another. <b>Since the script connects to the database as SYSDBA, it must be called by an OS user that possesses the necessary authorization.</b>

Call: oraadm> sqlplus "/ as sysdba" @create.sql

Have you checked this? Imean the os user with which you hv logged in as and if the concerned user has SYSDBA authorization.