Links
Home
Oracle DBA Forum
Frequent Oracle Errors
TNS:could not resolve the connect identifier specified
Backtrace message unwound by exceptions
invalid identifier
PL/SQL compilation error
internal error
missing expression
table or view does not exist
end-of-file on communication channel
TNS:listener unknown in connect descriptor
insufficient privileges
PL/SQL: numeric or value error string
TNS:protocol adapter error
ORACLE not available
target host or object does not exist
invalid number
unable to allocate string bytes of shared memory
resource busy and acquire with NOWAIT specified
error occurred at recursive SQL level string
ORACLE initialization or shutdown in progress
archiver error. Connect internal only, until freed
snapshot too old
unable to extend temp segment by string in tablespace
Credential retrieval failed
missing or invalid option
invalid username/password; logon denied
unable to create INITIAL extent for segment
out of process memory when trying to allocate string bytes
shared memory realm does not exist
cannot insert NULL
TNS:unable to connect to destination
remote database not found'>ora-02019
exception encountered: core dump
inconsistent datatypes
no data found
TNS:operation timed out
PL/SQL: could not find program
existing state of packages has been discarded
maximum number of processes exceeded
error signaled in parallel query server
ORACLE instance terminated. Disconnection forced
TNS:packet writer failure
see ORA-12699
missing right parenthesis
name is already used by an existing object
cannot identify/lock data file
invalid file operation
quoted string not properly terminated
SOLVED NOT it seems: RE: XP + SP2 + problem creating database Ora-03113

SOLVED NOT it seems: RE: XP + SP2 + problem creating database Ora-03113

2004-11-10       - By Leonard, George

Hi all

Ok it seems I spoke to soon.

It just teased me yesterday.

Got home last night, got a private WiFi network at home, connected and
suddenly I could connect, created database etc. at that time my XP
firewall was running.

Got back to the office this morning and back to my friend Ora-03113 (See Ora-03113.ora-code.com) end
of Communication Channel.

I am pretty sure it is network related but don 't have a clue what it
could be since I have even disabled the firewall on my machine and still
have the problem, I found the netsh firewall command and disabled
everything, no change.=20

Added oracle.exe and tnslsnr.exe to the firewall exclusion list.

Anyone sent his before, solved this before.

George
=20__ ____ ____ ____ ____ ____ ____ ____ ____ _____
George Leonard
Oracle Database Administrator
New Dawn Technologies @ Wesbank
E-mail:gleonard@(protected)
=20
You Have The Obligation to Inform One Honestly of the risk, And As a
Person
You Are Committed to Educate Yourself to the Total Risk In Any Activity!
Once Informed & Totally Aware of the Risk,
Every Fool Has the Right to Kill or Injure Themselves as They See Fit!
=20

-- --Original Message-- --
From: Leonard, George=20
Sent: 09 November 2004 12:22 PM
To: 'oracle freelists.org '
Subject: SOLVED: RE: XP + SP2 + problem creating database Ora-03113 (See Ora-03113.ora-code.com)

Guys

NOTE Note:280750.1 solved my problems.

George
=20__ ____ ____ ____ ____ ____ ____ ____ ____ _____
George Leonard
Oracle Database Administrator
New Dawn Technologies @ Wesbank
E-mail:gleonard@(protected)
=20
You Have The Obligation to Inform One Honestly of the risk, And As a
Person
You Are Committed to Educate Yourself to the Total Risk In Any Activity!
Once Informed & Totally Aware of the Risk,
Every Fool Has the Right to Kill or Injure Themselves as They See Fit!
=20

-- --Original Message-- --
From: Leonard, George=20
Sent: 09 November 2004 12:10 PM
To: oracle freelists.org
Subject: XP + SP2 + problem creating database Ora-03113 (See Ora-03113.ora-code.com)

Hi all

I previously had a database on my laptop, running XP+SP1 at that time,

Since then applied the SP2 patch, discovered I could not log onto the
old database, was nothing critical in it, so dropped it.

Trying to create a new database and running into ora-03113 (See ora-03113.ora-code.com)

I have added the service, created the password file, set the oracle sid,

But when I go=20

Sqlplus /nolog
Connect sys as sysdba
Give password it just shouts back with ora 3113 en of communication
channel.

Thought maybe it is the new XP firewall so complete disabled that, still
no joy,

Anyhow with ideas.

Thanks.

George
=20__ ____ ____ ____ ____ ____ ____ ____ ____ _____
George Leonard
Oracle Database Administrator
New Dawn Technologies @ Wesbank
E-mail:gleonard@(protected)
=20
You Have The Obligation to Inform One Honestly of the risk, And As a
Person
You Are Committed to Educate Yourself to the Total Risk In Any Activity!
Once Informed & Totally Aware of the Risk,
Every Fool Has the Right to Kill or Injure Themselves as They See Fit!
=20
le-l
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ _____=
__ ____ ____ ____ ____ ___


The views expressed in this email are, unless otherwise stated, those of =
the author and not those
of the FirstRand Banking Group an Authorised Financial Service Provider o=
r its management.
The information in this e-mail is confidential and is intended solely for=
=20the addressee.
Access to this e-mail by anyone else is unauthorised.
If you are not the intended recipient, any disclosure, copying, distribut=
ion or any action taken or=20
omitted in reliance on this, is prohibited and may be unlawful.
Whilst all reasonable steps are taken to ensure the accuracy and integrit=
y of information and data=20
transmitted electronically and to preserve the confidentiality thereof, n=
o liability or=20
responsibility whatsoever is accepted if information or data is, for what=
ever reason, corrupted=20
or does not reach its intended destination.

=20 __ ____ ____ ____ ____ ____ ____
--
http://www.freelists.org/webpage/oracle-l