Home » RDBMS Server » Server Administration » Oracle Reorganisation problem (Oracle 10g, Solaris)
Oracle Reorganisation problem [message #539718] Wed, 18 January 2012 04:41 Go to next message
aoikonom
Messages: 1
Registered: January 2012
Junior Member
I am trying to reoarganise a tablespace with Enterprise Manager from manual to automatic, but script generation gives the following warnng :

Quote:
Reorganization includes a table with a LONG column. To support reorganization of tables with LONG columns that are greater than 32Kbytes the external procedure MGMT$REORG_MOVELONGCOMMAND must be configured properly. It has been determined this external procedure is not currently configured as expected. Configure SQL*Net appropriately to allow it to call the external procedure service process.


I made changes suggested by //docs.oracle.com/cd/E11857_01/em.111/e11982/database_management.htm in the section Using Reorganize Objects with LONG Columns but the warning persists. I noticed however that $ORACLE_HOME/lib/libnmuc.so is an empty file (0 bytes).

Oracle Database 10g 10.1.0.2.0
Solaris (SunOS 5.9 Generic_117171-07 (64-bit))
Oracle home /data/lun1/oracle/product/10.1.0/db_1

{ORACLE_HOME}/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /usr/oracle/product/10.1.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

OASTHDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oasthdb)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = oast)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )



{ORACLE_HOME}/network/admin/listener.ora

# listener.ora Network Configuration File: /usr/oracle/product/10.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /usr/oracle/product/10.1.0/db_1)
      (PROGRAM = extproc)
      (ENVS=
            "EXTPROC_DLLS=ANY,
             LD_LIBRARY_PATH=/usr/lib:/usr/oracle/product/10.1.0/db_1/lib"
      )
    )
    (SID_DESC =
      (ORACLE_HOME = /usr/oracle/product/10.1.0/db_1)
      (SID_NAME = oast)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = oasthdb)(PORT = 1521))
      )
      (ADDRESS_LIST =
	(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

[Updated on: Wed, 18 January 2012 04:44] by Moderator

Report message to a moderator

Re: Oracle Reorganisation problem [message #539723 is a reply to message #539718] Wed, 18 January 2012 04:46 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Best way: convert LONG to CLOB, create a new correct tablespace and move the objects
2/ Next one: create a new correct tablespace and move the objects
3/ ...

Regards
Michel

Previous Topic: Index and Table rebuild method
Next Topic: Un necessary tables present
Goto Forum:
  


Current Time: Thu Mar 28 19:21:52 CDT 2024