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


ADVERTISEMENT

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

Windows :: Unable To Install Oracle 11gR2 On Win 7 Professional?

Mar 28, 2012

I am trying to install Oracle 11g R2 on Windows 7 professional at the time of database creation they give error.

ORA-12638:Credential retrival failed.

View 9 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

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

TNSListener Service Stops Automatically?

Apr 7, 2011

In our production server, TNSListener Service stops automatically, atleast (once in a day). No alert in alert log file.

View 1 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

ODP.NET :: Creating Windows Service

Jul 20, 2012

I have created a program to access a oracle database using oracle.data access, .net framework 4, visual studio 2010 in C#. The program runs without any problem. If I try to create a windows service, I receive the error

Service cannot be started. System.BadImageFormatException:
Could not load file or assembly 'Oracle.DataAccess, Version=2.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies.
An attempt was made to load a program with an incorrect format.
File name: 'Oracle.DataAccess, Version=2.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342'

when i execute the command

GlobalVariables.conn = new OracleConnection(oracelString);

View 3 Replies View Related

Windows :: Oracle Service Doesn't Start

Oct 3, 2012

I've installed oracle 11.2 in Windows 7 - 64 bits. Everything was working fine until suddenly stops working. Oracle Service (OracleServiceORCL) doesn't start and when I try to start manually, returns OS error 1067. Listener starts well. Below I list my listener.ora, sqlnames.ora and sqlnet.ora

# listener.ora Network Configuration File: C:appmbaproduct11.2.0dbhome_1
etworkadminlistener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =

[code]....

View 3 Replies View Related

Security :: Wallet For Each Windows (service) User

Apr 4, 2013

Is there a way to have separate wallets for each windows user? Well, I have found a way, but does not seem to work always properly and that is with %USERNAME% environment variable.

This is how our customer want's to have - so separate wallet for each windows user, how to accomplish this without using %USERNAME%?

View 2 Replies View Related

TNS Listener Service Disappeared After Restart Windows 7 X64 Oracle 11g

Dec 22, 2012

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.

View 4 Replies View Related

NESTED ERROR When Making Admin Server A Windows Service?

May 6, 2013

I created a script to make my admin server a windows service. I successfully made it a service but when it starts it then shuts itself down. i ran a debug and found a error. I dont get what to do. I have tried changing the variables in the script and try it over and over again .....here is my script code and here is the error i got from debug output:

script

SETLOCAL
set DOMAIN_NAME=FRClassicDomain
set USERDOMAIN_HOME=C:/Oracle/Middleware/user_projects/domains/FRClassicDomain
set SERVER_NAME=FRweblogic

[Code]....

View 1 Replies View Related

Server Utilities :: DIM 00014 - Cannot Open Windows NT Service Control

May 10, 2010

When I am creating service for oracle using oradim Utility ,following messsage appearing

F:Users>oradim -new -sid stby -startmode manual

DIM-00014: Cannot open the Windows NT Service Control Manager.
O/S-Error: (OS 5) Access is denied.

View 9 Replies View Related

Installation :: 11g On Windows 2008 R2 - Unable To Start Oracle Service

Aug 30, 2012

I tried to reinstall oracle 11g on windows 2008 R2 and couldn't complete the installation as i am unable to start the oracle service. The system gives the following error message

Instance created.
DIM-00019: create service error
O/S-Error: (OS 1053) The service did not respond to the start or control request
in a timely fashion.

I try to manually create the service and it gives me the same error.I also tried to start the service using the net start as follows

C:UsersAdministrator>net start oracleserviceprod
The service is not responding to the control function.

Having looked at the event viewer in windows, I noticed three different error messages as followsr

Application popup: Microsoft Visual C++ Runtime Library : Runtime Error!

Program: c:appadministratorproduct11.2.0dbhome_1inORACLE.EXE

R6034
An application has made an attempt to load the C runtime library incorrectly.and then A timeout was reached (30000 milliseconds) while waiting for the OracleServiceprod service to connect.

The OracleServiceprod 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 26 Replies View Related

Server Utilities :: Import Dump Into Oracle 10.2.0.3.0 Database On Win 7 Professional Laptop

Nov 12, 2010

I am trying to import a dump into my oracle 10.2.0.3.0 database on my win 7 professional laptop. The dump is exported from my win xp desktop pc running Oracle 10.2.0.1.0

Below is the error i get:

Import: Release 10.2.0.3.0 - Production on Fri Nov 12 15:57:52 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Username: system/password@orcl

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

Import file: EXPDAT.DMP > F:PersonalDPISIMBA.dmp

Enter insert buffer size (minimum is 8192) 30720>

Export file created by EXPORT:V10.02.01 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no >

Ignore create error due to object existence (yes/no): no >

Import grants (yes/no): yes >

Import table data (yes/no): yes >

Import entire export file (yes/no): no >
Username:paymaster

Enter table<T> or partition<T:P> names. NULL list means all tables for user
Enter table<T> or partition<T:P> name or . if done:

when I press enter key, the console hangs and a window appears with "Console Window Host has stopped working" then the console closes prematurely.

View 1 Replies View Related

Forms :: Access To Professional Dataloader But Not To Forms Playback?

Jan 17, 2012

We have access to Professional Dataloader but not to Forms Playback? what Forms Playback functionality would enable to do and why you think this access has been stopped (something to do with accessing Unix) - we are working with a third party

If we have paid for 2 licenses for Professional Dataloader should we have Forms playback?

View 1 Replies View Related

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 View Related

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

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

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







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