Server Administration :: Oracle 8i Service Did Not Start

Apr 27, 2013

I have oracle8i database on windows 2008 but not a domin server now i have domin server and i want to join this server on domin network i try to join domin it fine but my oracle8i service did not start what to do ?

old hostname=bagmati
afterchange hostname=bagmati.alkatel.org.np

View 3 Replies


ADVERTISEMENT

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

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 Administration :: Oracle Tracing At Stop And Start

Jan 20, 2012

I need to add some kind of tracing in oracle 11g on linux when oracle starts and stops - as at times oracle takes a long time to start.

View 9 Replies View Related

Enterprise Manager :: Console - Could Not Start OracelDBConsoleSID Service?

Feb 25, 2010

I have problem with EM console. When I restart machine OracleDBConsoleSID is stopped.

When I try to start this service:

Could not start the OracelDBConsoleSID service on Local Computer.
Error 1053: The service did not respond to the start or control request in a timely fashion.
And then this service has status: Staring. EM then work for short time but then again service is stopped.

The Database works without any problems.

View 1 Replies View Related

Automatic Storage Management :: How To Start CRS Listener Service / What Is It Used For

Apr 25, 2013

I am not using RAC (to my knowledge), but I installed grid so I can use ASM with my RDBMS.

Recently I noticed that the "CRS Listener" service was not started, when I try to start it then it immediately stops. It does not seem to affect the databases, they are still up and running. What is this service used for and how can I get it to start. I am using Oracle Enterprise Server 11.2.0.3 and Grid 11.2.0.3 on a Windows 2008 R2 64-bit server.

View 2 Replies View Related

Server Administration :: How To Switch Service

Nov 30, 2011

A sid which is using the service1, how can i switch it to the service2.

Select Value
from v$parameter where name='service_names'

VALUE
---------------
service1, service2, service3, service4
SQL> Select service_name From v$session where sid=1980;

SERVICE_NAME
----------------------------------------------------------------
service1

View 4 Replies View Related

Server Administration :: Unable To Start Second Node In RAC

Mar 16, 2011

I have setup a RAC machine of two nodes on Oracle 10GR2(with 10.2.0.4 Patchset). All setup went well. I am able to connect one node from sqlplus but the other node is connected to idle instance. I tried to startup the database with mount and nomount option but it fails. Following is the error :

SQL> startup nomount;
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/LCLCLKS/spfileLCLCLKS.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/LCLCLKS/spfileLCLCLKS.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
SQL>

I am using ASM and it is running on both nodes even I am able to connect the SQL prompt from it. I am able to view the diskgroups I created from the second node but through "asmcmd" option I can't go inside the disk group. It gives :

ASMCMD> ls
DATA/
INDEX/
ASMCMD> cd DATA
asmcmd: diskgroup 'data' does not exist or is not mounted

On first node, everything is fine and I am able to import the database on it, as well.

View 9 Replies View Related

Server Administration :: Getting Error When Start Database 10g

May 4, 2010

I start my database and suddenly got this error:

ORA-00371: not enough shared pool memory, at least 72102521958 bytes

How to fix? I use startup command only and shutdown when shutdown the database.

View 2 Replies View Related

Server Administration :: Cannot Start Listener (/tmp Related)

May 9, 2012

OS: AIX 6.1 64bit
DB: Oracle 10gR2 (10.2.0.5.0)

What we did is..

1. Install patch 6613550 (./rootpre.sh)
2. Install 10.2.0.1 for AIX 64-bit
3. Install 10.2.0.5 Patch Set
4. Create Database
5. Created/Setup LISTENER and TNSNAMES (test connection successful)

After installation of database, everything went well until we tried to restart the server, what happened is that we cannot start the listener, the error was:

TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
IBM/AIX RISC System/6000 Error: 1: Not owner

What i did to resolve this problem is to change the owner of /tmp to oracle, after that i was able to start the listener. ($lsnrctl start) The problem is that our sys admin said that the /tmp directory is being used by the OS and it's owner must be root. But if i return it to root, the listener will not start again. (After server restart)

BTW, our /tmp has enough space so we did not perform the following steps from the installation guidelines:

$TEMP=/directory
$TMPDIR=/directory
$export TEMP TMPDIR

I was thinking if that we must make a temp directory for oracle and set it in the profile, or change the owner to root again and perform this:

$chown -R oracle:oinstall /tmp
$chmod -R 777 /tmp

View 2 Replies View Related

Server Administration :: Create New Service For Database?

Jul 16, 2010

create a new DB service and apply the load , then I need to verify the service load from Enterprise Manager or table V$SERVICEMETRIC .

Below are what I did

Quote:I tried to add service in tnsnames.ora like below

SERVICE = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=25057)(HOST=dadvmc))(CONNECT_DATA=(SID=tgc4)))

/************
Also I tried the serviceName like below, but not working when I conneted SALES1 from sqlplus
SALES1 = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=25057)(HOST=dadvmc))(CONNECT_DATA=(SERVICE_NAME=host.us.xxx.com)))
**********/

and login as

