I can login to XDB via a DEV instance on the same server, but cannot login via SCIDEV instance. The differences are DEV is nls_characterset WE8MSWIN1252. SCIDEV is AL32UTF8. DEV has ports 8080 and 2100. SCIDEV has ports 8089 and 2102. http continually prompts for a user / password with no error. FTP shows authentication failed. WebDAV continually prompts for a username and password. I've tried a few things with no luck yet. What should I do to be able to login? This is also posted in Oracle support as technical SR 3-3043961271. Please do not post SR uploaded files in this forum.
Various SQL commands follow. Running on Windows2003 server and Windows XP SP2 client.
SYSTEM@scidev> select * from v$version;
Oracle Database 11g Release 11.2.0.2.0 - Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for 32-bit Windows: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
5 rows selected.
SYSTEM@scidev> select * from nls_session_parameters;
PARAMETER VALUE
---------------------------------------- ---------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
17 rows selected.
SYSTEM@scidev> select * from nls_database_parameters;
PARAMETER VALUE
---------------------------------------- ---------------------------------------
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET AL32UTF8
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_RDBMS_VERSION 11.2.0.2.0
20 rows selected.
SYSTEM@scidev> select * from dba_errors;
no rows selected
SYSTEM@scidev> select count(*) from dba_objects
2 where owner='XDB' and status='INVALID';
COUNT(*)
---------------
0
1 row selected.
SYSTEM@scidev> select comp_name, status, version from dba_registry
2 where comp_name='Oracle XML Database';
COMP_NAME
---------------------------------------------------------------------------------
STATUS VERSION
-------------------------------------------- ------------------------------
Oracle XML Database
VALID 11.2.0.2.0
1 row selected.
SYSTEM@scidev> show parameter dispatchers
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dispatchers string (PROTOCOL=TCP) (SERVICE=scidev
XDB)
max_dispatchers integer NULL
SYSTEM@scidev>
SYSTEM@scidev> select dbms_xdb.gethttpport from dual;
GETHTTPPORT
---------------
8089
1 row selected.
1* SELECT DBMS_XDB.getaclDocument('/home/').getClobVal() FROM DUAL
SYSTEM@scidev> /
<acl description="Public:All privileges to PUBLIC" xmlns="http://xmlns.oracle.com/xdb/acl.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.oracle.com/xdb/acl
.xsd http://xmlns.oracle.com/xdb/acl.xsd" shared="true">
<ace>
<grant>true</grant>
<principal>PUBLIC</principal>
<privilege>
<all/>
</privilege>
</ace>
</acl>
1 row selected.
SYSTEM@scidev>
1* SELECT DBMS_XDB.getaclDocument('/home/pharma').getClobVal() FROM DUAL
SYSTEM@scidev> /
<acl description="Private:All privileges to OWNER only and not accessible to others" xmlns="http://xmlns.oracle.com/xdb/acl.xsd" xmlns:dav="DAV:" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.oracle.com/xdb/acl.xsd http://xmlns.oracle.com/xdb/acl.xsd" shared="true">
<ace>
<grant>true</grant>
<principal>dav:owner</principal>
<privilege>
<all/>
</privilege>
</ace>
</acl>
1 row selected.
Listener status follows
D:\oracle>lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 02-MAR-2011 12:40:57
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Production
Start Date 21-FEB-2011 22:58:56
Uptime 8 days 13 hr. 42 min. 2 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\oracle\path\network\admin\listener.ora
Listener Log File D:\oracle\path\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=8089))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=2102))(Presentation=FTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=8080))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
Service "DEVXDB.aa.ad.epa.gov" has 1 instance(s).
Instance "dev", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "dev" has 1 instance(s).
Instance "dev", status UNKNOWN, has 1 handler(s) for this service...
Service "dev.aa.ad.epa.gov" has 1 instance(s).
Instance "dev", status READY, has 1 handler(s) for this service...
Service "scidev.aa.ad.epa.gov" has 1 instance(s).
Instance "scidev", status READY, has 1 handler(s) for this service...
Service "scidevXDB.aa.ad.epa.gov" has 1 instance(s).
Instance "scidev", status READY, has 1 handler(s) for this service...
The command completed successfully
D:\oracle>
The http and ftp ports for SCIDEV are set in Enterprise Manager to 8089 and 2102.
FTP log follows. First connect to DEV successfully. Then connect to SCIDEV fails.
WINSOCK.DLL: WinSock 2.0
WS_FTP95 LE 4.60 98.03.17, Copyright © 1992-1998 Ipswitch, Inc.
local chdir to c:
- -
connecting to localhost:2100
Connected to localhost port 2100
220- servername
Unauthorised use of this FTP server is prohibited and may be subject to civil and criminal prosecution.
220 servername FTP Server (Oracle XML DB/Oracle Database) ready.
USER xdb
331 pass required for XDB
PASS (hidden)
230 XDB logged in
PWD
257 "/" is current directory.
Host type (I): UNIX (standard)
PORT theIPaddress,15,15
200 PORT Command successful
LIST
150 ASCII Data Connection
Received 250 bytes in 0.1 secs, (20.00 Kbps), transfer succeeded
226 ASCII Transfer Complete
QUIT
221 QUIT Goodbye.
local chdir to c:
- -
connecting to localhost:2102
Connected to localhost port 2102
220- servername
Unauthorised use of this FTP server is prohibited and may be subject to civil and criminal prosecution.
220 servername FTP Server (Oracle XML DB/Oracle Database) ready.
USER xdb
331 pass required for XDB
PASS (hidden)
530 login error
! Logon failure, so quitting
But I can login with the same user in sql plus
SYSTEM@scidev> connect xdb@scidev
Enter password: ***********************
Connected.
XDB@scidev> select user, sysdate from dual;
USER SYSDATE
------------------------------ ---------
XDB 02-MAR-11
1 row selected.
XDB@scidev>