PL/SQL :: Creating PSP Reports In Oracle Database 10gr2?

Feb 6, 2013

I want to create the .psp(pl/sql ser pages) reports in the oracle database 10gr2.but i am unable to do it why because it needs http server(knew by going through some of the oracle docs but not able to understand) where i find this first of all details configuration needed for the .psp files.

View 8 Replies


ADVERTISEMENT

Oracle 10gR2 - OEM Database Control Configured For DBs

Jul 24, 2013

 I have multiple oracle (10gR2) databases running on a linux (5.8) server. How can I check that for which of the databases has the OEM Database Control been configured and on what port is it listening?

View 7 Replies View Related

Oracle Database Migration From 9iR2 / 10gR2 To 11gR2

Apr 22, 2013

Which is the best method for migration of database from Oracle 9iR2,10gR2 to 11gR2.

Current Environment
Server1
Operating System: Sun OS 5.10
Oracle Database: Oracle Database Enterprise Edition 9.2.0.8 (32 bit)
Average Db Size: 600Gb
RAc Configuration: No
Server2
Operating System: Sun OS 5.10
Oracle Database: Oracle Database Enterprise Edition 10.2.0.3 (64 bit)
Average Db Size: 600Gb
RAC Configuration: No

Proposed Environment
Server1 and Server2
Operating System: Sun Solaris 10
Oracle Database: Oracle Database Enterprise Edition 11.2.0.3 (64 bit)
RAC Configuration: No
Hardware is New : Yes

View 2 Replies View Related

RAC/ASM Clusterware Installation :: OEM Grid Control Files For Oracle Database 10gR2

Jan 22, 2013

I am trying to setup my environment to prepare for hands on DBA exercises from an OCM handbook for 10g -OCM:Oracle Database 10g Administrator Certified Master Exam Guide

I need access to the following files
gc_10205_part1of2.zip, gc_10205_part2of2.zip for 32 bit linux

Apparently the above along with other Grid software was once attainable from the link below but sometime between this year and the last Oracle decided to remove this and other software from public access. URL.....

I doubt Oracle will hear my plea - educational purposes only - so given I want access to the software only.

View 2 Replies View Related

Client Tools :: Oracle 10gR2 Database Server - Unable To Use Isqlplus?

Apr 11, 2007

I have installed Oracle 10gR2 database server recently in the Windows box. The database works fine. But I am unable to connect through the Internet Explorer. I found that the service for the isqlplus is not available. Do I need to run any script for creating the service?

View 12 Replies View Related

Reports & Discoverer :: Provide Download Link To Blob In Database On Oracle Reports?

Aug 8, 2013

My user would like to have a way to attach files to database records. For simplicity, we'll say that each employee in the database could have 0-many file attachments associated with them. I know how to make this part work using Oracle Forms.

So that's the easy part for me. The tough part is that they want to be able to run an Oracle Report on our application server (displays as a PDF, also downloadable as a PDF) and have links on this report to the attachments that they uploaded using the forms process above.

For the idea of storing the files on a folder somewhere, I simply created a text object on the report that had it's hyperlink property pointing to the file location. Done.. opens fine.

However, I want to be able to have the option of storing these files in the database instead, just in case we can't go with the shared folder idea. I'm not sure how to make this work. I can store a blob in the database.. but how do I link to that blob on the report for them to be able to download it? Is this even possible?

how to create a download link on the Oracle Report that let's them download a file out of the database.

View 5 Replies View Related

Database Upgrade From 9.2.0.8 To 10gR2

Oct 26, 2012

Why is knowing the backup policy important before starting any upgrade.

View 17 Replies View Related

Creating Database Link Between Oracle And Sqlserver?

Jun 6, 2013

I would like to create a view on the Oracle which points to SQLserver tables.

oracle db version : 10g

sql server version :sql server 2008 R2

View 2 Replies View Related

Windows :: Oracle 10g - Creating New Database / DBCA?

Jun 15, 2011

when i am trying to create a new database in oracle 10 g in my local system when creating database error shows a number 146 no other error is showing what must be the reason.

View 14 Replies View Related

Server Administration :: Creating New Database In Oracle?

Nov 10, 2010

how to create a new database in oracle??

View 2 Replies View Related

Security :: Creating Oracle Database Connection

Feb 26, 2013

Just installed the new 2.0.8 version. Its been a while I am interested on using PM for our company.The problem I have is creating an Oracle DB connection. When I create a new Oracle DB connection, and test it, Steps 3 and 4 fail.What is strange is that I followed the following procedure in PM 1.9-825 and worked fine. I am wondering if something changed in the new PM 2.0.8 version (I noticed that php_oci8.dll was commented out in php.ini).

Oracle Version is 10GR2
PM installed on clean XP sp3

