Machine details : UNIX machine Solaris 10 OS.I am not able to start the apache server using opmnctl startall command. i am getting the below error message
QUOTE Error
--> Process (pid=823)
failed to start a managed process after the maximum retry limit
Log:
/usr/local/oracle/OH_STANDOHS/opmn/logs/HTTP_Server~1
Even i tried killing the process id = 823 , i am getting the same error message with different process id.
Im using pl sql to generate a web page using an apache server and the thing is that im trying to send cookies to the client but im also using an LDAP server for roles and user administration but the thing is that the cookie file does not appear in the client when sending by pl sql.
this is the code im using
owa_util.mime_header('text/html',FALSE);
owa_cookie.send('CookieName','AnyString',TO_DATE(v_fecha,'DD/MM/YYYY'),'/',NULL,NULL);
owa_util.http_header_close;
I have been learning to create pdf report with Apex 4.2 and BI Publisher 10 which I have been successful with. Now I like to learn how to create pdf reports using FOP thinking of the customers who will not spend money on BI Publisher. I have gone through the documents and procedures described in Java 4 Less. [URL] and [URL]. Configured Apex instance setting accordingly.
For default layout a tabular pdf report is created. I have created an xsl-fo file named Formatted_report.fo on same query and xml file from report query with BI Desktop. But when I try to print a formatted output with Formatted_report.fo report layout it does not work(J4LFOPServer ). but same layout with .rtf template works fine (BI Publisher Print Server).
I'm trying to install Oracle 10g Enterprise Ed. (on Windows 2003 Std. Ed) and I get some errors:
First “Fail to start OCR” I press "continue" and the installation continue. Next “Operative System Error when start OracleCSService” and when I press "continue" the installation finish.
At the end of installation, It seems like Oracle DB is Ok, but not really...I can't connect to database from Enterprise Manager and the OracleCSService is in "Starting mode".
I am hoping to test the behavior of a complex web application that is backended by an Oracle 9i database, against an upgrade to 11g database.
The current setup runs basically on 4 Solaris servers, The database, the Oracle Application Server (version 10 something) (2 instances running on the node/server with no OHS), an install of OAS/OHS as a load balancer box, and the non-OHS Apache2 web server front. Apache takes the request from the web and reverse-proxies it to the OHS load balancer, which sends it to one of the two instances on the single application server. This is a java application and uses an Oracle 9i database to feed it.
I have had enough server resources to clone the database, the app server and the web server, and upgrade the database to 11g. I am unable to setup an OHS load balancer box.
So my question is, how do I configure the Apache WS to communicate directly with the OC4J container(s). I can shut down an instance if that simplifies things. Or, if I had to I could look into standing up OHS in the OAS install, as that seems to be where all the info is focused on the technical info sites (Oracle and others), but since these are clones and I think it might be easier to just short circuit around the now missing load balancer box. Many configurations have already been done to be sure the 'clone' identifications are self-referencing, like the hosts file, etc. to point to resources in the Cloned environment.
This error occurs while trying to print a report in a PDF format using Oracle Application Express 3.0. I'm not sure what this means and how to fix it. I'm running Oracle 10g on Windows Vista.
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1186
ORA-12570: TNS: packet reader failure
This is the first time I'm attempting to print to a PDF. I did follow configuration according to the Oracle documentation. I selected the Standard configuration that uses the built-in Apache FOP or another standard XSL-FO processing engine.
We have an application, where we invoke a URL pointing to a folder on the Application Server, so that users can download files from the same.
There is user authentication provided for the URL.
Example :
Our application ABC (example) which is built with Oracle Forms 10g, hosted on Application server (itxxx123) inovkes a module GEN9999 which on pressing a button calls a URL which is open in the Internet Explorer browser.
If the URL has been called from the Forms or the Application (ABC), then it should be allowed.
If the URL is called standalone, by Opening IE Browser and invoking the URL, this should not be allowed.
However, there have been security concerns raised during Audit, saying that users can access the URL directly from the Browser instead of the Application. Also the URL is saved the Browser history, so even if the user is no longer working in the Application Team, and has moved out of the team, then the ex-user can still access the URL and view and download files.
Is there any way to restrict access to the URL such that is only accessible when it is called from the Application, and that access is restricted when directly called from the Browser.
I have seen that environment variables in httpd.conf may be usable for the above. However, not sure how to use them from Oracle Forms.
I tried my DBA hat today in an effort to set up the Apache FOP to allow users to download interactive reports as PDF. This was working previously - although I'm not sure how since there was no report printing infrastructure set up.We have APEX 4.1.1 using Apache on Windows server 2003.
It started because we saw one of two errors in the generated PDF
ORA-20001: The printing engine could not be reached because either the URL specified is incorrect or a proxy URL needs to be specified.or
ORA-06502: PL/SQL: numeric or value error: character string buffer too smallAs much of the documentation indicates, the first suggests a problem with ACL. I had a little trouble finding documentation stating specifically which acl should be defined for IR PDF printing, but we did ensure the listings in the dba_network_acl* views were current with
[code]...
/I'm still unable to identify where the second error (ORA-06502) is coming up - which is apparently new. So I attempted to deploy the fop.war file using EM, adapting instructions from [URL]...though I think I may have missed a mark since these instructions differ from using the OC4J EM - but I guessed there was fair correlation.
From the EM home on our app server, I created a new OC4J instance called "APEX_Reports"I then went to deploy the fop.war file using "fop" as application name, and "/fop/" as the map to url.
Back in APEX instance management, I set up
Print Server: External (Apache FOP)Protocal: http
Print server address: dev.ouractualdomain.com.au
print server port: 18100
Print server script: /fop/apex_fop.jsp>
I used the same port as that in the EM address. I've also tried variations usinglocalhost8888fop/fop/apex_fop.jsp
The reason for the /fop/fop/ attempt was because I located the jsp file in
C:Ora10gFRShomej2eeAPEX_Reportsapplicationsfopfop
(I've been trying everything)
Other port numbers attempted include those types (JMS,RMI,AJP) listed for the APEX_Reports component.Do we need to restart anything or re-login to APEX before testing modifications?
I have been learning to create pdf report with Apex 4.2 and BI Publisher 10 which I have been successful with. Now I like to learn how to create pdf reports using FOP thinking of the customers who will not spend money on BI Publisher. I have gone through the documents and procedures described in Java 4 Less.[URL] and [URL]. Configured Apex instance setting accordingly.
For default layout a tabular pdf report is created. I have created an xsl-fo file named Formatted_report.fo on same query and xml file from report query with BI Desktop. But when I try to print a formatted output with Formatted_report.fo report layout it does not work(J4LFOPServer ). but same layout with .rtf template works fine (BI Publisher Print Server).
I have setup a RAC machine of two nodes on Oracle 10GR2(with 10.2.0.4 Patchset). All setup went well. I am able to connect one node from sqlplus but the other node is connected to idle instance. I tried to startup the database with mount and nomount option but it fails. Following is the error :
SQL> startup nomount;
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/LCLCLKS/spfileLCLCLKS.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/LCLCLKS/spfileLCLCLKS.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
SQL>
I am using ASM and it is running on both nodes even I am able to connect the SQL prompt from it. I am able to view the diskgroups I created from the second node but through "asmcmd" option I can't go inside the disk group. It gives :
ASMCMD> ls
DATA/
INDEX/
ASMCMD> cd DATA
asmcmd: diskgroup 'data' does not exist or is not mounted
On first node, everything is fine and I am able to import the database on it, as well.
I start my database and suddenly got this error:
ORA-00371: not enough shared pool memory, at least 72102521958 bytes
How to fix? I use startup command only and shutdown when shutdown the database.
I have oracle8i database on windows 2008 but not a domin server now i have domin server and i want to join this server on domin network i try to join domin it fine but my oracle8i service did not start what to do ?
old hostname=bagmati
afterchange hostname=bagmati.alkatel.org.np
OS: AIX 6.1 64bit
DB: Oracle 10gR2 (10.2.0.5.0)
What we did is..
1. Install patch 6613550 (./rootpre.sh)
2. Install 10.2.0.1 for AIX 64-bit
3. Install 10.2.0.5 Patch Set
4. Create Database
5. Created/Setup LISTENER and TNSNAMES (test connection successful)
After installation of database, everything went well until we tried to restart the server, what happened is that we cannot start the listener, the error was:
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
IBM/AIX RISC System/6000 Error: 1: Not owner
What i did to resolve this problem is to change the owner of /tmp to oracle, after that i was able to start the listener. ($lsnrctl start) The problem is that our sys admin said that the /tmp directory is being used by the OS and it's owner must be root. But if i return it to root, the listener will not start again. (After server restart)
BTW, our /tmp has enough space so we did not perform the following steps from the installation guidelines:
$TEMP=/directory
$TMPDIR=/directory
$export TEMP TMPDIR
I was thinking if that we must make a temp directory for oracle and set it in the profile, or change the owner to root again and perform this:
$chown -R oracle:oinstall /tmp
$chmod -R 777 /tmp
I need to add some kind of tracing in oracle 11g on linux when oracle starts and stops - as at times oracle takes a long time to start.
View 9 Replies View Relatedhow to start OEM 12c agent on Linux server ?
Note:Its a RAC server .
$emctl stop dbconsole stops the OEM process.
however,it starts back up on server reboot,how can we prevent that is emca deconfig the only option?
We have a requirement from the customer to start using data and index compression in our 11g database.. Is this something available in Oracle 10g,11g without any additional costs? We are not sure if this will work with our application so we will have to test it in-house, is it possible to compress the existing table data/index to test it out?
View 3 Replies View RelatedWe are getting the below error in between from database. The database throws the below error some times only not continuous.
ORA-12500, TNS:listener failed to start a dedicated server process.
i am using oracle 10g installed windows 7.Oracle console service not started.but sql plus is working.so i wants to start oralce console.
View 1 Replies View Related11.2.0.3.5
RHEL-7
2 NODE RAC
issue : XDB component is INVALID and oracle support suggested below steps. But, in RAC env, can we do this on both nodes or only on one node. If we are doing in node1 and do we need DOWN node2 ?
{
SQL> spool xdbreload.log
SQL> connect / as sysdba
SQL> set echo on;
SQL> shutdown immediate;
[code].......
How to run UPGRADE in rac env ?
I am trying to start enterprise manager without success. i used to work after installation of db 10g but do day when i run the command below it fails. also i donot see any thing useful in the logs that am being directed to directory /oracle/Ora10R2/Orahome/localhost.localdomain_dse/sysman/log
[oracle@cdsdb ~]$ emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.2.0
Copyright © 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.localdomain:1158/em/conso...boutApplication
Starting Oracle Enterprise Manager 10g Database Control .....
[code]....
I have installed oracle on my linux machne recently as an oracle2 user. To day i found my listener up when start my as database ( by logging in to the sqlplus ) sqlplus /nolog - i get into sqlplus
When i startup the database
SQL>startup - I get this error ORA-01031: insufficient privileges
I tried to check if my oracle user is in the dba and oinstall group. it wasn't
I added the user to the group by doing usermod -G dba,oinstall oracle2
i chek in the group to see if the user has been added to the group i see the user added but i still get the same error ORA-01031: insufficient privileges when i try to start the database.
I read some where that you can try to uncomment the SQLNET.AUTHENTICATION_SERVICES line on sqlnet.ora file but on by my file (SQLNET.ORA) there is only one line written (NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT))
I have a sql like this
select inv_dtime where inv_dtime between trunc(sysdate,'YYYY') and last_day(trunc(sysdate,'YYYY')) from temp;
I want to have the start date of the year and end date of the year in my condition. like between 01-JAN-2012 AND 31-DEC-2012. I tried the above but it doesn't come.
I have authentication problem in auto start of database while startup of Linux OS. I am using auto start script. When I set password of sys then database not starting automatically and I always need to startup manually. I add username(sys) and password in dbstart script and its is now working fine.
My question is that is this a proper way to solve this issue? Can I implement this solution in Professional Production database environment ?
Recently, I've just restored my QAS database and filesystem from my backup tape. I have checked all the configuration files and oracle setting files and do not notice any problem.
However, when I tried to start my listener, it shows some error messages as below. As a result, I'm unable to start my SAP application.
Error:
-------
Instance "QAS", status UNKNOWN, has 1 handler(s) for this service...
For you information, I'm able to start my Oracle instance. Please refer to below.
SQL> startup mount
ORACLE instance started.
Total System Global Area 5620367360 bytes
Fixed Size 2064184 bytes
Variable Size 2818572488 bytes
Database Buffers 2785017856 bytes
Redo Buffers 14712832 bytes
Database mounted.
oraqas 3> lsnrctl start
LSNRCTL for HPUX: Version 10.2.0.4.0 - Production on 30-AUG-2010 12:57:25
Copyright � 1991, 2007, Oracle. All rights reserved.
Starting /oracle/QAS/102_64/bin/tnslsnr: please wait...
TNSLSNR for HPUX: Version 10.2.0.4.0 - Production
System parameter file is /oracle/QAS/102_64/network/admin/listener.ora
Log messages written to /oracle/QAS/102_64/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS.WORLD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=drqaecc)(PORT=1527)))
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=QAS.WORLD))
STATUS of the LISTENER
-------------------------------
Alias LISTENER
Version TNSLSNR for HPUX: Version 10.2.0.4.0 - Production
Start Date 30-AUG-2010 12:57:29
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/QAS/102_64/network/admin/listener.ora
Listener Log File /oracle/QAS/102_64/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS.WORLD)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=drqaecc)(PORT=1527)))
Services Summary...
Service "QAS" has 1 instance(s).
Instance "QAS", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
I want a monthly report where the month wise sum of qty should be displayed in a row for last 12 months. I need to specify the month start date and end date in the query to pick the sum for the particular month. How can i do it in a SQL query?
SUM(decode(to_char(t1.trx_date,'mm/rrrr'),
to_char(add_months(SYSDATE,
-1),'mm/rrrr'),
nvl(t2.quantity_invoiced,
0))) AS qty_01
from t1,t2
where t1.col1=t2.col1
instead of sysdate i have to use start and end of month. Also i am using group by clause on some columns.
I am creating report for this i want to make one query..
Query like this
My input is YEAR, MONTH AND WEEK and i want to find out start date and end date for this week...
Scenario like this
-----------------
I/P - Year = 2011, WEEK = 2 , Month - FEB
i will get o/p like this '06-feb-2010' and '12-feb-2010'...
Tables
--------
ROWID START_DATEEND_DATE
101/26/2012 00:00:0001/31/2012 00:00:00
201/26/2012 00:00:0002/02/2012 00:00:00
302/03/2012 00:00:0003/31/2012 00:00:00
How to find out the days difference in sql query, start date of next records and end date of previous records as highlighted on blue color
query out put should give as below
start_date + next record ,end_date - Previous records should give the difference of
6
1
I have installed a rac database,when the os start,and the database can not auto start,how to make the database auto start when OS start?
View 1 Replies View RelatedI am trying to write a shell script to start a DB session without using the DB Password.
View 3 Replies View Related