Installed Oracle11g - How To Build Demo

Jul 28, 2010

I installed oracle11g on my computer ,when im going to build demo its not working.its giving a error like this.

sys>conn u1/u1
error accesing PRODUCT_USER_PROFILE
warning product user profile information not loaded
you may need to run PUPBLD.SQL AS SYSTEM
connected
u1>@?/sqlplus/demo/demobld unable to open file "/oraeng/app/oracle/product/11.1.0/sqlplus/demo/demobld.sql"

View 1 Replies


ADVERTISEMENT

Precompilers, OCI & OCCI :: Demo Directory To Connect Database

Nov 30, 2008

i used example in demo directory to connect Database.I used "ansidyn1" example. But i can connect to my DB.I have just modified oracle_connect in sample code(in ansidyn1.pc),follow it:

EXEC SQL BEGIN DECLARE SECTION;
VARCHAR username[128];
VARCHAR password[32];
char DB_NAME[30] = "servertest";
char db_string[20]= "vitcendb";
EXEC SQL END DECLARE SECTION;
[code]....

i compiled in in VC6++(using ansidyn.dsp) but cant connect to DB.

View 1 Replies View Related

How To Get QPS Or TPS Of Oracle11g

Jul 25, 2013

My boss told me he wanted to know the QPS(Query Per Second) and TPS(Transaction Per Second) of current Oracle Database. The version is 11.2.0.3.    I found the TPS in the section of Load Profile of AWR report. But how can I get the QPS? I have the OEM12C. If it can provide the info, which page?

View 5 Replies View Related

Sqlnet.ora Not Found For Oracle11g

May 2, 2013

Actually I have to modify set SQLNET.INBOUND_CONNECT_TIMEOUT,TRACE_LEVEL_CLIENT in SQL net .ora . But I cant fine that file in $ORACLE_ HOME /network/admin directory.

But I found this other files like listener.ora and tnsname.ora in the same directory.

When I give sho parameter nalue in listener prompt it shows some values. Is it showing default values without sqlnet file (is it fauture of Oracle11g).

View 12 Replies View Related

Server Utilities :: Downgrade From Oracle11g To 9i Via Exp / Imp?

Dec 28, 2010

I want to downgrade my database from Oracle 11g (11.2.0.1.0) to Oracle 9i (9.2.0.1.0).

I've done trial of taking export of higher version(Oracle11g) through lower version(Oracle9i) exp utility and trying to import same exp.dmp files into lower version(Oracle9i), but not succeeded and getting some parameter related error.

On Oracle9i database client- Here i'm connecting to Oracle11g via use of 'wbdata.wbh-db1' service

[oracle1@WBDevelop smbshare]$ exp lab/lab@wbdata.wbh-db1
Export: Release 9.2.0.1.0 - Production on Tue Dec 28 15:45:32 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Enter array fetch buffer size: 4096 >

[code].....

On Oracle9i database client - Here i'm importing the lab.dmp

(Export taken from Oracle11g via use of 'wbdata.wbh-db1' service)
[oracle1@WBDevelop smbshare]$ imp lab/lab
Import: Release 9.2.0.1.0 - Production on Tue Dec 28 15:49:51 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

[code].....

View 13 Replies View Related

Oracle11g R1 Grid Control Installation Error

Apr 18, 2011

In Oracle 11g grid control installation error OMS configuration failed:

DB s/w: Oracle DataBase 11g R2

OS : Windows Xp sp2

Grid s/w: Oracle 11g Grid Control R1

Weblogic Server : wls 10.3.4.0

As i did follow the oracle 11g grid control basic installation guide. i got error in oms configuration stage ....

Apr 18, 2011 7:28:58 PM oracle.sysman.omsca.adapter.wls.OMSWLSAdapter adapterDeleteOMS
FINE: Done Executing the command...0
Apr 18, 2011 7:28:58 PM oracle.sysman.omsca.framework.OMSGenericAdapter deleteAddOnInventory
INFO: Invoking deleteAddOnInventory for oms null
Apr 18, 2011 7:28:58 PM oracle.sysman.omsca.adapter.wls.OMSWLSAdapter adapterDeleteOMS
FINE: Stopping WebTier

[code]....

View 2 Replies View Related

Security :: Oracle11g Express - Default Role For User?

Oct 4, 2012

I switch to Oracle11g express and create user

CREATE USER LEO
IDENTIFIED BY xy
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT

[code]...

and after login i check
select * from SESSION_ROLES

and i have none role if I set role all works fine. Why I doesn't have DEFAULT ROLE after login.