1. Got a new Windows XP SP3 PC
2. Installed PM 2.0.8
3. Edited php.ini and uncommented [PHP_OCI8] and extension=php_oci8.dll
4. Installed oracle instant client “instantclient-basic-win32-10.2.0.5” in c:oracle
5. Installed oracle instant client “instantclient-sqlplus-win32-10.2.0.4” in c:oracle
6. Added c:oracle in PATH environment variable
7. Created ORACLE_HOME = c:oracle environment variable
8. Added TNS_ADMIN = c: environment variable
9. Copied working tnsnames.ora file into c:
10. Rebooted.
-------------------------------------
1. Tried sqlplus connection to my oracle db and worked.
2. Launched PM
3. Created a new process
4. Created a new DB connection as follows:
a. Engine:Oracle
b. Server:192.168.xxx.xxx
c. Database name: my_name (where my_name appears in tns_names.ora)
d. Username:my_username
e. Password:my_password
[code]....

View 1 Replies View Related

SQL & PL/SQL :: Creating Oracle Database To Support Chinese Fonts

Aug 21, 2012

mentioned database is created with Character set = UTF8 and the National Character Set = AL16UTF16 and got the result for other languages (latin,german,french etc) but still Chinese language was not supported.

NLS_CHARACTERSETAL32UTF8
NLS_NCHAR_CHARACTERSETAL16UTF16

I was getting the output as given below-

SQL> select translator ('table and chair','zh-CN','en') English_to_chinese from dual ;

ENGLISH_TO_chinese
--------------------------------------------------------------------------------
┐┐┐┐┐

and the function is given below

