I've been trying to rebuild our Oracle 11g server. I started off by wiping Oracle completely and kicked off the install again. The install goes smoothly, but does not create the Listener. I've been trying to use netca to create it myself. The below is the output from netca:
Listner Control complete.
Listener start failed.
Looking in the netca trace file, I see the following error (note I'm only including the error with a few lines before):
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [NativeResult.<init>:91] NativeResult: The String obtained is1|SUCCESSFUL
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [NativeResult.<init>:99] The status string is: 1
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [NativeResult.<init>:112] The result string is: SUCCESSFUL 1
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [WindowsSystem.deleteService:787] _WS_: deleting service2 OracleRemExecService on AUSYD5756 ignoreNotExist = true
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [WindowsSystem.deleteService:793] _WS_ deleteService2: node AUSYD5756 Service OracleRemExecService result: 0|Access is denied.
[code]....
The OracleRemExecService services does not exist. I've tried re-installing the whole instance a number of times but each time I hit this error.
When i configure a listener using net manager,if found that the red text box in the picture can fill "the value of the global name " or "the value of the service_names".
I've been asked to configure RMAN on an existing Oracle 11g R1 database running on Windows Server 2003 (32-bit) & when I connect using RMAN client to the database instance, I'm getting the following error setting the Fast Recovery Area and don't know why:
C:>rman target /
Recovery Manager: Release 11.1.0.7.0 - Production on Mon Jun 25 14:39:45 2012 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: ORCL11G (DBID=825621007)
RMAN> shutdown immediate;
using target database control file instead of recovery catalog
database closed database dismounted Oracle instance shut down [code]....
RMAN-01007: at line 1 column 1 file: standard inputAccording to Oracle documentation, I appear to be entering the correct command sequence but it's not working for some reason..
we don't have system or storage admin available..I have to create the development environment. I have 2 Dell 2950 Power Edgde Servers and 500 GB Buffalo NAS with Windows 2K3 X64 EE, tell me whether I can install Oracle RAC with this kit.
If yes , how can I configure shared storage and present it to OS so that both nodes can see it.
i want to configure my present Data Guard Setup with Enterprise Manager...and on the Enterprise Manager grid control page i am not seeing any Data Guard option.....i am using oracle 10gR2 and Windows XP.
How to use enterprise manager for configuring Data Guard.
I have window7 OS, I installed 4 ORACLE HOME's in WINDOWS7 machine,
two ORACLE_HOME is for 10.2.0.3
two ORACLE_HOME is for 11.2.0.2
My intension is to configure DATAGAURD on 10g,11g But while configuring Listeners it creating problems like as of my knowledge we have set exicutable path in envronmental veriables.
creation of Listener for 10.2.0.3 ( first ORACLE_HOME)
but while creating listerner for 10.2.0.3( seconde ORACLE_HOME)
LISTENER created but it's showing ORACLE_HOME of FIRST ORACLE_HOME
as i know we need to set parameters
SET ORACLE_HOME= SET ORACLE_SID=
is there any setting Required before configuring LISTENER for SECOND ORACLE_HOME? and for 11g
I have set password on the listener and set the local_os_authentication parameter to "OFF", whenever i start/stop listener through "lsnrctl" ,it works fine and asks for password but i can stop/start listener through windows services without giving any password.
what is the use of setting password on listener if any body can start/stop it through services utility in windows xp sp3.
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.
I am having a database running in my windows 2003 server and I want to configure Enterprise manager for that database to check the resource utilization during the peak hours and also the number of transactions...
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.
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 wish to configure an Oracle 11g RAC with ASM setup for the internal employee training purpose. The requirement is as follows
1. Operating system Linux, Software Oracle 11g Release 2 2. Need to build total 5 individual clusters. 3. Each cluster with 2 Node 4. Need to configure ASM as a shared storage with real hardware. (No virtualization, Openfiler, NFS) 5. Need to configure RAC database.
provide me the hardware details for configuring Shared storage. Is there any specific Storage which we can use to configure ASM as a storage.
I need to configure character set for my database. I have 2 options:
AL16UTF16 - require 2 bytes per character (fixed length) UTF8 - character length - 1 until 4 bytes. (variable length)
until here ok...
The AL16UTF16 certainly will occupy more space than UTF8. So my question is, When would I need use AL16UTF16 character set mode?
I hear one time, when a database write many values with the same length. it does it in the same HD cylinder. So the HD arm could with a single movement read all the fields in cylinder completely. Improving the read/write performance.
I am trying to install oracle 10g RAC on CentOS release 5.4 (Final), But when I am not able to configure SSH between oracle users on both node.
Node 1 -------- [oracle@node1 ~]$ id uid=600(oracle) gid=500(oinstall) groups=500(oinstall),501(dba) [oracle@node1 ~]$ date Thu Dec 30 05:14:10 IST 2010 [oracle@node1 ~]$ ------------ Node2 ---------- [oracle@node2 ~]$ id uid=600(oracle) gid=500(oinstall) groups=500(oinstall),501(dba) [oracle@node2 ~]$ date Thu Dec 30 05:15:32 IST 2010 [oracle@node2 ~]$ --------- OS ---------- [oracle@node2 .ssh]$ cat /etc/redhat-release CentOS release 5.4 (Final) [oracle@node2 .ssh]$ date --------- Host for both node -------- [oracle@node2 .ssh]$ cat /etc/hosts # Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1 localhost.localdomain localhost # Public 10.1.1.10 node1 10.1.1.11 node2 #Private 20.1.1.10 node1-priv 20.1.1.11 node2-priv #Virtual 10.1.1.21 node1-vip 10.1.1.22 node2-vip ------------------------ I am using the command to configure SSH provide in the link
Am trying to configure rman to backup to a directory to a linux server on the network. Database is on windows server. Here is the parameter changes
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '\\204.47.240.126\bexdisk\backup\%U' ; new RMAN configuration parameters: CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/oraback/rman/sde_backups/%U'; new RMAN configuration parameters are successfully stored starting full resync of recovery catalog full resync complete
Here is my rman script
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK; run { crosscheck archivelog all;
[Code]....
instead its backups but to my ORACLE_HOME\database directory..
configure correctly my application, Oracle is version 11R1
My physical configuration is :
Site 1 (main building) database on cluster : server1, server2 database : BASE1 available
Site2 (Backup Site) database on cluster : server3, server4 database : DGBASE1 not available for users (dataguard)
I want to acces BASE1 first in load balancing server1,2 (normal usage) and DGBASE1 in load balancing server3,4 in case of failover after 5 retries of 10 secondes (in case of main buiding out of order, DGBASE1 will be available for users)
My trouble is that with this configuration, access it randomly BASE1 or DGBASE1 but DGBASE1 is not available for users then I have failure
What could be the right configuration to obtain BASE1 first in load balancing (normal usage) and DGBASE1 in load balancing in case of failover of the BASE1 after 5 retries of 10 secondes ?
I have a SAN Storage device of 8TB size . I am new to rac setup ,i dont know how to configure the SAN device for RAC SETUP on ASM..how to configure the SAN device for RAC setup on ASM
How many disks we need to have? which and sholud be on ASM ? how to impliment raid10 for database file disk and raid5 for arhcive log files
I have created a batch for silent DB Creation through DBCA. I want to add a script to also create the Network Service after. I was told it can be done only with Response File. Is a response file a script also that can be executed after the DBCA scripts?Where can I find a manual with the available commands so I can produce what I need? On the internet I find only examples for Silent DB instalation. EDITOS is Windows 7 Oracle 11.2.0.1 I want to create the Network Service that will add these lines to the tsnames.ora.
on both the client and the server.How can i do it automatically through a batch script, so to add it to DBCA scripts after creation? I was told once in atopic that it could be done through a response file.
We are in project design phase and following is the hardware setup:
Database (2 node RAC)-Solaris 10 Application server server (2 server) -Solaris 10 Web server (2 server for Failover)= RHEL
For DR Database (1 node)-Solaris 10
need to know 1.What are the best practice to implement and to configure DR as Non-RAC physical standby for RAC database server. 2.What are implication if we go for single node except failover node unavailability for DR. 3.What are the steps of Switchover in this case. 4.What's the recommended backup solution for 8-10 Terabyte database
I've checked ALL the parameters. It seems to be OK.The db is running and OK.But when I try to configure the EM I get the following error Says that the databse instance is not available.But, tnsping works ok, and I can connect as sys without problems. the DB is OK.
EMCA iniciado en 12-dic-2010 12:54:17 Asistente de Configuraci¾n EM, Versi¾n 11.2.0.0.2 Producci¾n Copyright (c) 2003, 2005, Oracle. Todos los Derechos Reservados. [code]....
it has smtp address but still i'm getting a error message
smtp.gmail.com: Test failed with message: "Sending failed; nested exception is: javax.mail.MessagingException: 530 5.7.0 Must issue a STARTTLS command first. t18sm1156251qco.20 "