View 1 Replies View Related

Heterogeneous Connectivity :: Database Link Between Oracle11g Express Edition And MySQL using Odbc

Nov 8, 2012

I am using oracle 11g express edition and MY Sql database How to establish database link between them using ODBC gateway. I am using ODBC gateway Mysqlodbc connector.

View 1 Replies View Related

PL/SQL :: Sql Query To Build Average Value

Jul 18, 2013

I'm trying to build a query capture the below information. Table looks something like below . 

RoomSubjectStudentsA1Science10A1Maths20B1Science15B2English25C1Deutsch20A1French15C1English10 

How can i write a query so that i takes the average of students in each room and display the output? I need to write a query so that it also picks up any new rooms and students added.  Average is sum of total students in room by number of times each room is specified.  

eg: A1 is listed 3 times a the result would be 10+20+15 divided by 3.    

A1    B1    B2    C115    15    20    15 

View 7 Replies View Related

Execute Immediate To Dynamically Build A Trigger?

Apr 25, 2011

We have developed a code which builds a trigger on a atble dynamically at run time usinf Dynamic SQL command Execute immediate.

create or replace
PROCEDURE GENERATE_TRIGGER
(
P_TNAME IN VARCHAR2

[Code].....

I am not usre if the error is due to insufficient privileges as we are able to build tabl;e in the system dynamically using the above mentioned command.

View 1 Replies View Related

Build Database From Backup Files

Aug 3, 2011

I am an absolute neophyte at this. I'm fairly good at SQL, but have not administrated a database before.

I am trying to take a backup from our production database and restore it to a fresh install of Oracle 10.2 on a Windows 2003 server using RMAN - but I am not getting very far. Software versions are all the same. I have access to the manuals, but it seems like every link I follow adds more questions than it answers.

I have gone through the wizard and set up oracle on the new box - that all seemed to go smoothly. In order for this to work, do I need to set up the database with the same DBID as the one in the backup files? Or is there a way to import the data from the backup and have it build the database from those files?

I'm not sure I'm even asking the right questions. Do any of y'all know of a tutorial that would walk me through this process step by step?

View 4 Replies View Related

Dynamically Build (recursive) Xml SQL Statement

May 3, 2013

We have an requirement to create xml data for entire database (selected tables) which are in hierarchy.Procedure should read node_mapping table having parent and child tables relationship info and build XML Select statement.

Currently it is building SQL statement whenthere are one parent having multiple childrens i.e Dept having emp, emp_act, emp_rsch..but when child node are having childrens then it is not working - it has to repeatedly call this procedure (recursive) and build below given SQL statement.

1. To change procedure to build xml sql statement when there are multiple childrens to child nodes (hierarchy)
2. To format the output in xml data

We are using ORACLE 11G and WINDOWS 7

CREATE TABLE node_mapping
(
NODE_ID NUMBER(5) PRIMARY KEY,
PARENT_NODE VARCHAR2(100),
CHILD_NODE VARCHAR2(100),
PARENT_NODEID VARCHAR2(50),
CHILD_NODEID VARCHAR2(50)
[code]....

View 1 Replies View Related

SQL & PL/SQL :: Dynamically Build SELECT Statement

May 8, 2013

We have an requirement to build (XML) Select statement dynamically based on the mapping table (which is in hierarchy format)

I have removed xml keyword, so query will not work. but need procedure which will recursively check mapping table (parent and child table) and build below given select statement.

Example 1:
SELECT dname,
(select ename,

[Code]....

View 8 Replies View Related

Build And Load Differences Between Dumps?

Jun 19, 2012

we get daily a full dump from our customer. We have to build the differences of tables (deltas) and load them in separate tables.

There some questions, requiremenst and restrictions:

1) Is it possible the merge the dumps ?

2) How to build the differences as the easiest ?

3) The whole process (import, merge, extract) should be run in batch.

4) We have only a solid knowledge and liitle time for doing.

View 1 Replies View Related

SQL & PL/SQL :: Oracle Select Build Table?

Jun 21, 2011

select a default table in oracle as we do in teradata, below is the syntax of teradata.

select 'XXX' as Curr,
'BUS OBJ ' as acq_nm
from (select 1 as one) Union
select 'ALL' as Curr, from (select 1 as one).

so I need the same select in oracle.

View 3 Replies View Related

SQL & PL/SQL :: To Build A Hierarchy And Output It Into A Sub-report

Feb 26, 2010

I want to build a hierarchy and output it into a sub-report. Since the data in few hierarchy fields exceeds 4000 characters and therefore m getting the ORA-01489 error and the entire report was failing.

