listener failed to start a dedicated server process

2001-11-18 Thread ehsan sinavalda

Hi, 
When I tried to start one more session of oracle 
SQLPLUS I got this error: 

ERROR: 
ORA-12500: TNS:listener failed to start a 
dedicated server process 


But the other session which was already open is 
working properly.Could you please tell me what 
could be the problem and how to make this not 
occur again? 

Thanks, 

E.

__
Do You Yahoo!?
Find the one for you at Yahoo! Personals
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ehsan sinavalda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: listener failed to start a dedicated server process

2001-11-18 Thread Mike J Kurth


Assuming you are unix...

If you are on 7.3.4 it may be caused by not disabling Oracle trace.

Otherwise you have probably exceeded a unix limit, like maxuprc.




  AM PST

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:


Hi,
When I tried to start one more session of oracle
SQLPLUS I got this error:

ERROR:
ORA-12500: TNS:listener failed to start a
dedicated server process


But the other session which was already open is
working properly.Could you please tell me what
could be the problem and how to make this not
occur again?

Thanks,

E.

__
Do You Yahoo!?
Find the one for you at Yahoo! Personals
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ehsan sinavalda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mike J Kurth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: Dba studio under 9i for Linux?

2001-11-18 Thread Torben Holm

Hi,

Use oemapp in $ORACLE_HOME/bin. oemapp requiers some parameter (that tells
witch program to start (DBA studio among others)). If you call it without
parameters it will tell you possible values.

regards

torben holm


Csillag Zsolt wrote:

 Hi,

 Can you tell me where can I find Dba Studio under Oracle 9i for Linux.
 I've tried the different files in the Bin directory with no result.

 T.I.A.

 Zsolt Csillag
 Hungary

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Csillag Zsolt
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).



smime.p7s
Description: application/pkcs7-signature


RE: frequent commit, example ??? HELP

2001-11-18 Thread Steve Adams

Hi Andrea,

Don't do it! Adding commits makes the code more complex, much less efficient and risks 
violating transactional
integrity. See http://www.ixora.com.au/newsletter/2001_09.htm#commits for a detailed 
explanation of the problems.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/  -  For DBAs
@   http://www.christianity.net.au/   -  For all


-Original Message-
Sent: Friday, 16 November 2001 6:00
To: Multiple recipients of list ORACLE-L


Hi all,

Thank you all those for responding to the frequent
commit question.  So members suggested using count,
and loop.  May I have real example.  (OK, I'm bad at
pl/sql).  Site table has 2 million rows, how to so a
commit, let's say 5000 rows.  Site_id is unique in
site table.  How does the counter fit in the following
update sql?

update site a set a.site_code =
   (select c.area_code
   from site_location b,
   area c where a.site_id = b.site_id and
c.area_id = b.area_id);

I put a counter is a sample code, and update runs 10
times! then commit, then runs another 10 times! then
commit   I must miss something.  Please give me as
mush detail as you can.  Thank you so much!



Andrea

__
Do You Yahoo!?
Find the one for you at Yahoo! Personals
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andrea Oracle
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve Adams
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



lsnrctl error

2001-11-18 Thread Csillag Zsolt



Hi,

I've installed Oracle 9i.
I can start the database, but when I want to run lsnrctl I get the message:

Message 414 not found;No message file for product=network, facility=nms

Thank you


Zsolt Csillag
Hungary

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Csillag Zsolt
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Need to update the ORACLE SID on W2000 Registry

2001-11-18 Thread Reardon, Bruce (CALBBAY)

Perhaps what the doco is talking about is your default connection under NT.

Under NT, if you set oracle_sid in the registry, then when you use svrmgrl /
sqplus you do not need to set it first.

So. maybe the doco is suggesting that if you create a 2nd database, then you
might want that to be your default database so maybe you will need to alter
the default sid.  If this is the case, then (AFAIK) oradim does not let you
create / update a default sid.

That said, I prefer not to have a default SID at all, and I just always type
set oracle_sid=blah myself at the CMD prompt.

How to tell if you current have a default SID - open a new CMD prompt, run
svrmgrl and issue a connect and see if it works.
Also try typing set oracle_sid at the CMD prompt to see if someone defined
a default SID as an environment variable.

HTH,
Bruce Reardon

-Original Message-
Sent: Saturday, 17 November 2001 5:20

Whoa Mark!

You really want Ken to much around in the registry?

I think what he's asking is how to use 'oradim'?

Ken, just type 'oradim' on the command line, and you will
get a help screen.  Look it up in the docs if you have to, but
it supplies a pretty good help screen.

Don't mess with the registry unless you have to.  It's not
terribly dangerous, but like Mark said, back  it up first
via File-Export.

Jared




 

Mark Leith

mark@cool-too   To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
ls.co.ukcc:

Sent by: Subject: RE: Need to update the
ORACLE SID on W2000 Registry   
[EMAIL PROTECTED]

om

 

 

11/16/01 08:00

AM

Please respond

to ORACLE-L

 

 





Ken,

You need to run (Start/Run..) either of the programs regedit (my personal
favourite), or regedt32. The registry is essentially the file that holds
all of the config/licenses etc. settings for your programs, O/S, services
etc.

regedit is an Explorer type interface, so you will need to navigate
through the directory type interface to
HKEY_LOCAL_MACHINE/SOFTWARE/Oracle/ALL_HOMES.. or whatever it is off the
top
of my head, and modify the string by double clicking it on the right hand
window, and editing it in there..

It is ALWAYS a good idea to take a backup of your registry before modifying
it!! If you use regedit to do this, simply pull down you file menu, and
export the registry to a nice safe location :)

HTH

Mark

-Original Message-
Sent: 16 November 2001 15:15
To: Multiple recipients of list ORACLE-L


I will be creating a new database from a DDL SQL script on a W2000 server
using 8.1.7.

My previous experience has been in the Unix world so the Registry is
something new to me.  The server has the Oracle demo DB installed.  I need
to create this new DB and the Oracle Post-Installation DB Creation guide
says that I need to update the ORACLE SID in the Registry if I am going to
create a new DB.

So, I need to become familiar with this Registry thing.  Is the Registry
located on my client PC or the server?  And, how do I access it and make
the
necessary changes to the SID?  I have administrator access on the server.

Keep your answers simple please because I am new the Registry

Thanks,

Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: lsnrctl error

2001-11-18 Thread Joe Testa

what platform? sounds like (if windoze, registry entry not set
correctly, but thats a guess as I dont do microsoft), if unix then
sounds like entorinment variables are not set correctly.

joe
Csillag Zsolt wrote:
 
 Hi,
 
 I've installed Oracle 9i.
 I can start the database, but when I want to run lsnrctl I get the message:
 
 Message 414 not found;No message file for product=network, facility=nms
 
 Thank you
 
 Zsolt Csillag
 Hungary
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Csillag Zsolt
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing)

-- 
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Fwd: Extproc problem...

2001-11-18 Thread Jared Still



--  Forwarded Message  --
Date: Sun, 18 Nov 2001 22:47:09 -
To: 'Jared Still' [EMAIL PROTECTED]


Hi Jared,
I am sure you can help me on this.
I am encountering problems to run an O/S command  from a stored
procedure/procedure.
The error log is as follows...
SQLcreate library shell_lib as '/data1/dev/uexit/test/extproc.so';
SQL create or replace function sysrun (syscomm in varchar2)
  2  return binary_integer
  3  as external
  4  name sysrun
  5  library shell_lib
  6  parameters(syscomm string);
  7  /

Function created.

SQL declare rc  number;
  2  begin rc := sysrun('/bin/ls -l');
  3  dbms_output.put_line('Return Code='||rc);
  4  end;
  5  /
declare rc  number;
*
ERROR at line 1:
ORA-06521: PL/SQL: Error mapping function
ORA-06522: ld.so.1: extprocextproc: fatal: sysrun: can't find symbol
ORA-06512: at UEXIT.SYSRUN, line 0
ORA-06512: at line 2

Could you please help on this.
Thanks a lot.
Baral


*
This message is confidential and for use by the addressee only. If you
are not the intended recipient, you must not use, disclose, distribute,
copy, print, or rely on this message. Please notify the sender by
return email and then delete the message from your computer. Royal Skandia
accepts no responsibility for changes made to this message after it was
sent nor for any loss or damage from receipt or use.

