RAC & Failsafe :: CRS Is Not Starting?
Oct 13, 2011
I am getting problem while starting the CRS. Below is the necessary details:
1) I am using oracle 11g R2 RAC, with 2 node named RAC1 and RAC2
2) I have 3 diskgroup named DATA, DATA1, DATA2
3) OCR and voting disks are stored on ASM diskgroup
On node RAC1, CRS is started and /etc/oracle/ocr.loc is having the below entry:
ocrconfig_loc=+DATA
ocrmirrorconfig_loc=+DATA1
On node RAC2, CRS is stopped and /etc/oracle/ocr.loc is having the below entry:
ocrconfig_loc=+DATA
ocrmirrorconfig_loc=+DATA2
note the difference in "ocrmirrorconfig_loc". The difference was occured because I updated the OCR location on RAC1 when RAC2 was down.
Now I am trying to repair the RAC2 using below command. This command must be run as root user when HA service is started but CRS must be stopped.
ocrconfig -repair -replace +DAT2 -replacement +DATA1
but this showing error "PROT-21: Invalid parameter", because to run this command diskgroup must be mounted. But diskgroup cannot be mounted until the CRS start. SO this is a conflicting situation.
View 4 Replies
ADVERTISEMENT
Oct 14, 2011
I am getting problem while starting the CRS. Below is the necessary details:
1) I am using oracle 11g R2 RAC, with 2 node named RAC1 and RAC2
2) I have 3 diskgroup named DATA, DATA1, DATA2
3) OCR and voting disks are stored on ASM diskgroup
On node RAC1, CRS is started and /etc/oracle/ocr.loc is having the below entry:
ocrconfig_loc=+DATA
ocrmirrorconfig_loc=+DATA1
On node RAC2, CRS is stopped and /etc/oracle/ocr.loc is having the below entry:
ocrconfig_loc=+DATA
ocrmirrorconfig_loc=+DATA2
Please note the difference in "ocrmirrorconfig_loc". The difference was occured because I updated the OCR location on RAC1 when RAC2 was down.
Now I am trying to repair the OCR on the RAC2 using below command. This command must be run as root user when HA service is started but CRS must be stopped.
ocrconfig -repair -replace +DAT2 -replacement +DATA1
but this showing error "PROT-21: Invalid parameter", because to run this command diskgroup must be mounted. But diskgroup cannot be mounted until the CRS start. SO this is a conflicting situation.
View 3 Replies
View Related
Apr 25, 2011
I am unable to start the listener.When I start it I get this error
LISTENER2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.20.221)(PORT = 1522))
)
[Code]....
When I try to start it is showing
LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 25-APR-2011 10:55
:31
Copyright (c) 1991, 2006, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> start listener1
Starting tnslsnr: please wait...
Failed to start service, error 0.
View 4 Replies
View Related
Sep 2, 2011
I cloned the oracle VM, was able to recreate the repository for em.
But its failing when i try to start it with following trace of errors
2011-09-02 17:22:59,502 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.ias.ias.IASIntegration
2011-09-02 17:22:59,753 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.eml.target.slb.common.SLBIntegration
2011-09-02 17:22:59,830 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.eml.ssl.intg.SSLIntegration
2011-09-02 17:22:59,898 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.tip.oem.central.domain.ProcessConnectDomainIntg
2011-09-02 17:22:59,908 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.tip.oem.central.instance.ProcessConnectInstanceIntg
2011-09-02 17:22:59,910 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.webdb.admin.em.PortalIntegration
2011-09-02 17:22:59,911 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.webdb.admin.em.SSOIntegration
2011-09-02 17:22:59,912 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.reports.em.RepIntg
View 1 Replies
View Related
Jun 30, 2011
We have Data Migration for our application coded in PL/SQL. The DB server has 64 Cores available (Solaris 10 OS) however running the migration code written as a function, utilizes very little CPU and CPU utilization is to max 2%. To utilize CPU power available to increase the speed of migration, we are using DBMS_JOB to schedule this function multiple times.
However scheduling the function 10 times, we are seeing that at any moment only 4/5 oracle processes are active and utilizing the CPU and CPU utilization has gone up to 5-6%. The speed of migration is increased but not to a great extend which I feel would work if we could utilize more CPU.
I see a parameter job_queue_processes is set to 10 currently in the database and am planning to increase this (currently to 25 as I don't have exact count of how many other jobs may be running in the database).
View 1 Replies
View Related
Jul 17, 2010
when i start the Oracle database, the database is mounted. Then when i issue the "alter database open resetlogs" command, i got the below error.
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/data/oracle/NYP15S1D/data03/SYSTEM_01.dbf'
So i added the parameter "_allow_resetlogs_corruption=TRUE" in "init.ORA" file to force open the database but the Oracle instance crashed with following message.
In the alert log the following error is there:
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [4000], [2], [], [], [], [], [], []
How can i resolve the issue?
Please note: the database is Oracle 9i, installed in UNIX AIX OS.
View 1 Replies
View Related
Jul 30, 2010
how to select the name that starts with first letter caps.
Eg:
Emp_Name Emp_id
Raga 101
Purnima 102
Vicky 103
ragu 104
raman 105
Santhosh 106
output should like as following:
Emp_Name
Raga
Purnima
Vicky
Santhosh
4 row(s) affected.
View 39 Replies
View Related
Jan 25, 2010
I have forms developer installed on a HP-UX machine. I do the following
1. connect to server (telnet)
2. export DISPLAY=my_ip:0.0
3. run f90desm
The 'ps' shows f90desm as running
now this does not show the window for forms developer in short time it takes a large amount of time Hrs before the window shows up.
View 1 Replies
View Related
Nov 9, 2012
I want to get the week of the year.
Conditions are:
1. Year's first week starts with first Sunday of the year. (6th Jan 2013 will be the starting week (week 1) in Year 2013)
2. 2nd Jan 2013 will be the last week of the previous year i.e. 2012 (either 52th or 53rd week)
At many place I found the below solution:
select to_char(to_date('01-JAN-2008','DD-MON-YYYY')+1,'IW') week_number from dual;
But its not working for the given dates (2nd Jan 2013, which should fall in the last week of 2012, and 6th Jan 2013, which should be the starting week of 2013).
View 6 Replies
View Related
Oct 23, 2012
I'm using Oracle 11g running over a Windows 7 OS. The service OracleServiceORCL doesn't start. Listener.log has the following registry:
23-OCT-2012 19:45:29 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=MBA-DB$))(SERVICE_NAME=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=49445)) * establish * orcl * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
When I try to start in services, is returned the OS error 1067. This error starts to occur when I did the follow. I executed a PLSQL command to fill a (big) table with a lot of data. More than 1 day after and while the program still running, I broke the program. After that, Oracle was consuming lot of disk. I broke the process (using taskkill /f) and, after that, the database stopped working.
What I can do to recover my database?Below I list my listener.ora and tnsnames.ora
mbentoalves
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
[code]...
View 5 Replies
View Related
Mar 20, 2013
in my application I'm starting jobs via dbms_scheduler for background activity on user action.
I know from my logs that the procedure executed in the job finishes within 2 seconds.
But in the AWR I find execution time for the job of 360 seconds (single execution because of unique job id).
How do I find out why the job takes so long?
And more important: how do I speed up the job?
(details will follow...)
View 0 Replies
View Related
Oct 3, 2010
Trying to configure oracle golden gate between oracle 10g and 9i golden gate Manager is not starting
Error in MGR.rpt
Source Context :
SourceModule : [mgr.main]
SourceID : [/home/ecloud/workspace/Build_FBO_OpenSys_r11.1.1.0.0_078_[34085]/perforce/src/app/mgr/mgr.c]
SourceFunction : [param_file_args]
SourceLine : [2854]
2010-10-03 09:27:48 ERROR OGG-00303 Unrecognized parameter (<CODE>PORT).
2010-10-03 09:27:48 ERROR OGG-01668 PROCESS ABENDING.
View 1 Replies
View Related
Aug 23, 2010
I have created and formatted a mini test scenario. Execute the scripts I have below?
From the column adj_second_line, I am trying to clip everything from the characters '201' all the way to the end...or the NUMERIC start value after the word 'TYPE'. Whichever way is easier for you...
create table test_split
(adj_second_line varchar2(80))
insert into test_split
values ('ADJ#1-2G3AYL TYPE 20100501 20100524 0MO/23DY')
insert into test_split
values ('ADJ#2-656GYP TYPE AR 20100522 20100524 0MO/15DY')
insert into test_split
values ('ADJ# 265HKK TYPE X 20100428 20100524 0MO/30HT')
insert into test_split
values ('ADJ#13 43327DR TYPE AJ 20100413 20100524 0MO/30HT')
-- Need to have another column called split_second_half
SELECT adj_second_line,
substr(adj_second_line, 1, instr(adj_second_line, '201')-1) split_first_half,
instr(adj_second_line, '201') clip_from_position
FROM test_split
--Desired output for the split_second_half column
20100501 20100524 0MO/23DY
20100522 20100524 0MO/15DY
20100428 20100524 0MO/30HT
View 11 Replies
View Related
Sep 16, 2008
SP file was removed during the testing and I started the database after making some changes in the pfile, and it works fine.
But when I try to start the database using the SPFILE, it gives an error.
SQL> STARTUP PFILE='D:oracleproduct10.2.0adminorclpfileINITORCL.ORA'
ORACLE instance started.
Total System Global Area 289406976 bytes
Fixed Size 1248576 bytes
Variable Size 109052608 bytes
Database Buffers 171966464 bytes
Redo Buffers 7139328 bytes
Database mounted.
Database opened.
SQL> create spfile from pfile;
File created.
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup
ORA-01565: error in identifying file 'D:oracleproduct10.2.0db_7/dbs/SPFILEORCL.ORA'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 1541)
The contents of the spfile in $ORACLE_HOMEdatabase are
*.SPFILE='D:oracleproduct10.2.0db_7/dbs/SPFILEORCL.ORA'
View 12 Replies
View Related
Jul 28, 2012
I installed Oracle database 11g enterprise edition. I can connect it through sql plus but Database control is not starting. I have checked dbconsole service which is running.
the address is [URL]...
but mozilla and chrome both are unable to start the application. after installation it started only once. but it is not starting now.
second thing is how can i confirm what is the port of my listener is it 1158 or something else.
View 2 Replies
View Related
Sep 30, 2011
I have made one LOV for vendor_names. On form level i want that when the user will enter a particular alphabet in a textbox assigned with LOV, the list should popup with only those elements starting with that particular alphabet. I have written the following code in the query of LOV wizard
query:
select distinct(bpt_ven_nm),bpt_ven_cd from bill_hdr1_tab
where bpt_ven_nm like ('enter.vendr_nm'||'%')
order by bpt_ven_nm
Wherin 'Enter' is the name of block and 'vendr_nm' is field name.
But its getting unsuccesfull. Any alternate way to get this result.
View 2 Replies
View Related
Mar 16, 2011
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=
[code]...
View 1 Replies
View Related
Apr 28, 2011
I just installed oracle 11g on a fresh RHEL 5.2 installation on virtual box.
The database is up, but the listener (LISTENER) hangs after a minute from starting it, and then any lsnrctl command just hangs without showing any error messages, when I restart the virtual machine and then start the DB and listener, it works for a minute and it hangs again!
View 2 Replies
View Related
Feb 12, 2011
I installed Oracle 11.2.0.1.0 Enterprise Edition on my home laptop computer running Windows 7 Professional months ago, set the services to start automatically and it had been working fine, with multiple shutdowns and re-starts per day, until today. I was using it earlier today, then shut the laptop down, went to lunch, turned it on again, tried to login through SQL*Plus and got:
SQL*Plus: Release 11.2.0.1.0 Production on Sat Feb 12 15:48:39 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: scott/tiger
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
I tried restarting the computer, but still got the same result as above.I went to:
Control Panel -> System and Security -> Administrative Tools -> Services
and confirmed that the Oracle services were still set to start automatically. The OracleOraDb11g_home1TNSListener showed started. The OracleServiceORCL showed that it was set to start automatically, but did not show started or starting or stopped. The only option displayed for it was start, not pause or stop or restart, implying that it was not started. My computer had been on long enough that it should have started and it did not show that it was trying to start or give any indication that it had tried to start and failed and showed that it was set to start automatically.
I clicked on the start option, it started, and I was able to login. If I have to, I can live with this as a workaround, but I would prefer that it start automatically like it is supposed to. I find it puzzling since it had been working and I did not change anything, at least not intentionally. The only thing that I can think of that I did differently recently was experimenting with cursors and dbms_sql in order to intentionally reproduce the error "ORA-29471: DBMS_SQL access denied" to demonstrate it in response to a thread on the SQL and PL/SQL forum: [URL]. However, after reproducing the error, I corrected it and was still able to exit SQL*Plus and log in again until I shut down the computer and re-started. I don't know if this is related or coincidence.
View 11 Replies
View Related
Aug 17, 2011
I want to start up a reports server by executing the command "rwserver server=<server_name> start" via the windows command line. The status shows that the server is starting up but, the next second the status shows "Server is shutting down"
View 2 Replies
View Related
May 3, 2013
today i have restarted the database server (11gR2) after that database service is not starting, the error message is
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
View 8 Replies
View Related
Jan 21, 2011
I am able to start SQLPLUS from Start | Program files | Oracle - OraHome92 | Application development |
Unfortunately, when trying to start it from the "command prompt" window with the following command SQLPLUS, it generates the infamous error message like
"... unknown etc... "
Any variables i need to change on my client machine ?
View 11 Replies
View Related
Oct 15, 2010
I am getting an error regarding Starting Database Control. I have multiple databases on the same server but every time I am trying to create a new database I am getting the same error again and again.
View 1 Replies
View Related
Dec 5, 2011
I saw this thread:[URL]....
and checked to see if I could start:[URL]........
using Firefox 8.0 and found that I was "unable to connect". I found that although my OracleDBConsoleorcl service was set to automatic, it was not started. So, I attempted to start it from the Windows services menu, but received a message that Windows could not start it and it said to see the System Event Log. So, I checked the Windows System Event Log and found:
"The OracleDBConsoleorcl service terminated with service-specific error The system cannot find the file specified."but it does not tell me the name of the file or directory path. So, where do I go from here? I did not want to hijack the other thread, so I started a new one, especially since the original poster was able to start this service. Is there a different way to try to start the service that might provide more information?
I have been using this installation for a long time and seem to remember this working once upon a time, but I could be wrong. I don't usually use Enterprise Manager, so this is not something critical, just a curiosity, and something that I might like to explore. I have provided version and system info below.
-- Oracle version info:
SCOTT@orcl_11gR2> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
5 rows selected.
-- partial systeminfo (some lines like product key removed):
C:>systeminfo
OS Name: Microsoft Windows 7 Professional
OS Version: 6.1.7601 Service Pack 1 Build 7601
[code]...
View 1 Replies
View Related
Oct 9, 2012
I'm trying to create a database using DBCA, but before it completes i recieve the following error:
enterprise manager configuration failed due to the following error - Error starting database control refer to the log file at
E:oracleproduct10.2.0db_2cfgtoollogsdbcaorcl30emconfig.log - for mote details you can retry configuring this database with enterprise manager later by manually running E:oracleproduct10.2.0db_2inemca script
I'm using oracle 10g version 10.2.0.5, and my operating system is windows 7
View 2 Replies
View Related
Jul 30, 2013
Recently I remember reading what I think was a blog post on placing the last column of a report underneath the penultimate column - I think it was for classic reports.
I can't find it... Col1 Col2 Col3---- ---- ---- abc def xyz123 456 987 Col1 Col2 ---- ---- abc def xyz123 456 987
I think it was done with some magic in the column definition, or maybe some jQuery?Agnostic to version. It was a more robust solution than using a HTML expression of#COL2#<BR>#COL3#
View 5 Replies
View Related
Oct 29, 2013
i m facing an issue about TNS connectivity after some time i start my notebook and then sql butt it can not be login from any side like sql,pl/sql,forms or reports it shows same error ora-12203 tns unable to connect to the destination also my service of oracleserviceORCL can not start it shows an error like 'windows could not start the service on local computer '
View 4 Replies
View Related
Nov 19, 2012
I recently installed 2 node Oracle 11g RAC on RHEL5. While creating Clustered Database, database creation on second node (racnode2) failed. So, I connected */ as sysdba* on the node and executed startup only to get this error message:
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+RACDB_DATA/RACDB/spfileRACDB.ora'
ORA-17503: ksfdopn:2 Failed to open file +RACDB_DATA/RACDB/spfileRACDB.ora
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux Error: 13: Permission denied
Additional information: 196612
Additional information: 10
SQL>But, *'+RACDB_DATA/RACDB/spfileRACDB.ora'* is present.
I strongly believe it is a permission issue that ORACLE owned processes are not able to access disks owned by GRID user. I checked the permission of disks:
[oracle@racnode2 ~]$ cd /dev/oracleasm/disks
[oracle@racnode2 disks]$ ls -l
total 0
brw-rw---- 1 grid asmadmin 8, 65 Nov 19 19:15 CRSVOL1
brw-rw---- 1 grid asmadmin 8, 49 Nov 19 19:15 DATAVOL1
brw-rw---- 1 grid asmadmin 8, 81 Nov 19 19:15 FRAVOL1
[oracle@racnode2 disks]$And also, ORACLE user has asmdba among other privileges.
[oracle@racnode2 disks]$ id
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1201(asmdba),1300(dba),1301(oper) context=user_u:system_r:unconfined_t
I am willing to furnish further data.
View 10 Replies
View Related
Mar 29, 2011
I have successfully installed Oracle R12 on my machine but after rebooting I can not start.
This is what I did
/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/addlnctl.sh start listener
/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/addbctl.sh start
You are running addbctl.sh version 120.1
Starting the database VIS ...
SQL*Plus: Release 11.1.0.7.0 - Production on Tue Mar 29 21:02:42 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
addbctl.sh: exiting with status 9
/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/addbctl.sh start
[code]....
BTW I have not set $ORACLE_HOME, $ORACLE_BASE, $ORACLE_SID yet.
View 18 Replies
View Related
Jun 10, 2011
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.
View 4 Replies
View Related