So i have used user aggregate function to print the out put. I have also used row_number() to print sequence in query output.

the query that i am using is

SELECT pr_id,
REPLACE (REPLACE (twadmin.STRAGG2(distinct RPAD (to_number(curr), 2, ' ') || ')' || NVL (DECODE (medical, NULL, clinical, medical), 'UNKNOWN') || '###' ||
RPAD (' Causality as per rport ', 50, ' ') || ': ' || reporter || '###' ||
RPAD (' Causality as per report2 ', 50, ' ') || ': ' || hospital || '###' ||
RPAD (' Dechallenge', 50, ' ') || ': '|| dechallenge || '###' ||
RPAD (' Rechallenge', 50, ' ') || ': '|| rechallenge), ',', CHR(10)), '###', CHR (10)) causality
[code]......

the output of the query is

ID Causality
-- ------
3755101 )Blisters (Blister)
Causality as per report1: Probable
Causality as per report2: Possible
Dechallenge : Not Applicable
Rechallenge : Not Applicable
2 )Mental status changes (Mental status changes)
[code].......

but the expected out put is

ID Causality
-- ------
3755101 )Blisters (Blister)
Causality as per report1: Probable
Causality as per report2: Possible
Dechallenge : Not Applicable
Rechallenge : Not Applicable
[code]........

but it should be as

1)
2)
3)
..
..
..
10)
11)
12) for the values in the causality field

View 25 Replies View Related

SQL & PL/SQL :: Function To Check Length And Build A String?

Dec 18, 2012

I have created a VIEW with a column containing user-defined aggregated values(stores the output in varchar2 data type). Some of the records exceed the maximum limit, for example varchar2(4000). I was suggested a PL/SQL function to check the length and build a string if necessary..

CREATE OR REPLACE
FUNCTION SUBURL(col1 IN VARCHAR2, col2 IN varchar2)
RETURN varchar2

[Code].....

Here, I got the following error,

