Home » RDBMS Server » Server Administration » oracle-lite
oracle-lite [message #61937] Fri, 11 June 2004 02:00 Go to next message
Paxley Kekana
Messages: 6
Registered: March 2003
Junior Member
I installed oracle -lite on my PC but I get this error: How do go past this?

C:Documents and Settingskekana>
C:Documents and Settingskekana>sqlplus system/manager@odbc:polite:polite

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Jun 11 11:55:57 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:
ORA-03121: no interface driver connected - function not performed

Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error

Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

C:Documents and Settingskekana>
C:Documents and Settingskekana>
Re: oracle-lite [message #61941 is a reply to message #61937] Fri, 11 June 2004 03:38 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

For Oracle9i Lite, try:

C:>msql system/manager@jdbc:polite:polite

Oracle MSQL Version 1.0.0.0.2
(c) Copyright 2001 Oracle Corporation. All rights reserved

Connected to: Oracle9i Lite ORDBMS
Database Name: POLITE (Read Write)
Database Version: 4.0.3.0.0
Auto Commit: off
Driver Name: oracle.lite.poljdbc.POLJDBCDriver (OLite 4.0)

SQL>


Mobile SQL, or msql, is a sqlplus-like interface one can use to login and manage an Oracle Lite database.

Best regards.

Frank
Re: oracle-lite [message #61942 is a reply to message #61941] Fri, 11 June 2004 04:19 Go to previous messageGo to next message
Paxley Kekana
Messages: 6
Registered: March 2003
Junior Member
Thnx Frank,

Do I really have to install Mobilesql? Do you know where I can get a copy of jdk 1.3 for free?

Rgds,
Re: oracle-lite [message #61976 is a reply to message #61942] Tue, 15 June 2004 05:37 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

Mobile SQL is installed with a "Mobile Development Kit" type installation. You don't have to use it, although it makes certain tasks much easier.

To develop Java applications, you need SUN Microsystems' Java Development Kit (JDK) version 1.3.1 or higher. You can download it from http://java.sun.com/

Best regards.

Frank
Previous Topic: killing sessions dynamically
Next Topic: ora-08103 objects no longer exists
Goto Forum:
  


Current Time: Fri Sep 27 10:32:58 CDT 2024