We have installed Oracle 10G in windows 2003 server. Oracle is working fine when oracle services are running in local system account, when we change the option �Log On As� from local system account to an domain id the oracle listener stops automatically.
I tried the below mentioned options, We created a new listener it did not worked . we are able to connect the db through command prompt but not through SQL plus or TOADWhen we add the domain id to the local administrator group the oracle is working fine. But we cannot have the domain id in local administrator group since GPO will automatically remove the domain id from local administrator group.
I was installing Oracle 10g Client on my PC. But after Specifying Home Details, I was unable to proceed. The installation hangs in the Loading Product Information form.
I am trying to create an anonymous PL/SQL block to output privilege information for each of the users listed in DBA_USERS In a loop. This is my block so far (not finished):
***User-Role Privilege report*** ----------------------------------- username: ANDREY , profile: DEFAULT SYSTEM privileges granted directly to the user(not through ROLE) : no_data_found
A problem I am encountering is that for some users I have no direct privileges that are not granted through roles, And when I have the expression v_qry (which is basically "'select grantee ||'',''|| privilege from DBA_SYS_PRIVS where grantee not in (select role from dba_roles) and grantee ='||'''' ||v_usr||''''") not initialized with values because the select statement retrieved 0 results, I have the process interfered by the no_data_found error/exception.
Questions: how I can preferrably simply, avoid/overcome my problem? Some way to make the loop go on in spite of no data found? maybe something similar to NVL?
When Running forms on local machine I successfully download data to excel. But when I place this to server (unix), the forms stops in this line: application := Client_OLE2.create_obj('Excel.Application');
I think I have no problem with webutil setup or signing it including the jacob because another form is running on server with webutil functions loading and downloading images (pdf).
The problem is why when it comes to excel I have this issue. When I run the form and the code mentioned above is encountered, the program stops. What I have on java console are:
Loading http://59.0.0.132:7778/forms/java/frmall_jinit.jar from JAR cache Loading http://59.0.0.132:7778/forms/java/frmwebutil.jar from JAR cache Loading http://59.0.0.132:7778/forms/java/jacob.jar from JAR cache proxyHost=null proxyPort=0 connectMode=HTTP, native. Forms Applet version is : 10.1.2.0
i want to run the salary posting procedure automatically at mid night every day. i have created a job in toad and defined the required information but it is not working.
I have problem with my Replication using oracle 9i.It does not push transactions automatically when refresh time comes but it works fine when pushed manually.I have two sites:
1- Master a-Master group 2- Materialized view site a- Materialized view group (Asynchronous) b- Materialized view with refresh occur automatically on future date every 5 minutes c- refresh type FORCE.
My Oracle jobs are not running. I can run them manually but they don't start automatically as per interval. The job_queue_processes=100 and CJQ process is not running. I started CJQ0 process by resetting it to 0 and then to 100. But as soon as I enabled a job this background process stopped.
The job also did not execute in its next execution time. I have created the database manually without using DBCA. Is the problem because of this? I have set crontab immediately to get rid of it.
I have two control block i.e. class_register and student_info. In which student_info is multi-record block which contains stud_id, stud_name, stud_roll_no. Based on the class_register block, stud_id and stud_name is generated in the student_info table. Now I want to generate stud_roll_no automatically until the last record is present.
When I am trying to enter to the enterprise manager of oracle 11g, but it is not working. In my services list the 'oracledbconsoleorcl' is assigned as automatically to start with windows. But it is not starting. When I tried to start it manually the following message is displayed repeatedly even after restarting the pc.
'Windows could not start the oracledbconsoleorcl on Local computer. For more information, view the system event log. If this is a non-Microsoft services, contact the service vendor, and refer to service-specific error code 2.' In the event log the following error messages are displayed:The OracleDBConsoleorcl service terminated with service-specific error 2 (0x2). and
The OracleCSService service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion.
i have a ref cursor and i have used 'open cursor for' statement:
CREATE OR REPLACE PACKAGE aepuser.pkg_test AS TYPE cur1 IS REF CURSOR; PROCEDURE get_empdetails (p_empno NUMBER, io_cur OUT cur1); END;
[code]...
then i want to know that- will oracle automatically deallocate the memory occupied by records in cursor area?if yes, then when it will be free , in case of 'open cursor for' ?
I'd like to call an existing function/procedure from a resource template. For example, I have a procedure called 'rest' with an out parameter of 'p_out' - how do I use this within a resource template?
At the moment I have defined the template as type 'PL/SQL Block' and with the 'GET' defined as:
begin myschema.rest(:p_out); end;
APEX_PUBLIC_USER has been granted 'all' on the procedure. The p_out is populated with a piece of text.
When I call this resource, I get a '500 Internal Error' returned. I've tried adding p_out as an X-APEX-FORWARD parameter, but nothing seems to work.
I am using oracle 11.2.0 in linux platform.i have created a listener for the asm database. and i am using non default port of 1525 whenever i go for lsnrctl>status always shows for the port 1521. i don't want the default port 1521 and i have changed the local listener as listener1 with port 1525 protool tcp in spfile and registered with the asm database.Is there any option to change the default listener as listener1.
also,everytime when i give lsnrctl>show current_listener it is showing "listener"
i have set the current-listener to listener1 and save_config listener1 and reloaded.After exit and enter lsnrctl>status it will show for port 1521 When i attempt to start listener1 every time. it will prompt listener1 is already running.
In one of our RAC envrionment, we have more than 15 databases in a server running in AIX Operating system.the Listener file I am able to find only one entry (SID). But while trying to execute lsnrctl status it displays all the 15 SIDs in the list hosted in the ser ver. Not sure how it works?
As we created another one new database in the database, where i need to add this SID in the listener.ora file to reload the listener.
i have installed oracle 11g r2 rac with 2 nodes. i want to configure the client side load balancing and server side load balancing. For the client side load balancing the i have configured with the
now i have few questions: 1. for the server side load balancing do we have to configure the REMOTE_LISTENER on each node so that the instance on each node registers with the listeners on other node. 2. if we have 3 nodes does this mean that we have to configure the REMOTE_LISTENER on 3 nodes to register with the listeners on the other remaining 2 nodes. 3. does the listener have to be registered with the vip network address (where the clients usually use to connect).
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.
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 am done with my configuration for oracle HS to connect to SQLserver. When I tried to start my listener, it is giving the following errors.
----------------------------------------------------------------- TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production System parameter file is D:oracleproduct10.2.0db_1 etworkadminlistener.or a Log messages written to D:oracleproduct10.2.0db_1
[code]..
Contents of my listener.ora file are below -------------------------------------------------------------- LISTENERSQLODBC = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST=
I had two installations of Oracle on my server (10.2.0.4 and 11.2.0.1) under different linux users. The Databases used different listeners on different ports.
I upgraded my Oracle 11g to 11.2.0.3 successfully two weeks ago. However today I just checked that I couldnt reload my Oracle 10g Listener. On further analysis (lsnrctl status) I discovered that my 10g listener's version was "TNSLSNR for Linux: Version 11.2.0.3.0" . My Start Date from lsnrctl gives me the date when my Oracle 11g was upgraded.
Now I have tried to reload my 11g listener which works normally. I cannot reload my 10g listener (TNS-01190: The user is not authorized to execute the requested listener command). When i run ps command there is no process on my server for my 10g listener. I can only see my 11g listener process after running ps command. However everybody can ping my databases on Oracle 10g but i cannot identify or kill my listener process even on server level.
I just finished my first course in SQL for Oracle 11g at my local community college. We used SQL*Plus for the coursework and for the next class I need to use SQL Developer. Initially, I installed the Developer and was unable to establish a test connection due to the listener not being installed. I fiigured out that I needed to use the Network Configuration Assistant to add and configure the listener. After doing so, I was able to connect using Developer. The issue, however, is that any time I restart my computer, the TNS Listener service disappears from the list of services in Task Manager and I have to delete and then add and configure the service again using Network Configuration Assistant. Obviously, the Listener still exists because I can delete it and then recreate it.
ODBC--call failed.TNS:listener was not given the SID in CONNECT_DATA (#12504)
TNSname sets the SID. SQL*Plus is able to connect from the client Windows XP Proff using the same name. Access, on the same client, uses the same Oracle driver to connect successfully to other Oracle databases. These other databases show equal tnsname (different name and SID...)
ODBC Data Source Administrator configures the database and the test connection is successful.
Cannot set up a link from Access to the Oracle database. At some point, I have created a new Access database and it did let me connect, view the list of tables, and set up links to several tables, but the next day I could not open any of the tables and the complain was: ODBC--connection to 'MYDB' failed.
It seems that SQL*Plus passes correctly the SID from the TNSname but ODBC, when invoked from Access, does not. Yet, ODBC does it right for other databases.
ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener Usage: /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbstart ORACLE_HOME Processing Database instance "orcl": log file /u01/app/oracle/product/11.2.0/dbhome_1/startup.log
how to set oracle listener ? i tried using listener.ora file again show the same error
We have a custom portal application that uses a bunch of application servers. Our connection pool max size is 1100. For the past two days, we had two incidents when the cpus reached the max limit and the db was not allowing connections to come thro' for 10 minute periods. The alert log does not have any entry and the listener log does not have any entry for that 10 minute period.
We have many many APEX applications in APEX 3.0 running on a 10.2.0.4 database that needs desperately to be upgraded. As a test, I've set up a clean 11gR2 database and copied the production APEX database into it via datapump. I set up APEX Listener, as I don't have any OAS sitting around and the EPG doesn't seem to be supported for APEX 3.0... the Listener doesn't say one way or the other.
When trying to log in, I get the login page, but it tries to reference files such as apex_get_3_1.js while I only have files such as htmldb_get.js in my images directory in production. I noticed it is looking for what appears to be 3.1 files instead of 3.0 files... which concerns me.
The APEX listener appears to be more than just a Java PL/SQL gateway.
Is there a minimum version of APEX the APEX Listener supports?
We've been administering a multiple instance production dB server with 3 different versions of Oracle installed.Currently, each of Oracle version had corresponding listener.Oracle 9i had 2 instances, 10g 6 instances & 11g 2 instances also.how I can integrate this 3 listeners into 1.