/* Formatted on 16/08/2012 21:55:39 (QP5 v5.215.12089.38647) */
CREATE OR REPLACE FUNCTION translator (p_words IN CLOB, -- words to be translated
p_to IN VARCHAR2, -- language to translate to

[Code].....

View 15 Replies View Related

RAC & Failsafe :: Upgrade Database With ASM Storage From 10gR2 To 11gR2?

Mar 7, 2011

I have a database running on 10205 version. It is a RAC database with ASM storage.

I want to migrate this database to other server and upgrade this database to 11202 version .

View 1 Replies View Related

Upgrade :: From Linux 32bit To 64bit - 10gR2 Database?

Dec 26, 2012

I need to do the following:

(1) Move my 10gR2 database from 32-bit Linux to 11gR2 64-Bit Linux (using an RMAN backup from 10gR2 restored on the 64-bit machine) then

(2) Bring up the database on 64-bit hardware and then upgrade to 11.2.0.3 (64-Bit) [Without installing the 10.2.0.3 64-Bit software]

Haven't tried restoring to 11.2.0.3 from a RMAN 10.2.0.3 backup. I was trying not to have to install the Oracle 10.2.0.3 software for 64-bit on the 64-bit machine. Was hoping to go directly to 11.2.0.3 (64-bit).

View 2 Replies View Related

Server Administration :: Error Creating Database Using DBCA Oracle 11g R2?

Nov 18, 2010

This is on a vmware virtual server on Windows 2008R2 using ORACLE 11g R2 with patch set 6

I installed ORACLE (software only) and applied patch set 6 and tried to create a new database.

during the database creation I got an error as the system was adding the JVM that read:-

ORA-01927:cannot REVOKE privileges you did not grant.

I was given the options to ignore or abort

I chose to ignore the error and continue.

After the database creation completed I looked in the jserver log copied below and found two errors

I did not get the same error before installing patch set 6

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
No errors.
alter system flush shared_pool
drop role javauserpriv

[Code].....

View 2 Replies View Related

Server Administration :: Installed 10gr2 And Implemented 3GB - Database Hang?

Jan 26, 2010

My server RAM is 12GB. i installed 10gr2 and implemented /3GB also. Eventhough my database is giving problem.

View 20 Replies View Related

Oracle DB 10gR2 Installation

Jul 8, 2011

I try to install th a oracle 10gR2 database to a SuSe Linux 11.4.

I try to install to tha local machine, not to a remote host. But when I start the installation every time I get the next error message:

CODECan't connect to X11 window server using '' as the value of the DISPLAY variable.

Unable to start an interactive install session because of the following error:Can't connect to X11 window server using '' as the value of the DISPLAY variable. The DISPLAY environment variable should be set to <hostname or IP address>:<screen>, where the <screen> is usually '0.0'.

Depending on the Unix Shell, you can use one of the following commands as examples to set the DISPLAY environment variable:

- For csh: % setenv DISPLAY 192.168.1.128:0.0
- For sh, ksh and bash: $ DISPLAY=192.168.1.128:0.0; export DISPLAY

Use the following command to see what shell is being used:

echo $SHELL
Use the following command to view the current DISPLAY environment variable setting:
echo $DISPLAY

- Make sure that client users are authorized to connect to the X Server. To enable client users to access the X Server, open an xterm, dtterm or xconsole as the user that started the session and type the following command:

% xhost +
To test that the DISPLAY environment variable is set correctly, run a X11 basedprogram that comes with the native operating system such as 'xclock':
% <full path to xclock... see below>

If you are not able to run xclock successfully, please refer to your PC-X Server or OS vendor for further assistance. Typical path for 'xclock': ''

I think that I don't need the x server when I install the product to the local machine. But every time I get this message.

View 6 Replies View Related

Download Full Oracle 10gR2 Documentation?

Nov 3, 2010

want to download full oracle 10gR2 documentation. I also navigated on [URL] but this link allowing me to download pdf one by one but I want to download all pdf's in single shot.

View 2 Replies View Related

Oracle 10gR2 Installation Failed On SLES10

Jul 15, 2008

While installing Oracle10gR2 on zlinux machine where the OS is SLES10 SP1 I got this error

In installActions2008-07-15_04-37-15PM.log

INFO: /usr/lib64/gcc/s390x-suse-linux/4.1.2/../../../../s390x-suse-linux/bin/ld: skipping incompatible /opt/oracle/10g/lib/stubs/libdl.so when searching for -ldl
/usr/lib64/gcc/s390x-suse-linux/4.1.2/../../../../s390x-suse-linux/bin/ld: skipping incompatible /opt/oracle/10g/lib/stubs/libm.so when searching for -lm

[Code]....

View 1 Replies View Related

Forms :: Migrating Oracle 10gr2 From Windows To Linux

Feb 10, 2010

We are planning to migrate the forms application from windows to linux.

View 1 Replies View Related

Server Administration :: Migration Of Oracle 10gR2 To 11gR2?

Jun 23, 2010

I am migrating an oracle 10g to 11gR2. i am a bit confused. The developers in my work place have a tablespace for storing table and a different tablespace for storing indexes.

For the migration i am using exp and imp. My question is how i am going to migrate the indexes from 10g to 11gR2?

OS; solaris sparc 10

Oracle 10g: 10.2.0.1.0

oracle 11g: 11.2.0.1.0

View 1 Replies View Related

Installation :: Oracle 10gR2 For Windows 7 64bit Processor?

Jul 10, 2012

I need to download Oracle 10g R2 for windows7 64bit processor. send the link

View 4 Replies View Related

Migrate From Oracle 10gR2 In Windows To 11gR2 In Linux

Jun 22, 2012

Question: to migrate from oracle 10gR2 in Windows to oracle 11gR2 in Linux . Steps are:

1.     need to expdp all schemas/users from oracle 10gR2 in Windows,
2.     then impdp each schema/user into oracle 10gR2 in Linux first,
3.     then upgrade the oracle 10gR2 in Linux to oracle 11gR2 in Linux ?
4.     Do I need to pre-create all the same tablespaces first in oracle 10gR2 in Linux ?

Is it correct ? or I can migrate straight all schemas/users from oracle 10gR2 in Windows to oracle 11gR2 in Linux using impdp ?

View 5 Replies View Related

How To Download Oracle 10gR2 To Windows 2008 Server R2

Jun 27, 2012

I'm trying to download Oracle RDBMS 10.2.0.5 for Windows Server 2008 R2. But i don't see it on OTN or edelivery....i can't find any link...Have i to request a SR on metalink?

View 2 Replies View Related

Server Administration :: Oracle 10gR2 RAC - Moving Archivelog Location

May 25, 2010

We have oracle 10gR2 RAC with ASM running on HP-UX. The archivelogs are located in a NFS filesystem and we want to move this into ASM.

View 1 Replies View Related

Server Administration :: Automated Shell Script For Renaming Oracle DB 10gR2

Nov 8, 2011

Provide automated shell script for renaming oracle DB 10gR2. Now it is a daily manual job for us.

View 4 Replies View Related

Reports & Discoverer :: Creating Excel (because Of CHR(44))?

Oct 6, 2010

I creating a report in excel format...But there is one problem which i shown in colour when excel created.... i dont know why this problem come..Here i m attched my .fmb file and excel sheet [When i run my form].....

My Code is :
When Excel Button pressed
PROCEDURE EXCEL_P IS
cursor c1 is
select distinct BPT_DOC_DT BNP_REF_DT, BPT_DOC_NO BNP_REF_NO,
BPT_VEN_NM Vendor_Name,
BPT_BIL_NO Bill_No, BPT_BIL_DT Bill_Date ,

[code]...

View 26 Replies View Related

Oracle Forms 6i And Oracle DB 10gR2 Or 11

Jul 8, 2011

I am working on an application which is on Oracle forms and Reports 6i.It connects to a database which is Oracle 9i. My client wants to upgrade the Database to Oracle 10gR2 or Oracle 11g. I searched in many forums and also saw in Interoperability table which says it is not compatible. But some users are using it fine.

View 1 Replies View Related

Install Multiple Versions Of Oracle Databases 10GR2 And 11GR2 In A Single Node?

Oct 28, 2010

ORACLE DBA
EXPERTS

�I can install multiple versions of Oracle databases 10GR2 and 11GR2 in a single node using a unique Oracle ASM single instance?

View 6 Replies View Related

Server Administration :: Write Bangla Language In Oracle 10gR1 / 10gR2 And Express

May 17, 2012

I tried more to write Bangla in Oracle 10gR1, or 10gR2 or Express but failed. When I write bangla in the "emp_name" field for employee name this can be save, But when I execute to see the data again then the data comes with a big change like some symbol for some character.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved