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

Oracle 11g R2 RAC - CRS Is Not Starting

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

Windows :: Listener Not Starting?

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

Starting Dbconsole On Oracle 10g?

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

Starting A Function In Parallel Using DBMS_JOB

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

Error While Starting Up Oracle Database

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

SQL & PL/SQL :: How To Select A Name Starting With First Letter Caps

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

Forms :: Developer Not Starting Up (f90desm)

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

SQL & PL/SQL :: Get First Week Starting With First SUNDAY Of Year

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

Windows :: Oracle Service Not Starting?

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

Scheduler :: Jobs Starting With Delay

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

Replication :: Golden Gate - Manager Not Starting?

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

SQL & PL/SQL :: How To Clip Data Starting From Certain Character String

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

Server Administration :: Errors While Starting DB Using SP File

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

Enterprise Manager :: Database Control In 11g Not Starting?

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

Forms :: Get List Values Starting With Particular Alphabet

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

Networking And Gateways :: Listener For Oracle HS Not Starting?

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

Networking And Gateways :: Listener Hangs After Starting Up

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

Windows :: 11g Service Not Starting Automatically On Win 7 Professional?

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

Reports & Discoverer :: Server Is Shutting Down / When Starting Up

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

Database Not Starting ORA-01034 - ORACLE Not Available And ORA-27101

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

Client Tools :: SQLPlus Not Starting From Command Prompt

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

Enterprise Manager :: Error Regarding Starting Database Control

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

Enterprise Manager :: Oracle DB Consoleorcl Service Not Starting?

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

Enterprise Manager :: Error In Starting Database Control?

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

Application Express :: Starting Report Column On New Line

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

Server Administration :: Window Not Starting OracleserviceORCL On Local Computer?

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

Real Application Clusters :: Database Not Starting Up - Permission Error

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

Server Administration :: New Instance Not Starting / ORA-12547 / TNS / Lost Contact

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

Enterprise Manager :: Oracle 11g Console Not Starting Automatically And Manually?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved