AW: Oracle select data problem...

') 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: Schoen Volker INET: [EMAIL

SOLVED: TNS-12537 TNS:connection closed

without problems. But suddenly after a reboot I got TNS-12537. Server was rebootet before, no changes were made to environment (NT Patches, Oracle Patches...). regards Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Schoen Volker

TNS-12537 TNS:connection closed

: http://www.orafaq.com -- Author: Schoen Volker 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

AW: TNS-12537 TNS:connection closed

with the underlying communication layer. Did you try a tnsping from the client ? Did you try to connect to the DB on the server via TCP/IP and bequeath ? Regards, Stefan Jahnke Schoen Volker schrieb: Dear Newsgroup, I have an Oracle Server 8.1.7.0.0 on an NT4-Server SP 6 platform. When I want to connect me

AW: ORA-12545 WHEN CREATING A NEW DATABASE

Title: Nachricht Hi Bunyamin, let dbassistant create scripts for your database. Then edit your listener.ora and tnsnames.ora and add entries for your new instance. After this edit db create scripts and instead of "connect internal" write "connect

AW: exp/imp unable to create unix index

also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

AW: Terminal Server / svrmgrl

Title: Nachricht I'm running 8.1.6 SE on W2K with terminal services enabled. svrmgrl and sqlplus are running fine, no problems. If your connect internal doesnt't work try "connect internal@your_instance". What are the error messages you get? regards Volker Schoen E-Mail: mailto:[EMAIL

NLS questions

Title: NLS questions Hi list, I have some questions about NLS Parameters. I have a database created with following NLS parameters: NLS_LANGUAGE POLISH NLS_TERRITORY POLAND NLS_CHARACTERSET EEISO8859P2 My Client (Windows 2000, Polish) uses following NLS_LANG parameter

AW: ADO.NET and Oracle 8.1.6

also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

AW: Help with passwords

, 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: Schoen Volker INET: [EMAIL PROTECTED] Fat

Q about autoextent tablespaces and performance

Title: Q about autoextent tablespaces and performance Hi list, I need some opinions about following question. I have a developer box with about 20 schemas. Sometimes our customers send us a export of there data which I had to import into our develop instance. My problem is that I don't

AW: How to find the current instance name?

for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

AW: Error in creating tablespace

-- Author: Schoen Volker 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

AW: test schema from prod

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: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

OT: Need Hardware advice under Linux

Title: OT: Need Hardware advice under Linux Hi List, I want so setup new oracle server (for developement) under linux. I will install RedHat 7.1. What I like to know is what processor should I choose AMD Athlon 1,4 Ghz or Intel 1,5 Ghz, I would prefer AMD. Are there any know problems

AW: test schema from prod

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: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

AW: Hanging processes on NT

, 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: Schoen Volker INET: [EMAIL PROTECTED] Fat City

Hardware requirements when migration oracle from NT to Linux

Title: Hardware requirements when migration oracle from NT to Linux Hi list, I want to migrate our developer databases from NT 4.0 (Oracle 8.1.5) to Redhat Linux 7.1 (Oracle 8.1.7). My question is, which hardware do I need for the linux machine to hit the same performance than on NT

Solved: IMP-00069 error when importing 8.1.7 export

Hi list, I got the export made with exp V8.1.6 and succesfully imported it with imp V8.1.7 to oracle 8.1.5 database. A lot of versiosn to use. Thanks to all who replied Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Schoen Volker

IMP-00069 error when importing 8.1.7 export

://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

AW: Delete Alertlog on NT

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: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Q about Oracle Optimizer

question: What does oracle optimizer do, if there are no statistics on all objects. Optimizer level is choose. Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] Fat City

AW: Slow sql

') 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: Schoen Volker INET

changing long col to varchar and vice versa

2000 characters. Could someone tell how to convert these columns? TIA Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Copying table with LONG column

Does someone know how to copy a table with a long column? Export/Import works, but I like to do it with SQL. TIA Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED

SOLVED: Copying table with LONG column (using copy getting ORA-01

Works for me: set buffer 10 use the sqplus on dos..ie. sqlplus.exe Thanks to Ashish Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Schoen Volker Gesendet: Donnerstag, 9. August 2001 12:50 An: LazyDBA.com Discussion Betreff

AW: URGENT

use auditing Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht-Von: Saravana Kumar [mailto:[EMAIL PROTECTED]]Gesendet: Donnerstag, 26. Juli 2001 14:43An: Multiple recipients of list ORACLE-LBetreff: URGENT Hi Friends, I

Q: Oracle 8.1.7 install on Redhat 7.1

: Schoen Volker 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

Buffer Hit Ratio 10% on UNIX HP/UX 11.0

163840 TIA Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Q: WILLING_TO_WAIT_COPY 1%

: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Q: UTL_SMTP

://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

AW: Errors in Oracle

(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

EM 2.2 installation crashes my database

-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

NLS question about Euro Sign

? TIA Volker E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Unix Memory Question

with this instance. TIA Volker Schn E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Q: values in V$SGA

Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai