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"
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:
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?
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).
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
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.
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.
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.
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?
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 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.
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.
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
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
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.
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)?
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
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.
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.
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.
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.
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];
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?
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?