Search results for query: *

I have installed Oracle 11g and ASM libraries. Also, I have created the database but when I tried to add a tablespace, it just says that database is "Not Open". Whenever I try to open the db, it complains that it is not allowed for this instance type. GRID:oracle:/home/oracle/ />sqlplus...

I have two questions regarding my RH-9 Linux system: 1. My system has several services running on it. Is there any way of knowing which services are running and on which ports. Mainly I want to know which service is running at port 80. 2. My DB2 [on the same system] does not start because the...

Hi Can we have index and trigger on TYPEd tables. Also can we have primary key constraint on such tables. The moment I tried to create the primary key, it says, the column can take null values and if I impose in the TYPE, then it says the following error. CREATE TYPE "TIPT_TYPE" AS ( "ID"...

Hi, Can anybody pls tell me which system catalog view contains the backup information. I know by using the file-structure or file name this can be evaluated, but I want to extract from system catalog tables. thanks in advance Ifxtechie

Hi, I am trying to create a simple stored procedure. But I am hitting to a starnge problem. C:\temp>db2 -td@ -vf samp.sql CREATE PROCEDURE get_count(OUT counter INT) LANGUAGE SQL BEGIN DECLARE SQLSTATE CHAR(5); DECLARE v_id CHAR(1); DECLARE v_name VARCHAR(15); DECLARE v_counter...

Hi, I need some help. I am using Informix 9.2 on Linux. I am trying to load some data from a huge file and I am trying to do this by ipload. After I creating the job, it always complains as Error: Onpload must run on the host (192.168.0.3) that contains the target database. Even I tried to...

Hi, I need some help. I am using Informix 9.2 on Linux. I am trying to load some data from a huge file and I am trying to do this by ipload. After I creating the job, it always complains as Error: Onpload must run on the host (192.168.0.3) that contains the target database. Even I tried to...

Hi, I want to create a new database from scratch without using the installer. I figured out some steps to do that. Pls let me know if this method is correct. On my windows, I have C:\oracle\admin\OEMREP directory for oemrep database. For a new database PARTHA, Can I do like as below: 1...

Hi, I posted this message in PERL forum, but infortunately I did not get any answer. [thread219-730649 ] Hence I am posting it here. Pls help me to access my oracle database through PERL. The posted one is for DB2. But I did for Oracle also and could not succeed. I could not find ora.pm file...

Hi, I am writing a trigger to insert a record into a table of server2 [different machine] whenever there is an insert in one of the local tables. The only problem I am facing is 'How to access a TABLE OF DIFFERENT SERVER'. Local Machine Credentials: Database : db1 ip:ip1 user:user1...

Hi, I have installed Active Perl [5.8]. I want to access my DB2 and Oracle databases. Hence I downloaded the DBD for DB2 [version .76]. When I tried to build on DBD, as said in README file, using the command perl -w Makefile.PL it went fine. But it gave errors in the second step when making...

Hi, I am having problems in installing the DB2 on Redhat Linux 8. I am using pdksh, netscape, etc which are some of the prerequisites. I am trying to install on P-II 512MB machine. I am getting the same error whenever I try to install. Can anybody help me in resolving this. Thanks in advance...

Hi, I am getting a new problem. I just declared two event types in SysA and SysB in SysApackage and SysBpackage and collaboration rules [cr_FileIn, cr_FileOut and cr_JavaA2B]. Compilation of cr_FileIn and cr_FileOut were simple as they were java-passthroughs. But during compilation of cr_JavaA2B...

Hi, I am trying with an example just to make sure that the installation went well. But I landed in some erroneos condition. Can anybody please help me in resolving this problem . I am pasting the portion of error message below : 23:16:57.779 COL I 3552 (java_extensions.cxx:956)...

Hi, I have a machine which has THIZ linux. Can I install RedHat [another Linux OS] onto this machine without partitioning. The problem is the Linux [THIZ] is not a development version. It doesnot has ANY compilers, libraries and not allowing me to install Websphere or Oracle or Sybase. Pls help...

Hi I need some help. I am trying to access the db using JSP through Tomcat webserver. Once my JSP makes connection, the listner dies. The same thing happens with Java program also. I have to restart the listner through services and again i have to run my jsp.I don't know where the problem is...

Hi I need some help. Since this problem is with JDBC-JAVA-Oracle, I posted here. I am trying to access the db using JSP through Tomcat webserver. Once my JSP makes connection, the listner dies. The same thing happens with Java program also. I have to restart the listner through services and...

Hi I have installed Oracle-9i. But I could not see the Sample Databases like HR, OR, etc. How can I install the sample databases. I tried to install that by running in sql*Plus. [hr_main.sql file through sql*Plus]. I could not succeed. I tried with Database Configuration Assistant. I followed...

Hi I have installed db2 on my win-2k. The problem is I cannot go to datawarehouse database. It asks me the login user-id and password and I have forgotten the login details.Is there anyway of getting into it [or reinstalling the db2 again, which is the last resort]. thanks in advance Partha...

Hi, I need some help. It is regarding the C-compiler. Whenever I type cc on my linux system it says cc-bad command. How can I identify that my system has C-compiler[if not where can I download]. I was assuming that it will come with the OS. I am using THIZ-Linux. Thanks P Parthasarathy