Skip to Content
avatar image
Former Member

SAPDBA

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 26, 2007 at 05:09 AM

    hi,

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

    regards

    ajai

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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