ORA-12541:TNS:No Listener
When I want to open the global database from ‘the Oracle Enterprise Manager Console Standalone’ menu in Oracle 9i, then the ‘ORA-12541:TNS:No Listener’ message occurs. It can’t open the database. It also needs the user id & password. What should I do? Moderator Note: This is a submitted question
Answer Question
| July 16, 2009 1:13 PM
ORA-12541, Oracle 9i, Oracle 9i error messages, Oracle Enterprise Manager
When I want to open the global database from ‘the Oracle Enterprise Manager Console Standalone’ menu in Oracle 9i, then the ‘ORA-12541:TNS:No Listener’ message occurs. It can’t open the database. It also needs the user id & password. What should I do? Moderator Note: This is a submitted question
Answer Question
| July 16, 2009 1:13 PM
ORA-12541, Oracle 9i, Oracle 9i error messages, Oracle Enterprise Manager
import from excel to oracle 9i
how can i import data from excel to oracle 9i?
Answer Question
| September 4, 2009 7:45 AM
Microsoft Excel, Microsoft Excel import/export, Oracle 9i, Oracle 9i import/export
how can i import data from excel to oracle 9i?
Answer Question
| September 4, 2009 7:45 AM
Microsoft Excel, Microsoft Excel import/export, Oracle 9i, Oracle 9i import/export
Oracle reports installation in 9i
How do I install oracle reports in Oracle 9
Answer Question
| July 8, 2009 2:26 PM
Oracle 9i, Oracle Reports, Oracle Reports 9i
How do I install oracle reports in Oracle 9
Answer Question
| July 8, 2009 2:26 PM
Oracle 9i, Oracle Reports, Oracle Reports 9i
problem in create connection from forms 6i to oracle 9i on the same machine
i installed oracle 9i on a machine succesfuly then i installed forms 6i on the same machine what can i do to connect from forms to oracle
Answer Question
| July 6, 2009 7:43 PM
Oracle 9i, Oracle development, Oracle Forms 6i
i installed oracle 9i on a machine succesfuly then i installed forms 6i on the same machine what can i do to connect from forms to oracle
Answer Question
| July 6, 2009 7:43 PM
Oracle 9i, Oracle development, Oracle Forms 6i
convert excel to oracle 9i?
how can i convert data excel to oracle 9i?
Answer Question
| June 25, 2009 6:37 AM
Microsoft Excel, Oracle 9i, Oracle import/export
how can i convert data excel to oracle 9i?
Answer Question
| June 25, 2009 6:37 AM
Microsoft Excel, Oracle 9i, Oracle import/export
I am not getting source of oracle.I searched a lot but was not able to get it from anywhere.Plz help me.
And also what’s the difference between oracle9i/10g/11g. Or if not wrong they are different versions only
Answer Question
| June 25, 2009 1:19 PM
Oracle 10g, Oracle 11g, Oracle 9i, Oracle Database
And also what’s the difference between oracle9i/10g/11g. Or if not wrong they are different versions only
Answer Question
| June 25, 2009 1:19 PM
Oracle 10g, Oracle 11g, Oracle 9i, Oracle Database
Storing image in Oracle 9i
how to store and retrieve image having size more than 1 GB in oracle 9i
Answer Question
| June 15, 2009 11:30 AM
BLOB, Oracle 9i, Oracle image storage
how to store and retrieve image having size more than 1 GB in oracle 9i
Answer Question
| June 15, 2009 11:30 AM
BLOB, Oracle 9i, Oracle image storage
Send alert via email/SMS with Oracle 9i & Oracle Forms 6i
Hi! I am using an application ,form6 as front end and oracle9i as back end. I want to sent alerts to the superiors as automail when certain data reaches the thresh hold and sent sms using certain service provider API ,to customer when certain condition is satisfied in the database. Kindly guide me how I [...]
Answer Question
| October 24, 2009 7:45 AM
Oracle 9i, Oracle alerts, Oracle Forms 6i
Hi! I am using an application ,form6 as front end and oracle9i as back end. I want to sent alerts to the superiors as automail when certain data reaches the thresh hold and sent sms using certain service provider API ,to customer when certain condition is satisfied in the database. Kindly guide me how I [...]
Answer Question
| October 24, 2009 7:45 AM
Oracle 9i, Oracle alerts, Oracle Forms 6i
Oracle RR Date Format
TELL ME ABOUT RR DATE FORMAT IN ORACLE9I(SQL)
Answer Question
| August 9, 2011 8:43 AM
Oracle 9i, Oracle RR date format, SQL
TELL ME ABOUT RR DATE FORMAT IN ORACLE9I(SQL)
Answer Question
| August 9, 2011 8:43 AM
Oracle 9i, Oracle RR date format, SQL
Escalation module with Oracle 9i and Oracle Forms 6i
we are developing customer care software working on Escalation Module.Here my system should genrate an email to executive or techical head if complain doesn’t get resolved within 3-hrs.i am using oracle 9i and forms 6i as frontend.i hv two points to be disscussed. 1). if complain occur at 10.00 am,so it should resolved by 1.00 [...]
Answer Question
| May 23, 2009 11:43 AM
Oracle 9i, Oracle developers, Oracle Forms 6i
we are developing customer care software working on Escalation Module.Here my system should genrate an email to executive or techical head if complain doesn’t get resolved within 3-hrs.i am using oracle 9i and forms 6i as frontend.i hv two points to be disscussed. 1). if complain occur at 10.00 am,so it should resolved by 1.00 [...]
Answer Question
| May 23, 2009 11:43 AM
Oracle 9i, Oracle developers, Oracle Forms 6i
Extracting data from multiple tables in Oracle 9i
I HAVE 18 TABLES AND I NEED TO EXTRACT DATA FROM THESE TABLES AND STORE IT IN A SINGLE TABLE..THE PROBLEM I S THAT THESE TABLES DO NOT HAVE ANY COMMON FEILDS AND A SINGLE PRIMARY KEY. PRESENCE OF REDUNDANT DATA IS VERY MUCH . HOW TO COME OUT WITH THIS. I AM USING ORACLE9I [...]
Answer Question
| May 19, 2009 6:56 AM
Oracle 9i, Oracle administration
I HAVE 18 TABLES AND I NEED TO EXTRACT DATA FROM THESE TABLES AND STORE IT IN A SINGLE TABLE..THE PROBLEM I S THAT THESE TABLES DO NOT HAVE ANY COMMON FEILDS AND A SINGLE PRIMARY KEY. PRESENCE OF REDUNDANT DATA IS VERY MUCH . HOW TO COME OUT WITH THIS. I AM USING ORACLE9I [...]
Answer Question
| May 19, 2009 6:56 AM
Oracle 9i, Oracle administration
Calculate time difference with Oracle 9i
1)i wanna calculate difference between current time and time which is stored in table. how will i calculate the difference between 2 time?? 2) after calculating this difference ,if this difference is greater than 3 hrs my system should genrate an email to technical head. how do i do this?shall i go for any trigger?if [...]
Answer Question
| February 29, 2012 11:50 AM
Oracle 9i, Oracle development, Oracle Forms 6i, Oracle triggers
1)i wanna calculate difference between current time and time which is stored in table. how will i calculate the difference between 2 time?? 2) after calculating this difference ,if this difference is greater than 3 hrs my system should genrate an email to technical head. how do i do this?shall i go for any trigger?if [...]
Answer Question
| February 29, 2012 11:50 AM
Oracle 9i, Oracle development, Oracle Forms 6i, Oracle triggers
Size of temp tablespace in Oracle 9i
We have a temporary tablespace in Oracle 9i. The temp datafile shows 0 bytes as its storage. But on D:ORACLEORADATAORCLTEMP01.DBF, (where this file is stored), the size of this file is shown as 1.2 MB. Is there any reason for this? Moderator Note: This is a submitted question
Answer Question
| May 15, 2009 8:27 PM
Oracle 9i, Oracle administration, Temp Tablespace
We have a temporary tablespace in Oracle 9i. The temp datafile shows 0 bytes as its storage. But on D:ORACLEORADATAORCLTEMP01.DBF, (where this file is stored), the size of this file is shown as 1.2 MB. Is there any reason for this? Moderator Note: This is a submitted question
Answer Question
| May 15, 2009 8:27 PM
Oracle 9i, Oracle administration, Temp Tablespace
Oracle 9i
We had installed Oracle 9i and on AIX and then installed our front end application, now we want the oracle to have pro*c option. Is there any patch available to just install pro*c option rather than reinstalling oracle and selecting pro*c during installation. We cannot risk reinstalling oracle as it may affect our application. Please [...]
Answer Question
| May 12, 2009 1:51 PM
AIX, Oracle 9i, Oracle installation
We had installed Oracle 9i and on AIX and then installed our front end application, now we want the oracle to have pro*c option. Is there any patch available to just install pro*c option rather than reinstalling oracle and selecting pro*c during installation. We cannot risk reinstalling oracle as it may affect our application. Please [...]
Answer Question
| May 12, 2009 1:51 PM
AIX, Oracle 9i, Oracle installation
Oracle OMS – Please Help
i’m expert on SQL Server, but new to Oracle world. the oracle is installed on Windows 2000, if i need to do anything (backup, creation of new Shema, importing data…)it gives me that i have to use OMS . i found that OMS needs sysman user, or after searching i found that this username doesn’t [...]
Answer Question
| May 12, 2009 3:18 PM
OMS (Oracle Management Server), Oracle 9i, Oracle Management Server, SQL Server, SYSMAN, Windows Server 2000
i’m expert on SQL Server, but new to Oracle world. the oracle is installed on Windows 2000, if i need to do anything (backup, creation of new Shema, importing data…)it gives me that i have to use OMS . i found that OMS needs sysman user, or after searching i found that this username doesn’t [...]
Answer Question
| May 12, 2009 3:18 PM
OMS (Oracle Management Server), Oracle 9i, Oracle Management Server, SQL Server, SYSMAN, Windows Server 2000
OEM
can i manage oracle 10 instances using the 9i oem?
Answer Question
| May 4, 2009 7:55 PM
OEM, Oracle 10g, Oracle 9i, Oracle Enterprise Manager
can i manage oracle 10 instances using the 9i oem?
Answer Question
| May 4, 2009 7:55 PM
OEM, Oracle 10g, Oracle 9i, Oracle Enterprise Manager
Is the Oracle client 9 compatible with Forms 6i
We have a conflict between windows 2003, citrix and oracle forms 6i and have over come this by installing client 9.2.0.1.0 however I don’t believe this is a supported combination and need to know what problems we may encounter
Answer Question
| April 24, 2009 10:47 AM
Citrix, Oracle, Oracle 9i, Oracle Forms, Oracle Forms 6i, Windows Server 2003
We have a conflict between windows 2003, citrix and oracle forms 6i and have over come this by installing client 9.2.0.1.0 however I don’t believe this is a supported combination and need to know what problems we may encounter
Answer Question
| April 24, 2009 10:47 AM
Citrix, Oracle, Oracle 9i, Oracle Forms, Oracle Forms 6i, Windows Server 2003
Would like to upgrade to 10.2.0.4 from 9.2.0.7
Ihave 3 test databases on Tru64 and I would like to install 10.2.0.4 and upgrade only one database. How do I do that? Once the testing is sucessful I will then upgrade other 2 test databases and then production database. Your step by step instructions will be appreciated Thanks
Answer Question
| April 22, 2009 5:55 PM
Oracle 10g, Oracle 9i, Oracle Database, Oracle upgrades, Tru64
Ihave 3 test databases on Tru64 and I would like to install 10.2.0.4 and upgrade only one database. How do I do that? Once the testing is sucessful I will then upgrade other 2 test databases and then production database. Your step by step instructions will be appreciated Thanks
Answer Question
| April 22, 2009 5:55 PM
Oracle 10g, Oracle 9i, Oracle Database, Oracle upgrades, Tru64
How to config iSQL Plus on computer without a domain
Hello I have Oracle 9i installed in my home computer and i want to work in iSql Plus, but i am not able to do it. I tried running the apache server but then when i tried to login i get a error message “The server encountered an internal error or misconfiguration and was unable [...]
Answer Question
| April 20, 2009 3:32 AM
isql, iSQL*Plus, Oracle, Oracle 9i, SQL, SQL Plus
Hello I have Oracle 9i installed in my home computer and i want to work in iSql Plus, but i am not able to do it. I tried running the apache server but then when i tried to login i get a error message “The server encountered an internal error or misconfiguration and was unable [...]
Answer Question
| April 20, 2009 3:32 AM
isql, iSQL*Plus, Oracle, Oracle 9i, SQL, SQL Plus
log sql queries?
queries seem get mangled by our report writer middleware; I’d like to see the actual SQL received by Oracle9i from a particular user. how?
Answer Question
| April 17, 2009 5:14 PM
Oracle 9i, SQL queries, SQL Server logs
queries seem get mangled by our report writer middleware; I’d like to see the actual SQL received by Oracle9i from a particular user. how?
Answer Question
| April 17, 2009 5:14 PM
Oracle 9i, SQL queries, SQL Server logs