sqlplus scott/tiger@SERVICE[/email][/email]

then lock table EMP in exclusive mode in two session.

I can see the load is added to service SYS$USERS , but I can't see the new service from V$SERVICEMETRIC or Enterprise Manager.

select
SERVICE_NAME
from V$SERVICEMETRIC

How could we create the new DB service?

View 5 Replies View Related

Server Administration :: ORA-12162 / TNS / Net Service Name Is Incorrectly Specified

Apr 21, 2011

I am getting this error , at the time of startup database

ORA-01031: insufficient privileges

ORA-12162: TNS:net service name is incorrectly specified

What may be the cause of this error.

View 3 Replies View Related

Networking And Gateways :: TNS Listener Service Won't Start After Changing (Logon As) Setting

Mar 22, 2010

One of our requirements is to secure the listener and other Oracle services by running them as a local OS account rather than as LocalSystem on the server.

I created a local OS account (assume it's named oracleuser), assigned it to the User and ORA_DBA groups on the server, and then I went to the Local Policies and added oracleuser to "Deny log on locally" and "Log on as a service".

I opened up the Services utility and stopped the four Oracle services we have running (OracleMTSRecoveryService, xxx_home1iSQL*Plus, xxx_home1TNSListener, and OracleServiceMYDB). I changed the "Log on as" for each service to oracleuser with its password (copied and pasted so I know there are no typo's), and restarted the services.

All the services except the listener started up. Attempting to start the listener caused the following error:

"The xxx_home1TNSListener service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."

I tried rebooting the server and had the same result.For now just the listener service has been switched back to logging in as LocalSystem while the other services continue to use the local OS account and the database seems stable, but I do need to figure this out.

View 2 Replies View Related

Server Administration :: Listener Log - No Appropriate Service Handler Found?

May 22, 2012

On last Saturday we encountered error 'TNS-12519: TNS:no appropriate service handler found" in our listener log for some moment of time let say around 5mins and later it got all right itself.

View 3 Replies View Related

Server Administration :: Start Using Data And Index Compression In 11g Database

Jun 27, 2012

We have a requirement from the customer to start using data and index compression in our 11g database.. Is this something available in Oracle 10g,11g without any additional costs? We are not sure if this will work with our application so we will have to test it in-house, is it possible to compress the existing table data/index to test it out?

View 3 Replies View Related

Server Administration :: Trace IP Address And OS Username / Service IP Who Modified Objects?

Sep 4, 2011

I have a problem some user modified the objects and now objects became invalid .How to trace the ip address and operating system username and service ip who modified the objects?

View 3 Replies View Related

Server Administration :: ORA-29702 / Error Occurred In Cluster Group Service Operation

Aug 12, 2010

I have deinstalled Oracle database, ASM and oracle software. I installed the oracle software, ASM and database. I have seen the error in the ASM trace called

Errors in file /opt/oracle/admin/+ASM/bdump/+asm_gmon_10518.trc:

ORA-29702: error occurred in Cluster Group Service operation
ORA-29702: error occurred in Cluster Group Service operation

View 11 Replies View Related

Installation :: Fail To Start OCR And OS / Error When Start OracleCSService

Jun 5, 2012

I'm trying to install Oracle 10g Enterprise Ed. (on Windows 2003 Std. Ed) and I get some errors:

First “Fail to start OCR” I press "continue" and the installation continue. Next “Operative System Error when start OracleCSService” and when I press "continue" the installation finish.

At the end of installation, It seems like Oracle DB is Ok, but not really...I can't connect to database from Enterprise Manager and the OracleCSService is in "Starting mode".

View 3 Replies View Related

Not Able To Start Apache Server?

Sep 11, 2013

Machine details : UNIX machine Solaris 10 OS.I am not able to start the apache server using opmnctl startall command. i am getting the below error message

QUOTE Error
--> Process (pid=823)
failed to start a managed process after the maximum retry limit
Log:
/usr/local/oracle/OH_STANDOHS/opmn/logs/HTTP_Server~1

Even i tried killing the process id = 823 , i am getting the same error message with different process id.

View 1 Replies View Related

Server Administration :: Monitoring Script Required For Oracle 9.2.0.7.0 On Windows 2000 Server

Apr 8, 2010

My manager is asking to create a SQL scrip, which will provide following information.

Our database is 9.2.0.7.0 on Windows 2000 Server

-How many records Insert / Update or Delete daily in my Oracle database?

- Check Archive log / Redo Log switching information?

-Check database growth ?

View 10 Replies View Related

Server Administration :: Installing Oracle Database 10.1.0.2.0 On Windows 2003 Server 64bit?

Jan 11, 2011

i am trying to install Oracle 10.10.2.0 on Windows Server 2003 standard x64 Edition Service Pack, but when i try to run the installer or open DVD it gives me below error.

"The image file D: is Valid, but is for a machine type other than the current machine."

View 1 Replies View Related

Server Administration :: Restoring The Oracle Services In Windows 2008 Server

Jun 27, 2012

I was trying to delete the database in the test server. When i was deleting listener was already stopped, i continued deleting using dbca, it shown me some alert that datafiles cant be deleted because system could't find database, since listner was stopped so only service was deleted(the one showing in the windows administrator toolsservicesOracleServiceTEST).

All the datafile parameter files are still there. How can i delete the datafiles and parameter files belongs to that database or how to create the deleted service, so that i will start the listener and do the complete deleting of the database.

View 3 Replies View Related

Server Administration :: Unable To Find Server Process In Oracle Database For Specific Application / Client

Feb 13, 2013

I am trying to find the unix process for one of my application in the database but I am unable to view the same. To simulate, I did the following.

1. My database runs on different server.
2. I invoked "sqlplus" from another unix box to login to the database.
3. I found that the process id (ps -ef |grep sqlplus).
4. When I execute the below mentioned query it does not display the process id that I am looking for. But the osuser, username, program and machine details are correct. How can I know the process details from the database?

SELECT SYS.GV_$SESSION.OSUSER, SYS.GV_$SESSION.USERNAME, SYS.GV_$PROCESS.SPID,
SYS.GV_$SESSION.MACHINE, SYS.GV_$SESSION.PROGRAM,
SYS.GV_$PROCESS.PROGRAM ,SYS.GV_$SESSION.SQL_ID
FROM
SYS.GV_$PROCESS, SYS.GV_$SESSION
WHERE
SYS.GV_$PROCESS.ADDR=SYS.GV_$SESSION.PADDR and SYS.GV_$SESSION.USERNAME='TEST'
and SYS.GV_$SESSION.MACHINE like '%hostname%'

View 3 Replies View Related

Server Administration :: While Creating Index ORA-00603 / ORACLE Server Session Terminated By Fatal Error

Jul 26, 2010

While creating the index we are getting the error "ORA-00603: ORACLE server session terminated by fatal error".

We have the space in tablespaces and also in the file systesm.

View 13 Replies View Related

Server Administration :: Oracle 11g R2 Installation On Windows 2008 64 Bit Server

Apr 19, 2011

I want to install Oracle 11g R2 in windows 2008 64 bit server. How can I know whether my server is ready to install Oracle ie is all components are available in server or any patch is to be applied etc.

View 3 Replies View Related

Server Administration :: How To Connect Oracle Client To Remote Server DB

Jun 29, 2013

I'm trying to connect a oracle client application on the client machine to a remote oracle server on the server machine but i get a connection fail.

On the server machine I configured oracle server in the following way:

Installed oracle server. Created a database "DB_Test" with the database configuration assistant Created a LISTNER with the Oracle NET Manager with the following parameter:

Protocol: TCP/IP HOST: server pc hostname (ENZOVAIO) or server machine address ip (192.168.0.71) in the network lan Port Number: 1521 Created "dbtest" service with the Oracle NET Manager with with the following parameter:
Service Name: "dbtest" Protocol: TCP/IP HOST: server pc hostname (ENZOVAIO) or server machine address ip (192.168.0.71) in the network lan Port Number: 1521

All services on the server machine are running and I opened port number (1521) in the router. On the client machine I installed SQL PLUS and SQL Developer.

With SQL Plus as by the official documentation I have entered the following command:

CONNECT username/password@[//]host[:port][/service_name]. In my case is:
CONNECT SYSTEM/oracledb@//ENZOVAIO:1521/testdb.

With SQL Developer I have entered the same parameter.

But with both SQLPlus and SQL Developer the connection fails.

View 14 Replies View Related

Server Administration :: Connect 500+ Client To Remote Oracle Server?

Aug 10, 2010

we have oracle server. we have to connect 500+ client machine to oracle server.

is it i need to install client version to all 500+ or any other shortcut way?

View 6 Replies View Related

Server Administration :: Find Or Set New Oracle Instance Name On Backup Server

Sep 22, 2010

We performed image copy of production Oracle server (OS and instances) to a backup server. After a few weeks, we try to restore a latest Oracle database backup from production server to backup server. As we know, Oracle instance must be unique on the network.

Even we log on to backup server and bring up the instance, I think that still point to production instance since all init file, TNSNAMES.ora and listener file are still same. If we restore the database, we will end up bring down the production instance and restore on top of productions. How to change instance name on backup server including TNSNAMES, sqlnet, listener files in order for us to restore Oracle database from production to backup server?

View 2 Replies View Related

Server Administration :: Oracle 10g - Database Server Startup / Shutdown

Jun 29, 2011

I recently installed Oracle 10g on my windows Xp laptop. It has become considerably slow since then. I want to start the database server only when I need it, and not every time I start my laptop. I looked around in OEM and did found a way.

View 5 Replies View Related

Server Administration :: Oracle Database Server - Logon Denied

Jul 19, 2011

I am connected as System. It was the only user I set-up a password when installed the database on personal computer.

SQL> alter user sys identified by mypass007
2 /
User altered.
SQL> connect sys/mypass007
ERROR:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

[code]...

SQL> conn sysoper/mypass007
ERROR:
ORA-01017: invalid username/password; logon denied

View 1 Replies View Related







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