Error(4,25): PLS-00103: Encountered the symbol "," when expecting one of the following:
:= . ( @ % ; not null range default character

View 14 Replies View Related

Application Express :: Build A Menu Framework

Jun 27, 2012

I have built a Menu Framework using the following instructions.

[URL]........

I am facing 2 problems.

1. If the user is in a child application and clicks logout. He is taken to the login screen of the master application (Correct), but once he enters login details, he is returned to the child application (False). I think he should be returned to the Home page of the Master application.

2. If I set Session Timeouts in the Edit Security Attributes of the applications. Then if the user is timed out, he is sent to the login screen of the Master application (Correct). If he then logs in, he is sent the the Home page of the Master application (Correct).

Now if he clicks a link to a child application he is then sent back to the Master application login screen. He then has to login again. He is sent to the Master Home page and everything is then ok.

View 1 Replies View Related

Can Oracle 9 / 10 And 11 Be Installed On Same PC

Nov 4, 2010

I have new PC going to be used for Oracle 9, 10 & 11. It has Windows 2008, system processor - Intel® Xeon® CPU, Installed memory 2.00 GB and it is 64-bit operating system. My question is if it is possible to have 3 different versions of Oracle on the same box. I want to make sure that they are not going to create any problem! If it is ok to install all three on the same box then should i start installing from the lowest version (9)?

View 4 Replies View Related

Performance Tuning :: Possible To Build Index Partition In Parallel

Jul 8, 2010

Is it possible to build index partition in parallel?I tried following command

alter index <index_name> rebuild partition <partition name> online parallel 5;

It executed without complaining, but want to know if index partitions can be build in parallel?

View 3 Replies View Related

Forms :: FRM-91500 - Unable To Start / Complete Build

Oct 9, 2009

I am trying to modify an existing form in oracle apps. I copied all the necessary objects and modified the form. I can compile the object in windows. When I am trying to compile the object in Linux server using SSH I am getting the following error.

FRM-91500: Unable to start/complete the build.I am using the following command for compile

f60genm userid=apps/apps batch=yes module= FORMNAME.fmb module_type=form.

View 3 Replies View Related

SQL & PL/SQL :: Build Query To Retrieve Records Between Dates With Same Field?

Mar 17, 2010

i have a doubt in building a query.

I have a table with fields

job_no activity Date
101 anchorage 20/01/2010
102 berthing 25/01/2010
103 sailing 29/01/2010

If i want to know the status of the ship on the date '22/01/2010' It has to show as 'anchorage', becoz on '25/01/2010' only it came to berthing from anchorage. How to write a query to achieve this.

View 12 Replies View Related

Automatic Storage Management :: Build ASM In Linux Box Oracle 11g?

Dec 28, 2012

I have a Linux box with the below configurations:-

Linux blrulvremoradb02 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux

Last time my UNIX administrator have done a partition in this box. I have 100GB lun allocated to this box which is spilitted in two mount points.

/u01 is having 30GB and /u02 is having 70GB. I want to build a ASM in this box and install Oracle 11.2.0.1 and for that I need raw disk.

Is there any useful links or can you guide me to achieve this... My UNIX admin is on leave for new year and I want to do this by my own..

View 5 Replies View Related

Oracle 11g R2 Installed With Zero Bytes On IBM AIX

Dec 27, 2012

I have installed 11g r2 using silent mode. but all the executable like lsnrctl, expdp, sqlldr,impdp etc.... installed with 0 (zero) bytes.

couldn't trace out what the problem is,

View 1 Replies View Related

Forms :: Installed 10g - Not Able To Run Form?

Jan 6, 2011

I installed forms and built a simple form using EMP table.I was able to compile the form successfully but when I run the form it opens IE and says IE has stopped working and closes the program.I have Windows Vista OS and IE7.

View 6 Replies View Related

SQL & PL/SQL :: Build A Stored Procedure Which Compares Specific Fields In 2 Tables

Jul 24, 2013

I have table A.Security:

CouponIssue_nameQuantity_typeCurrencySec_TypeSec_alias
1 a 56 USD AB 676
2 b 45 INR AB 143
3 c 32 JPY BA 200

and Table B.Security:
CouponIssue_nameQuantity_typeCurrencySec_TypeSec_alias
1 a 33 USD OB 676
9 b 21 NZD AC 143
8 c 19 GBP CA 200

build a Stored Proc which compares sepecific fields in the 2 tables and reports into a new table as:

A.Security.sec_aliasB.Security.sec_aliastable fieldA-valueB-value Compare
676 676 Security Currency USD USD Match
143 143 Security Currency INR NZD Not-Match

Fields to be compared are:
Quantity_type
Currency
Sec_type

The join between the tables A and B can be made on Sec_alias.Also, this is just a single pair of tables. Further I need to compare 5 more pairs of tables after this and report out of the new table.

View 23 Replies View Related

Application Express :: How To Build A Button On Click Of Which Opens A List Below It

Jun 29, 2013

I have a requirement wherein onclick of button I want to open/close list/popup (which is displayed below button, just like in select list) and can select any item from list to do some action. 

View 7 Replies View Related

SQL & PL/SQL :: Build Parametric Queries - Input Date Field At Run-time

Aug 24, 2012

When working in MS Access, I can build parametric queries, where I can input the date field for example at run-time. How can I do something similar in SQL Oracle

Example

SELECT Sector.Date, Sector.RNC, Sector.Site, Sector.Cell,Sector.PSC
FROM Sector
WHERE Sector.Date=[Enter Date];

View 15 Replies View Related

SQL & PL/SQL :: ORA-24248 - XML DB Extensible Security Not Installed?

Mar 29, 2012

When i try to gather server information by running the below query , i get error.

SQL>
SQL> select utl_inaddr.get_host_address ('Hostnamename') from dual;
select utl_inaddr.get_host_address ('Hostnamename') from dual
*
ERROR at line 1:
ORA-24248: XML DB extensible security not installed
ORA-06512: at "SYS.UTL_INADDR", line 19
ORA-06512: at "SYS.UTL_INADDR", line 40
ORA-06512: at line 1

I ran below query to see what is installed.

SQL>
SQL> select comp_name from dba_registry;

COMP_NAME
-----------------------------------------
Oracle Database Catalog Views
Oracle Database Packages and Types
Oracle Real Application Clusters

My question is do i need to install XML database to resolve this issue and is SYS user is required to perform this install?

View 17 Replies View Related

How Many Databases Were Installed In A Given Server / Machine

Apr 10, 2013

10g and 11g

SLES 10

My boss has assigned me a task to check/audit a existing PROD + other databases which was configured (in a server or servers) by previous dba who have left with no documentation.I am just given the server ip and root password.

-How do you attack this kind of task?
-How do you know how many databases were installed in a given server/machine?
-How do you get all the oracle_home being defined or used?

Is /etc/oratab enough to start with?Is oraInventory enough to know all the databases installed? Is this keyword unique, and kind be search using "find / -name "oraInventory"?Do I need to find the existent of the "oracle" exec in all "bin" since this is the unique identifier of an OracleHome?

View 6 Replies View Related







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