ERPstuff - Oracle EBS Community

SQL> select count(1)
2 from dual;

COUNT(1)
----------
1

Because there's just one column and one row that's why you'll always get 1. Here's what inside the DUAL table.

SQL> select * from dual;

D
-
X

Regards
Amir

Hi there Sorry for the late reply. I don't see any reason to use LONG data type in 10g database! Oracle strongly recommend to use and convert existing data to the LOB data types (BFILE) in 10g, it exists only for backward compatibility. A BFILE column or attribute stores a file locator that points t...

Hello

Please paste your "dbora: script here, so we could look into it.

Regards

Amir

Hi

What's Forms applets response code, could you paste whatever the Forms Application Log reports.

Regards

Amir

I would check the System and Application log from Event viewer. What's causing Windows Server to be crashed.

Regards
Amir

Please let us know more detail, at which step your OS got crashed?

Regards
Amir

Hi there Here are few ways to monitor open cursors, that'll give you some idea. To monitor open cursors, query v$sesstat where name='opened cursors current'. This will give the number of currently opened cursors, by session: --total cursors open, by session select a.value, s.username, s.sid, s.seria...

Hi there It could be described as, in the HOT backup you don't need to shutdown the database (mostly preferred for PROD database). The RMAN and some other third party backup solutions using RMAN scripts in the background are used for that purpose. In the cold backup you just need to shutdown the dat...

Hi Kashif

Here's a super fast way to clone oracle database.

http://www.dba-oracle.com/oracle_tips_db_copy.htm

Let's know how it goes.

Have fun.

Amir

Hi

I don't think so, oracle will get confused with the same global name (i.e mydb.abc.com) in a network. But if it's different domain then there's no harm to create it. Like "mydb.abc.com" and "mydb.xyz.com".

Amir

Hi

Please run that script individually as suggested earlier and let us know the result.

Regards

Amir

Hi

They are not icon but mounting point directories. All file system has to be mounted before it's used in Linux. Whenever you plug-in USB, OS creates a directory on your desktop and mount USB in to that directory.

Hope that's answer your question.

Regards

Amir

Hi

I would try running that script manually from shell prompt after setting up ORA env variables without passing any arguments:

. oraenv

$ORACLE_HOME/bin/dbstart

$ORACLE_HOME/bin/dbshut

Let's figure out first, which script is causing error.

Regards

Amir

Hi there Please always mention the database version in your question. Here's a solution for Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 10.1.0.3: The DB server software provides the two scripts to configure automatic DB startup/shutdown with the server machine. They are $ORACLE_HOME/bin...

Hello To know what OS is certified with which product we use Oracle certification matrix. The OS CentOS is based on Red Hat Enterprise Linux. I verified from metalink as it's showing result below: Red Hat Enterprise Linux AS/ES 2.1 8.1.7 (8i) It means only CentOS 2.1 is certified with 8i. BTW I succ...