Search results for query: *

Hello!!! I haven't Oracle license so I can't access to Oracle metalink. Could somebody pass me a file with the Note 186130.1 Clustercheck.exe Fails with Windows Error 183 . Thanks in advance, Silvia

Hello, I've two servers in cluster mode with W2K Advanced Server, and a RAID-5 array of 4 disks shared by both of them. My problem is that I've installed The Cluster Service of Windows in order to have an active/passive configuration of my servers, because I have a common directory structure...

Good morning!! I've solved the problem. It wasn´t at Oracle, the problem was the ODBC, I was using and old ODBC that it wasn´t compatible with the Oracle version installed on my computer. I've downloaded and installed ODBC for Oracle 8.1.7 and all works fine. Bye, Silvia

...the database(ORA-12154 TSN couldn´t resolve the service name). But I think Oracle is well installed because when I try to access database with SQL * Plus no problems happen. The most curious is that in other pc I've probed the conexion with Oracle using ODBC and I hadn´t any...

Hello! I'm installed Oracle 8.1.7 Enterprise Edition on my pc with Windows NT. I can declare services and when I connect with sql*plus using username/pwd@servicename all works ok. But when I declare an ODBC alias to access Oracle database the ORA-12154 appears. My tnsnames.ora,sql.net...

:-S, I'm installing on a pentium 4 procesor. I read the bugs in the release notes and I saw the problem but it was referenced to Java and Oracle, wasn´t it?¿

I follow your recommendations and I've resized the system tablespace. Besides I've executed the following query to check how many users use this tablespace as default_tablespace: SQL> select username,default_tablespace from sys.dba_users; USERNAME DEFAULT_TABLESPACE...

...a.tablespace_name, a.bytes/1024/1024 "ALLOCATED", 2 sum(b.bytes)/1024/1024 "FREE", 3 round ((sum(b.bytes)/a.bytes),3) *100 "%_FREE", count(*) "# OF CHUNKS" 4 from sys.dba_data_files a, sys.dba_free_space b 5 where a.file_id = b.file_id...

Good morning!!! I've installed Oracle 8.0.3 Personal Edition at my computer with Windows NT, and I want to install Oracle Enterprise 8.1.7 at the same pc, but I'd like not to desinstall the other installation. Is this possible? It´s so, what must I do to avoid problems? I know a...

Good morning! Now the size of the 3 databases are 1'5MB, but the final database will be quite bigger, because at the actual moment only have some data of proof. However, I suppose that I'll follow your advice and I'll try with a size and I'll see how about. Thanks a lot of for...

But the three databases are related to between them, so I don't know if it'd be the best solution create a diferent schema for each one. What I mean, it's that the data at three databases are accessed for the same application and the same users. And about the size, the problem is that at...

Good morning everybody!!! I'm creating an Oracle database taking a MS Access database as reference, actually, 3 Ms Access database, and this is my question: Should I create a different tablespace for each MS Access? or I'd simply put each one into a different datafile? ... I'd like to take...

Is it possible to migrate an Oracle 8i database to an Oracle 9 database without many problems. If it´s so, what is the easiest and the best way to do it? My os is Windows 2000 server. Thanks a lot of. Silvia

My version of Oracle is 8.03, I suppose that this can be the problem. I'm going to install the Enterprise Edition in the server but first I decided to install the personal edition to make some local proofs. Thanks a lot for your advice, I was going mad whith the error. Bye...

Hello!!! This error follows me. First when I try to execute a function of the dbms_random package and then when I try to call an external procedure,the same error always appear: ORA-06521: PL/SQL: Error al crear la correspondencia de la función. And I don´t have any idea about the...

Hello! I'm trying to execute a procedure which call an external function, and the next problem has appeared: SQL> exec run_demo; SQL Error: ORA-06521: PL/SQL: Error al crear la correspondencia de la función ORA-06522: Unable to load symbol from DLL Procedimiento PL/SQL terminado con éxito...

Thanks a lot!!! The initial problem was solved configuring the files tnsnames.ora and listener.ora, but a new problem has appeared: SQL> exec run_demo; SQL Error: ORA-06521: PL/SQL: Error al crear la correspondencia de la función ORA-06522: Unable to load symbol from DLL Procedimiento PL/SQL...

Hello, I need to use an external dll with a method in C. In order to do that, I've done the following steps: 1.- Generate the DLL with the export function inside: __declspec(dllexport) int __cdecl CFunc(int seed) { ... } 2.- Create a PL/SQL Library CREATE...

...return integer as code INTEGER; num INTEGER; seed BINARY_INTEGER; begin SELECT IdCodeSeq.NextVal INTO seed FROM Dual; dbms_random.initialize(seed*1000); code := dbms_random.random; SELECT Count(*) into num FROM Tabla WHERE ID=code; while num=0 LOOP code := dbms_random.random; select count(*)...

No, I haven't linux, the operating system at the server is Windows 2000 server and the server is a Dell PowerVault 75xN NAS Cluster which will be used by a LAN. I'm really lost, if you could help me to begin at least it would be great. Thanks a lot for your cooperation...