Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Listener Supports no services

843238Feb 17 2012 — edited Feb 17 2012
Hi DB Experts,

I am new to the Oracle DB and specifically 11g.

I have a VM Ware machine, which had Oracle DB installed.
When I am trying to start the DB server, I get the below logs:


LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-FEB-2012 01:36:53

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Starting /u01/app/oracle/product/11.2.0/dbhome_1//bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Log messages written to /u01/app/oracle/product/11.2.0/dbhome_1/log/diag/tnslsnr/fmw/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fmw)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 17-FEB-2012 01:36:54
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /u01/app/oracle/product/11.2.0/dbhome_1/log/diag/tnslsnr/fmw/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fmw)(PORT=1521)))
The listener supports no services
The command completed successfully

SQL*Plus: Release 11.2.0.1.0 Production on Fri Feb 17 01:36:56 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance started.

Total System Global Area 534462464 bytes
Fixed Size 2215064 bytes
Variable Size 394265448 bytes
Database Buffers 130023424 bytes
Redo Buffers 7958528 bytes
Database mounted.
Database opened.


Why is that message flashed - Listener supports no services and Connected to an idle instance
Is my listener no registered with the ORACLE instance of the database?

Please help
This post has been answered by Billy Verreynne on Feb 17 2012
Jump to Answer

Comments

94799
The collection is declared in the OWA package header in the SYS schema.
CREATE OR REPLACE PACKAGE owa
IS

(...)

   TYPE vc_arr IS TABLE OF VARCHAR2 (32000)
      INDEX BY BINARY_INTEGER;
      
(...)
      
END;
/
Population of collections is relatively straightforward but it does vary by type (nested table / varray / index-by). Suggest a read of:

http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28843/tdddg_procedures.htm#TDDDG49000
652458
Thanks but that doesn't really tell me what type of array I should be looking at. I don't intend to populate the arrays from table values but from fixed values and session data.
94799
Hint...
TYPE vc_arr IS TABLE OF VARCHAR2 (32000)
     *INDEX BY BINARY_INTEGER*;
Edited by: padders on Nov 10, 2008 7:22 AM
Satyaki_De
Hint...
TYPE vc_arr IS TABLE OF VARCHAR2 (32000)
*INDEX BY BINARY_INTEGER*;
Why BINARY_INTEGER ?

Why Not PLS_INTEGER?

Regards.

Satyaki De.
94799
Don't have a go at me, I didn't write the OWA package ;-)

Prior to associative arrays you had to use BINARY_INTEGER anyway, although I recall that Steven Feuerstein telling me that it internally used PLS_INTEGER anyway.
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production

SQL> DECLARE
  2     TYPE type_name IS TABLE OF NUMBER
  3         INDEX BY PLS_INTEGER;
  4  BEGIN
  5     NULL;
  6  END;
  7  /
   TYPE type_name IS TABLE OF NUMBER
                     *
ERROR at line 2:
ORA-06550: line 2, column 22:
PLS-00315: PL/SQL TABLE declarations must currently use binary_integer indexes
ORA-06550: line 2, column 4:
PL/SQL: Item ignored

SQL>
652458
Well I've worked out a way for the apex compiler not to complain any more so we'll see if the data actually gets passed as it should with the following code:
declare
name_array owa.vc_arr;
value_array owa.vc_arr;

begin

name_array(1) := ('AuthenticationProtocol');
name_array(2) := ('CardBrand');

value_array(1) := ('0');
value_array(2) := ('visa');

xml_api.postData(name_array, value_array);
end;
It's a bit clumsy but at least it seems to work for now
William Robertson
name_array(1) := ('AuthenticationProtocol');
You don't need brackets to assign individual values to variables, it's just 
var := value;
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 16 2012
Added on Feb 17 2012
#general-database-discussions
12 comments
79,547 views