Royal Skandia Life Assurance Limited - a member of the Skandia Group of
Companies - Reg No: 24916 Isle of Man - Registered Office: Skandia
House, Finch Road, Douglas, Isle of Man IM99 1NU, British Isles - Regulated
by the Personal Investment Authority for UK Investment Business -
Member of the Association of International Life Offices.

Internet: http://www.royalskandia.com

*

---
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: lsnrctl error

2001-11-18 Thread Shreeni

have u checked your ORACLE_HOME ?? r there 2 separate verions of Oracle on
the same machine ??


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, November 18, 2001 6:20 PM


 what platform? sounds like (if windoze, registry entry not set
 correctly, but thats a guess as I dont do microsoft), if unix then
 sounds like entorinment variables are not set correctly.

 joe
 Csillag Zsolt wrote:
 
  Hi,
 
  I've installed Oracle 9i.
  I can start the database, but when I want to run lsnrctl I get the
message:
 
  Message 414 not found;No message file for product=network,
facility=nms
 
  Thank you
 
  Zsolt Csillag
  Hungary
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Csillag Zsolt
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing)

 --
 Joe Testa, Oracle DBA
 Want to have a good time with a bunch of geeks? Check out:
 http://www.geekcruises.com/standard_interface/future_cruises.html
 I'm presenting, when registering drop my name :)
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Joe Testa
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shreeni
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



[Fwd: Oracle DBA/Developer Position]

2001-11-18 Thread Maria Aurora VT de la Vega




---BeginMessage---








I am looking for an Oracle DBA/Developer for a
position here in Dallas. It is a very difficult req to fill. I have
attached a copyof this positions requirements.



This is a very specific Designer/2000
 PL/SQL Programmer position, utilizing Oracle 6i Web
Generation (60% of time) and Development-DBA position (40% of time). This position is not a DBA-Only
position (the candidate must have development experience), and the majority of
time will be spent in the developer role, utilizing the areas listed below. 


T he DBA aspects of this position are very developmental in nature, as
well. This is NOT a traditional DB
setup  monitor position, but is heavily involved in development DBA areas,
such as data analysis  troubleshooting, SQL-Tuning, data mining 
manipulation for 25-million row DB's.

Must have 3+ Years in Oracle Web
Generation or Forms and 3+ Years in a development-DBA role 

If you do have this specific
experience, and is the type of job you're looking for, please respond to my
questions below, specifically describing your pertinent experience to these
position requirements:

1. Designing  Developing HTML-based applications
specifically using Designer2000 Version 6.0.3.4  6i Web server
Generation Modules: [Describe your specific experience here, with
examples, and total years for each bullet]

2. DBA experience Overall:

3. DBA with specialties in tasks of:



 - Data Mining  Manipulation:



 - Data Warehousing:



 - Data Analysis:



 - Replication:



 - SQL-Tuning  DB-Process Tuning:



 - DB Troubleshooting:



 - Other DBA/Data Related Tasks of large-scale
databases (20-30 million rows):



- PL/SQL Coding Experience (no less
than a 9-out-of-10):



- Designer/2000 baseline 
customization Experience:



- JavaScript  HTML Experience:



- Developer2000 Reports experience



- Communication skills:



- Other Related Experience:



- JSP  Servelets Experience (Nice
to have, not Mandatory):



Erik N. Carlson
Carlson Corporate Research, Inc.
214.828.4039
[EMAIL PROTECTED]












---End Message---


JDBC connections and SQL netTraffic

2001-11-18 Thread Murali Vallath


Can someone provide some education.

The application uses JDBC thin driver to make a connection to the database, 
with WEBlogic the connection pooling (similar to MTS) is also implemented.

Why would  one see a large number of SQL*NET traffic?  Any ideas?

Thanks

Murali Vallath

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Murali Vallath
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: dbv Output - Pages Failing (Data)

2001-11-18 Thread Cyril Thankappan



Hello,

I believe you are using the dbv on
Solaris 8
on the datafile of 
Solaris 6

My experience has been that dbv
acts 'very funny' in these type of scenarios
in fact what you are encountering is
'expected behaviour'

However, don't be surprised if dbv runs
'successfully' for ALL datafiles
except system ,rollback and temp tablespaces'
datafiles

Thanks

Cyril
On Fri, 16 Nov 2001 VIVEK_SHARMA wrote :
 
 The Problem Occured upon Extracting on Solaris 2.8 the 
 Cold Backup of a
 Database existing in Solaris 2.6 for Oracle ver 7.3.4.5
 
 $ uname -a
 SunOS SF2A 5.8 Generic_108528-10 sun4u sparc SUNW,
 Sun-Fire
 
 Qs. Are there Any O.S./Oracle Patches which Should be 
 Applied when Doing
 Such an Extract ? 
  
 
 - Running dbv Utility for SOME of the Datafiles Giving 
 the Following
 Error :-
 
 $ dbv file=/mis/data3/ACCT_MASTER_bby01_13.dbf 
 blocksize=8192
  
 DBVERIFY: Release 7.3.4.5.0 - Production on Thu Nov 15 
 13:46:03 2001
  
 Copyright (c) Oracle Corporation 1979, 1996.  All 
 rights reserved.
  
 DBVERIFY - Verification starting : FILE =
 /mis/data3/ACCT_MASTER_bby01_13.dbf
 kdbchk: row locked by non-existent transaction
 table=0   slot=20
 lockid=56   ktbbhitc=5
 Page 55366 failed with check code 1
 kdbchk: row locked by non-existent transaction
 table=0   slot=68
 lockid=56   ktbbhitc=1
 Page 104550 failed with check code 1
  
 
 DBVERIFY - Verification complete
  
 Total Pages Examined : 115200
 Total Pages Processed (Data) : 114430
 Total Pages Failing   (Data) : 2
 Total Pages Processed (Index): 0
 Total Pages Failing   (Index): 0
 Total Pages Empty: 769
 Total Pages Marked Corrupt   : 0
 Total Pages Influx   : 0
 $
 
 Qs. What can be Done About the Total Pages Failing   
 (Data) : 2 Pages
 ?
 
 
 -- 
 Please see the official ORACLE-L FAQ: 
 http://www.orafaq.com
 -- 
 Author: VIVEK_SHARMA
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: 
 (858) 538-5051
 San Diego, California-- Public Internet access 
 / Mailing Lists
 -
 
 To REMOVE yourself from this mailing list, send an 
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB 
 ORACLE-L
 (or the name of mailing list you want to be removed 
 from).  You may
 also send the HELP command for other information (like 
 subscribing).
 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cyril  Thankappan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Oracle 7.1 Listener question

2001-11-18 Thread C.S.Venkata Subramanian

Dear List,
Pl excuse me for asking a very old question. In one of our client Site are running 
Oracle 7.1 in SCO Unix. The Appln is unix based and they connect to Oracle via Dumb 
terminals using I/O card and not network card. We have to migrate the application to 
Client Server Mode. So we have to install a network card and make listner up and 
running to accept the connections. The person who installed Oracle 7.1 says that in 
7.1 there is no listener and from 7.3 only Oracle came out with the concept of listner.

So Gurus some of you might worked in 7.1 in any platform. Could you recollect and tell 
me whether listener was there in 7.1. I had browsed technet documentation, but there 
are only 7.3 and upwards documentation and no 7.1 documentation.

Thanks in Advance

venkat


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: C.S.Venkata Subramanian
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: listener failed to start a dedicated server process

2001-11-18 Thread Rajesh Dayal

Hi,
check following issues as well,

If you are referring ORACLE_HOME in your tnsnames.ora
Value of parameter PROCESSES is too low.

HTH,
Rajesh

-Original Message-
Kurth
Sent: Sunday, November 18, 2001 7:30 PM
To: Multiple recipients of list ORACLE-L



Assuming you are unix...

If you are on 7.3.4 it may be caused by not disabling Oracle trace.

Otherwise you have probably exceeded a unix limit, like maxuprc.




  AM PST

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:


Hi,
When I tried to start one more session of oracle
SQLPLUS I got this error:

ERROR:
ORA-12500: TNS:listener failed to start a
dedicated server process


But the other session which was already open is
working properly.Could you please tell me what
could be the problem and how to make this not
occur again?

Thanks,

E.

__
Do You Yahoo!?
Find the one for you at Yahoo! Personals
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ehsan sinavalda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mike J Kurth
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rajesh Dayal
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).