SAPDBA

[Former Member]

Hi,

I want to increase my table space.i logged in sidadm but sapdba is not working.When i check listner controller i am getting this is error.

Please any one provide solution for this.

LSNRCTL> status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sapsrv)(PORT=1521)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

32-bit Windows Error: 61: Unknown error

LSNRCTL>

Regards,

M.Devender

[Former Member]

hi,

what is the OS and what is the version of SAP?

regards

ajai

[Former Member]

Hi,

OS is Windows2003

Version is:4.7

Regards,

M.Devender

[Former Member]

Try to start the Listner

lsnrctl start

Regards

Subhash

[Former Member]

hi,

check the listner service is runninmg.stsrt it manullay.put the service in automatic mode.

then run the SAPDBA.it is not running go to command prompt....go to this folder ...<install drive>:\usr/sap/<sid>/sys/exe/run ......then u type teh SAPDBA

regards

ajai

[Former Member]

which user account of Windows 2003 you have logged on ??

Please Logon on SIDADM user then try !

Are you getting any message while typing SAPDBA command??

Regards

Prabhakar P

[Former Member]

Hi Devender,

If you wish you can change it through Database level as well. Logon to database and use the following command,

Alter tablespace <TableSpaceName> add datafile '<path with datafile location>' size autoextend <On or Off>;

Hope this will help you.

Cheers

Deepanshu

[Former Member]

Hi,

As per your mail i tried i am getting below error.

C:\usr\sap\DEV\SYS\exe\run>sapdba

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

ORA-12560: TNS:protocol adapter error

ORA-12560: TNS:protocol adapter error

Server Manager complete.

SAPDBA: Couldn't check SYSDBA privilege.

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

ORA-12560: TNS:protocol adapter error

ORA-12560: TNS:protocol adapter error

Server Manager complete.

SAPDBA: Couldn't check SYSOPER privilege.

Press <return> to continue ...

Regards,

Deve

[Former Member]

Try with brtools...

[Former Member]

Hi Deve,

Regarding that I could say please confirm you have latest version of TP, R3trans.

Cheers

Deepanshu

[Former Member]

Hi,

How i know the version of tp and r3trans.Please,provide some information and i can give answer.

Regards,

Deve

[Former Member]

It is very easy to obtain the patch level of some core R/3 executables such as: disp+work, tp and r3trans. Many people would like to know how to do this. Here, I will show you how to do it for R/3 systems running on Windows and SQL Server environments.

1. Go to the command prompt.

2. Change to the "run" directory of your SAP instance (cd \usr\sap\<SID>\sys\exe\run).

3. Run the following three commands:

dsp+work -V | find "patch number"

tp -V | find "patch number"

r3trans -V | find "patch number"

If you want to see all the release information, then do not filter for the patch number.

Prabhu

[Former Member]

Hi,

Thank u for send the mail.

C:\Documents and Settings\devadm>disp+work

-

---

disp+work information

-

---

kernel release 620

compiled on NT 5.0 2195 Service Pack 2 x86 MS VC++ 12.00

compile time Aug 5 2002 21:33:12

update level 0

patch number 251

source id 0.252

-

---

supported environment

-

---

database (SAP, table SVERS) 610

620

operating system

Windows NT 5.0

Windows NT 5.1

Windows NT 5.2

-

---

C:\usr\sap\DEV\SYS\exe\run>tp -V | find "patch number"

patch number 230

-

---

C:\usr\sap\DEV\SYS\exe\run>r3trans -V | find "patch number"

patch number 252

Regards,

Deve

[Former Member]

Hi

Only Thanks is not enough...if it is helpful then give points ok.

--Prabhu

[Former Member]

Hi,

I want to incrase table space i am getting TNS listner error.

Still,my problem is not solved.

Regards,

Deve

[fidel_vales]

Ok,

First thing to do is to use a proper and supported tool.

Do not use SAPDBA, it is not maintained for a long time. Download and use BR* tools.

Second, you are getting a "weird" error:

32-bit Windows Error: 61: Unknown error

You mentioned that you logged as the "correct" user, have you checked if the environment variables are correct?

Third, you already got a proper workaround. You can manage the tablespace extension without any other tool than the one Oracle provides: SQLPLUS. Perhaps you should learn a little about oracle before you start administering one:

http://download.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_33a.htm#2093898