Express Edition (XE) :: Getting SP2-0640 / Not Connected Error?
Jul 23, 2012I first started database, then gone to option Run SQL command line. After that while creating table it is showing error like "SP2-0640: Not connected."
View 2 Replies
ADVERTISEMENT
SP2-0640 Not Connected
Oct 4, 2007I am using Oracle 10g on Fedora Linux and trying to learn a bit of pl/sql. Here is the piece of code that I today tried to run in the SQL Plus window but it back with an error message saying SP2-0640 Not connected.
set serveroutput on
declare x number;
begin x :=7777;
dbms_output.put_line('x= ');
dbms_output.put_line(x);
end;
Client Tools :: SP2-0640 - Not Connected?
Jun 30, 2006My Oracle DB is working properly till yesterday. When i tried connecting to it today using scott/tiger@orcl its not accepting.So i entered as system/system..it connected
when i tried to select instance_name from v$instance; it is giving me error
SP2-0640: Not connected
Upgrade :: From 10.2.0.4.0 To 11.2.0.2.0 Using DBUA (SP2-0640 Error)
Feb 12, 2013We are trying to upgrade oracle database from 10.2.0.4 to 11.2 using DBUA, but when we try to launch the DB upgrade assistant uisng dbua.sap.sh script, we are getting the below error
for input string SP2-0640 not connected.
Find below last few lines from the logs from location /oracle/cfgtoollogs/dbua/logs/trace.log
[Thread-13] [ 2013-02-12 14:34:00.002 CET ] [Database.updateNonDefaultInitParams:1199] mts value altered based on db version:null
[Thread-13] [ 2013-02-12 14:34:00.005 CET ] [CompManager.obtainGenericDbInfo:2436] get number of data files backing up
[Thread-13] [ 2013-02-12 14:34:00.024 CET ] [CompManager.obtainGenericDbInfo:2470] Source Database Version :=10.2.0.4.0
[Thread-13] [ 2013-02-12 14:34:00.024 CET ] [CompManager.obtainGenericDbInfo:2479] Source Database Version :=10.2.0.4.0
[Thread-13] [ 2013-02-12 14:34:00.027 CET ] [CompManager.obtainGenericDbInfo:2605] backupNo =0 ...
Processes / Sessions Connected To DB After ORA 20 Error?
Dec 28, 2010Is there any way to tell what processes/sessions were connected to a DB after I get an ORA 20error. As you can see from the query results below, I did hit the max value of processes but I would like to know when it happen and who was connected.
I realize I can up the value, but before I do that I want to see what caused this to happen.
SQL> select * from v$resource_limit where resource_name in ('sessions', 'processes');
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL
LIMIT_VALU
----------
processes 221 1000 1000
1000
sessions 223 1020 1105
1105
Express Edition (XE) :: Oracle Express E 10g Or 11g RPM Package For Linux 32x
Oct 18, 2012I would like to install Oracle Express Edition on Linux. I have some troubles on x64 architecture of Linux with win32 progs that runs via wine. And I need Oracle for developing. So, I would like install x32 Oracle Express Edition, but I can't find it anywhere. Is it exists.
Why is Oracle Express Edition 32x exist for windows, but there is not Oracle Express Edition 32x for Linux? We are using widely Oracle 10g. And there is many special difference with 11g. But there is no anywhere 10g version. Where can I download it (for Linux)?
Error During Installation Of 10g Personal Edition?
Sep 15, 2010I am trying to install Oracle 10g on my personal laptop. I have a Windows 7 system, with MS Virtual PC and XP mode. When trying to install 10g Personal Edition, I encounter the following error:
java.util.zip.ZipException: invalid stored block lengths
at java.util.zip.InflaterInputStream.read(Unknown Source)
at java.util.zip.ZipInputStream.read(Unknown Source)
at java.io.FilterInputStream.read(Unknown Source)
at oracle.sysman.oii.oiix.OiixFileOps.copyStream(OiixFileOps.java:1421)
[code]...
A Sample Database For Ora 10g Express Edition
Nov 2, 2008Just installed Ora 10g Express Edition. It has a sample database. But is there a rather larger database outside that I can download and import into Oracle for some learning reasons?
View 1 Replies View RelatedExpress Edition (XE) :: Uninstalling Oracle XE?
Dec 10, 2012I tried to uninstall Oracle XE 11g and i got 1402 error from Windows Error: [URL]...
what is happening. I can not uninstall or repair either.
Server Administration :: Convert Enterprise Edition DB To Standard Edition?
Nov 4, 2011The only supported technique for converting an EE database to SE is export-inport, as documented in note 139642.1. Our client is reluctant to do this because of the downtime involved. It is however possible to open the EE database from an SE home, no problem.
The note says only Quote:When you just install the Standard Edition software, you will end up with Data Dictionary objects which are of no use (or perhaps even invalid) and possibly create problems when maintaining the database.
SQL & PL/SQL :: Horizontal Fragmentation In Oracle 10g Express Edition?
Feb 28, 2012I want to do horizontal fragmentation of a table say employee. But fragmentation is often related to distributed databases. So i want to ask how can i do this on my single home computer? list out the steps that should be performed. I saw the concept of link but really failed to understand that.
View 14 Replies View RelatedForms :: Oracle 10g Express Edition Can Support 6i
Mar 2, 2007I have downloaded oracle 10g express edition. I have tried to connect forms 6i in that in windows xp environment but when i tried to connect it is not connecting and giving "don't send" error.
If there is any patch to connect forms 6i into oracle 10g express edition.
Express Edition (XE) :: Oracle 11g R2 Doesn't Start?
Sep 3, 2013I am running Ubuntu 13.04. I am attempting to install Oracle XE 11g R2. It seems that everything was fine until I got to configuration of the database as root I ran /etc/init.d/oracle-xe configure command. I have received the following output
Starting Oracle Net Listener...Done
Configuring database...
Database Configuration failed. Look into /u01/app/oracle/product/11.2.0/xe/config/log for details
When I look at the logs I get the following error ORA-01034: ORACLE not available. After receiving this error I have attempted to start Oracle manually.
sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.2.0 Production on Tue Sep 3 11:34:07 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
As you can see I got
ORA-00845: MEMORY_TARGET not supported on this system error. Ok let's see what's going on with my partitions
/u01/app/oracle/product/11.2.0/xe/config/log# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 46G 9.7G 34G 23% /
none 4.0K 0 4.0K 0% /sys/fs/cgroup
[code]...
Express Edition (XE) :: Not Connecting To Oracle Homepage?
Sep 28, 2012i am using windows xp home edition (with oracle 11g r2). oracle installed with out any problems but when i click get started internet explorer it says(internet explorer cannot display the webpage) this is the address get started open up to [URL]...but does not work.
View 7 Replies View RelatedExpress Edition (XE) :: What Is Default User Name And Password
Nov 29, 2012I am a new to Oracle, Installed Oracle 11g express edition. Also I had installed Oralce SQL Developer tool but i don't know the user name and password to connect.
what is my default instance? what is my default user name and password? How to connect ?
Express Edition (XE) :: Unable To Install Oracle 9i
Oct 10, 2013could i no longer install oracle 9i.2. should i install other version of oracle as 11g XE. What possible steps should I take than Q.
View 8 Replies View RelatedXE :: Use Oracle DB 11g Express Edition With Atomikos Transactions
Jul 16, 2012I'm able to use Oracle 11g Standard/Enterprise Edition with Atomikos for XA transactions.(XADMS).
My question is Can I Use Oracle DB 11g Express Edition with Atomikos for XA Transactions.
XE :: Oracle 10G Express Edition Account Locked
Aug 16, 2012My Oracle 10G Expression Edition Account locked gets locked, where to raise the request to unlocking my account.as my user name:system
View 4 Replies View Related11g Oracle Express Edition - Destination Host Unreachable?
Jan 11, 2013I installed Oracle 11g Express edition in my local Machine(Windows 7).listener.ora, tnsnames.ora files seems fine. Service and listener are running; While trying to connect to the my db sqlplus>connect sys/oracle as sysdba
I am getting "ora - 12543 TNS: destination host unreachable."
what could be the issue. Find below listener.ora, sqlnet.ora, tnsnames.ora files:=
listener.ora file:=
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
[code]....
Way To Start Oracle Database 10g Express Edition On Fedora
Sep 29, 2007am having problems starting Oracle Database 10g Express Edition on Fedora. Here is what I did in order to start it:
[root@x1-6-00-c0-9f-bb-ba-57 ~]# /etc/init.d/oracle-xe start
[root@x1-6-00-c0-9f-bb-ba-57 ~]# xhost +
access control disabled, clients can connect from any host
Not sure what I am doing wrong here.
Is Full Text Search Possible In Oracle 10g Express Edition
Apr 29, 2011Is full text search possible in oracle 10g express edition. If so, how is it possible. I browsed many places but couldn't find that.
View 1 Replies View RelatedExpress Edition (XE) :: Install 11g Release 2 In Windows 7 64bit?
Oct 23, 2012I am new to this forum. I want to install XE 11g Release 2 in windows 7 64 bit. Can I intall 'Oracle Database Express Edition 11g Release 2 for Windows x32' or is there is 64bit version?
View 2 Replies View RelatedExpress Edition (XE) :: ORA-12505 / TNS / Listener Does Not Currently Know Of SID Given In Connect Descriptor
Jun 2, 2013DB is up and running fine
Connection test failed.
Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:538)
oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
[code].....
XE :: Installation Of Oracle Database 11g Express Edition On Ubuntu 12.10 LTS?
Mar 13, 2013I am installed the Oracle database following the this link .
1.Downloaded 11g express edition
2.Created a new user 'oracle' under the group dba. Following steps are executed using this.
3.unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip and then Converted the rpm to the Ubuntu package
sudo alien --scripts -d oracle-xe-11.2.0-1.0.x86_64.rpm
4.Created /sbin/chkconfig file and added the entries as specified here
5.Created /etc/sysctl.d/60-oracle.conf and added the entries as specified in same link as above.
6.Below steps:
ln -s /usr/bin/awk /bin/awk
mkdir /var/lock/subsys
touch /var/lock/subsys/listener
7.sudo dpkg --install oracle-xe_11.2.0-2_amd64.deb (.deb generated in step 3)
8.sudo /etc/init.d/oracle-xe configure (left the default values as it is)
9.Set the following env variables in ~/.bashrc file
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
export ORACLE_BASE=/u01/app/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:$PATH
[code]....
Now when exectute any SQL statements on SQLplus, i end up with the following error
SQL> select * from dual;
select * from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
I have increased the swap memory as specified in here
free -m
total used free shared buffers cached
Mem: 3901 3428 473 0 182 1988
-/+ buffers/cache: 1258 2643
Swap: 5066 0 5066
Globalization :: Non-English Character In Oracle 10g Express Edition
Oct 5, 2012I have a table. It's name is INSTITUTION. It has a NUMBER INS_ID and NVARCHAR2(50) INS_NAME . INS_NAME can contain Turkish characters, such as "ğ,ü,ş,ç,ö". According to business logic, there can not be a repetition on the INS_NAME.User will enter institution name from a textbox in ASP.NET , and I check this name in database from c sharp code, if there is no repetition, we will add this record.
The problem is; when user enter a instition name that contains Turkish character, there is a duplication. If there is a instition name is *"su işleri"* , the both query; SELECT * FROM INSTITUTION WHERE INS_NAME = *'su işleri'*; and SELECT * FROM INSTITUTION WHERE INS_NAME = *'su isleri'*; returns no result, even though there it is.But if instition name is "oracle corporation" (there is no Turkish character) it query successfully. I have the same problem in Toad for Oracle 11.5.1.2. When I query database from toad SELECT * FROM INSTITUTION, the phrase *"su işleri"* has appeared. But when I query SELECT * FROM INSTITUTION WHERE INS_NAME = *'su işleri'*; , there is again no result.When I connect oracle database directly and perform the query SELECT * FROM INSTITUTION , the phrase *"su isleri"* (not *"su işleri"* ) has appeared.
Here are the language settings of the database:
National Language Support
National Language Parameter Value
NLS_CALENDAR______________GREGORIAN
NLS_CHARACTERSET__________WE8MSWIN1252
NLS_COMP__________________BINARY
NLS_CURRENCY______________TL
NLS_DATE_FORMAT__________DD/MM/RRRR
NLS_DATE_LANGUAGE________TURKISH
NLS_DUAL_CURRENCY_________YTL
[code]....
Express Edition (XE) :: Oracle Doesn't Start Correctly With 3G Router
Oct 7, 2013I have used a HUAWEI dongle directly connected to my PC. First, the operating system and Oracle start up, then I connect to the internet using the Huawei Mobile Partner utility. Any application can connect to Oracle and use it correctly. All OK. Now I have added a 3G router which is connected to the PC by ethernet cable and has the Huawei dongle connected to a USB port on the router. All works correctly if I follow the sequence:
1) Start the PC with the router switched off, and wait until Oracle has fully started.
2) Power the router up and wait 2 minutes until Windows says the 100 Mb ethernet link is open. Oracle.exe in Task Manager is about 210 Mb, and sometimes more, depending on activity.
However, if I switch on the router first and then start the PC, Oracle does not start correctly. It rejects connection requests forever more, indicating Network Adapter could not establish the connection: Code 17002.In Task Manager Oracle.exe occupies only 145Mb. What can I do to get it to start correctly ? I can dig into Listener.ORA, TNSNAMES.ORA and HOSTS without any problems, and have often modified them manually (not the case here), but logs and traces escape me !
Express Edition (XE) :: Connecting To As System Admin On Apex Website?
Sep 5, 2012I'm trying to connect to the Apex website using SYSTEM or SYS. What is the workspace for system?
I logged into SQL command line and created this user using this line then grant dba to it
CREATE USER USER_HP_FULL IDENTIFIED BY w ACCOUNT UNLOCK DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" PROFILE "DEFAULT";
Now, I know the username and password but I don't know the workspace. I want to log into the oracle application express website.
Express Edition (XE) :: Display A List Of All User And Admin Accounts
Jan 28, 2013I've installed XE and I want to know what accounts are active. If I log in to SQL*Plus as sys as SYSDBA how can I display a list of all user and admin accounts? I want to know who can log in.
View 3 Replies View RelatedOracle 11g Express Edition - Load Huge Data Into Table
Nov 6, 2012I am using oracle 11g Express Edition, I have a file of .csv forma, Which has a data of size 500MB which needs to be uploaded into oracle table.
Which would be the best method to upload the data into table. Data is employee ticket history which is of huge data.
How to do the mass upload of data into oracle table.
Express Edition (XE) :: Oracle 11g On Linux Mint - MEMORY_TARGET Not Supported On This System
Feb 5, 2013I decided to use Oracle 11g XE on Linux Mint. I read this tutorial Oracle 11gR2 Express Edition on Linux Ubuntu 11.10 howto included the seventh part. However, I did a minor change in the script given. Indeed, since Ubuntu 12.04, a bug appeared. So I use the following script :
cat > /etc/init.d/oracle-shm <<-EOF
#! /bin/sh
# /etc/init.d/oracle-shm
#
#
case "$1" in
start)
[code]...
I already uninstalled and reinstalled Oracle 3-4 times, but nothing else happened. When I want to configure oracle-xe, I have a such message :
Starting Oracle Net Listener...Done
Configuring database...
Database Configuration failed. Look into /u01/app/oracle/product/11.2.0/xe/config/log for detailsAnd this is the content of the file postDBCreation.log :
begin
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
[code]...