Recent content by Palmero

Hi Mufasa, DATABASE CREATED! Let me know you what happens after. SVRMGR> connect / as sysdba ConnectÚ SVRMGR> startup nomount pfile=C:\Oracle\admin\COGNOS\pfile\cognos.ora Instance ORACLE dÚmarrÚe Zone globale systÞme (SGA) totale de 73701404 octets Fixed Size...

Hi Mufasa, Please find below the contents of my parameter file : # # Copyright (c) 1991, 2000 by Oracle Corporation # ############################################################################## # Example INIT.ORA file # # This file is provided by Oracle Corporation to help you customize #...

Hi Mufasa, YOU'RE RIGHT ! SVRMGR> connect / as sysdba ConnectÚ SVRMGR> But I have another problem : SVRMGR> startup nomount pfile=C:\Oracle\admin\COGNOS\pfile\cognos.ora ORA-24323: valeur interdite ORA-12571: TNS : échec à l'écriture du paquet When I performed the "oradim -new -sid...

C:\>set ORACLE_HOME=c:\oracle\ora81 C:\>set ORACLE_SID=COGNOS Another test : C:\>svrmgrl Oracle Server Manager Release 3.1.7.0.0 - Production Copyright (c) 2000, Oracle Corporation. Tous droits rÚservÚs. Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option...

Hi Mufasa, My ORACLE_HOME is defined in the Windows Registry HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE (Oracle_home=c:\oracle\ora81). My ORACLE_SID is defined in the Windows Registry HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 for my first database (Oracle_sid=MYBASE) which works. The Oradim I performed...

Hi Mufasa, I am performing your solution, but I have problems to connect / as sysdba. What could be the issue according to you. The "OracleOraHome81TNSListener" is started. Thanks very much for your help. SVRMGR> connect / as sysdba ORA-12560: TNS : erreur d'adaptateur de protocole...

Hi all, In my laptop, I have installed an oracle 8.1.7 database with character set WE8ISO8859P1. I want to install a product and the installation will work if and only if I have an oracle database with character set UTF8. I can't alter the database with this character set (see below) : SQL>...

Hi all, I need to audit servers and users activity with Impromptu Web Reports, PowerPlay and Visualizer. I have found the solution for Impromptu Web Reports and PowerPlay. I need to know if it is possible to have in a log file following information : - the report name - the username who...

Hi all, When analyzing statistics for an Oracle 8i request, what is the significance of following parameters : - physical reads - block get - consistent gets - blocks changes - consistent changes - buffers get in trace optimisations How are the following parameters used : - block buffers =...

Hi all, Is it normal to have more Rollbacks than commits in an Oracle 8.1.7 production database? Thanks for your feed-back. Palmero.

Hi all, In a Citrix environment, I have problems of processes remaining in the server even client users are disconnected. The following programs are INACTIVE in the server and anyone is connected : - CTMAPP32.EXE - CFSAPP32.EXE - INTREX32.EXE - SLAPP32.EXE Do you know if these programs are let...

Hi all, The following SQL syntax does work on Oracle, but not on Sybase. Do you have a workaround without using a temporary table? Thanks in advance for your help. SELECT T1.code,T2.label FROM (SELECT ......) T1, (SELECT ......) T2 WHERE T1.code=T2.code; Palmero.

Hi all, The following SQL syntax does work on Oracle, but not on Sybase. Do you have a workaround without using a temporary table? Thanks in advance for your help. SELECT T1.code,T2.label FROM (SELECT ......) T1, (SELECT ......) T2 WHERE T1.code=T2.code; Palmero.

Hi all, I want to install on my PC a Personal Oracle 8i and an Oracle Client NET8. How can I proceed to install the 2 versions on my machine? Thanks in advance for your answer. Palmero.

Hi all, I am populating an Oracle V7.3.4 table from a flat file using the following procedure : create or replace procedure Charge_produit is -- declaration of variables BEGIN WHILE MY_GET_LINE(file_handle,ligne) LOOP BEGIN INSERT INTO TMP_PRODUIT values (...