Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator
57 Search Results Found
1 Forum: Client Tools «» Posted on: Thu, 01 November 2018 07:20 «» By: mcdinesh.200@gmail.com
Re: SP2-0667: Message file sp1<lang>.msb not found
As you said, I removed the variable ORACLE_HOME and kept only path as C:\oraclexe\app\oracle\product\11.2.0\server Then I kept Client directory path in Path variable. C:\instantclient-basic-windows.x64-11.2.0.4.0\instantclient_11_2\ Now, when I trie...
2 Forum: RAC & Failsafe «» Posted on: Thu, 17 May 2018 10:50 «» By: sarahLian
Root.sh failed: ORA-39510: CRS error performing start on instance '+ASM1' on '+ASM'
Hello, I have some issues with the installation of Oracle RAC 12.2 on RHEL 7. Could you please help me with this issue ? Thanks in advance. The root.sh failed with the following error: ORA-39510: CRS error performing start on instance '+ASM1' on...
3 Forum: Linux «» Posted on: Thu, 03 August 2017 00:57 «» By: chrisindya
Re: Not able to connect SQLPLUS in Susi Linux OS
Hi Michel, Thanks for helping me.. I deleted the spfileoracle.ora and pasted the given initoracle.ora Then I tried to connect as SYS in SQL*PLUS below error is throwing.. oracle@ip-10-13-228-206:/home/oraclecloud/app/oraclecloud/product/11...
4 Forum: Linux «» Posted on: Wed, 02 August 2017 23:39 «» By: chrisindya
Re: Not able to connect SQLPLUS in Susi Linux OS
Hi Michel, Results of the same commands with "oracle" user as below. Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORA-01078: failure in processing system parameters LRM-001...
5 Forum: Server Administration «» Posted on: Sat, 15 July 2017 04:16 «» By: kaos.tissue
Re: Unable to connect to Oracle DB (11g R2)
C:\Users\abc>sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Sat Jul 15 14:44:56 2017 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to an idle instance. SQL> alter database close 2 ; alter database ...
6 Forum: Server Administration «» Posted on: Sat, 15 July 2017 02:27 «» By: kaos.tissue
Re: Unable to connect to Oracle DB (11g R2)
C:\Users\abc>sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Sat Jul 15 12:56:25 2017 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total Sy...
7 Forum: Server Administration «» Posted on: Sat, 15 July 2017 02:14 «» By: kaos.tissue
Unable to connect to Oracle DB (11g R2)
I have been trying to connect to the Oracle DB using sqlplus and sql developer too but both are unable to connect. When I try to connect, it gives me the following error. Yesterday windows update took place and after that it has been not working. C:\Use...
8 Forum: Server Administration «» Posted on: Thu, 16 March 2017 05:51 «» By: degalavenu
Calling exp from a shell script throws ora-01034
getting the error where running schedule in linux os Subject: Cron <root@localhost> su - oracle /home/oracle/DIALYBACKUP/backup.sh Content-Type: text/plain; charset=UTF-8 Auto-Submitted: auto-generated X-Cron-Env: <SHELL=/bin/sh> X-Cr...
9 Forum: Unix «» Posted on: Wed, 15 February 2017 05:07 «» By: tsar
Re: Getting errors when starting listener
Hi John I have renamed the alert_AMP.log to alert_AMP.log.org [code] SVRMGR> connect internal Connected. SVRMGR> SVRMGR> shutdown abort; ORACLE instance shut down. SVRMGR> SVRMGR> select status from v$instance; select status f...
10 Forum: Networking and Gateways «» Posted on: Thu, 28 July 2016 05:05 «» By: ganesh_sun87@yahoo.co.in
Re: TNS-12541 TNS no listener issue
hi gazzag, thanks for responding this is what i am getting for the command you mentioned C:\>sqlplus infodba/infodba@PEP as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 28 15:32:39 2016 Copyright (c) 1982, 2010, Oracle. All...
11 Forum: Linux «» Posted on: Sun, 26 June 2016 00:10 «» By: rdangelojp7
Re: no more data to read from socket error
ok, here's the entire database startup process: ricardo@ricardo-Satellite-L305:~$ sudo su --login oracle [sudo] password for ricardo: oracle@ricardo-Satellite-L305:~$ lsnrctl start LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 26-JUN-2016 12:...
12 Forum: Linux «» Posted on: Sat, 25 June 2016 20:26 «» By: Michel Cadot
Re: no more data to read from socket error
As I said, do NOT use SYS. SYS is special, anything you do with SYS can prove or not prove what will happen with another account. The error "ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such fi...
13 Forum: Linux «» Posted on: Sat, 25 June 2016 19:09 «» By: rdangelojp7
Re: no more data to read from socket error
OK, I started the listener before the DB, and checked the services with $ lsnrctl services, with this output: $ lsnrctl services LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 24-JUN-2016 21:06:46 Copyright (c) 1991, 2005, Oracle. All rights r...
14 Forum: Linux «» Posted on: Sat, 21 May 2016 06:53 «» By: Prathikesh
ORA-01034: ORACLE not available
Dear Team, We are facing the below issue in one of the production database in the peak load. Can any one suggest to get out of this issue? Error Details: ORA-01034: ORACLE not available. ORA-27102: out of memory Linux-x86_64 Error: 12: cannot ...
15 Forum: Client Tools «» Posted on: Thu, 18 February 2016 08:53 «» By: manjuds93
ORA-44412: XE edition memory parameter invalid or not specified
Hi All, kindly help I getting this error once my server got restarted due to some issue. and not able to up my database. Can anyone help me.. SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 18 20:19:26 2016 Copyright (c) 1982, 2005, Oracl...
16 Forum: Server Administration «» Posted on: Tue, 06 October 2015 01:19 «» By: Eric Langager
Re: Cannot start Oracle -- unable to find file
Thanks for that information, John. Somehow I had it in my mind that you couldn't do that from an idle instance. To be honest, I don't know if I have ever tried it from an idle instance, but I just did it now and it works. That's really good to know, beca...
17 Forum: Server Administration «» Posted on: Thu, 09 April 2015 06:17 «» By: ashishkumarmahanta80
ORA-27101: shared memory realm does not exist
Dear All, Database is of oracle XE. When executed the below script - alter system set memory_max_target=460235776m scope=spfile; after shutdown of database, while trying to loging, below error occurred. Enter password: ERROR: ORA-01034:...
18 Forum: Linux «» Posted on: Wed, 11 March 2015 13:55 «» By: SBlancher
Re: Moved Database Directory, Connected to Idle Instance
The exact same as before. The oracle-xe service is started on boot. That is kind of the problem, the instance that exists is idle. Then when I attempt to startup it is trying to start a new instance (which isn't allowed in XE). As well, when you try any ty...
19 Forum: Linux «» Posted on: Wed, 11 March 2015 11:35 «» By: SBlancher
Moved Database Directory, Connected to Idle Instance
So I will start off by stating I have moved the regular install location of Oracle 11.2 XE to a logical volume (/oracle) I had created on my RHEL 6.6 server. After shutting down both the database and the Oracle listener, I performed... $ cp -R /u01/...
20 Forum: Windows «» Posted on: Fri, 25 July 2014 14:31 «» By: thelearner
ORA-01034,ORA-27101
SQL> connect system/Manager; ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Am getting above error after installing the Oracle Release 10.2.0.1.0. Please suggest me on this issue
21 Forum: RAC & Failsafe «» Posted on: Tue, 15 April 2014 10:30 «» By: asp_
Re: RAC +ASM instance
As I understand from manuals, tutorials and forums, for example if I want to resize my diskgroup, i need connect to db using sid +ASM (in my case it's +ASM2). oracle[10.2.0:SID:docu112]@rac2-n1:/u01/dbhome_1/product/db/10.2.0/dbs$ sqlplus / as sysdb...
22 Forum: Server Administration «» Posted on: Sat, 05 April 2014 02:00 «» By: John Watson
Re: Shared memory realm does not exist
Is this your error,orclz> orclz> shu abort ORACLE instance shut down. orclz> orclz> orclz> orclz> conn scott/tiger ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Process ID: 0 Session ID: 0...
23 Forum: Server Administration «» Posted on: Fri, 04 April 2014 22:39 «» By: alijeyan
Shared memory realm does not exist
Hi I keep receiving ORA-27101 with ORA-01034 after I tried connect to database on server . I use Oracle 11 g on Win2007 server .
24 Forum: Client Tools «» Posted on: Sat, 22 March 2014 06:09 «» By: Vivek21
[oracle 10g] ora-27101 shared memory realm does not exist windows xp
I am getting following error on executing this command sql>connect system password : ora-01034: ORACLE not available ora-27101: shared memory realm does not exist windows >lsnrctl status LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - P...
25 Forum: Server Administration «» Posted on: Wed, 19 March 2014 10:34 «» By: lmontejo
Re: ORA-01034: ORACLE not available (some users only)
Good try, but it's the same: eoc@zpecas:>id uid=201(eoc) gid=201(dba) eoc@zpecas:>groups dba soc eoc@zpecas:> eoc@zpecas:>sqlplus energia3/energia3 SQL*Plus: Release 8.1.6.0.0 - Production on Mi� Mar 19 16:39:22 2014 (c) Copyright 1...
26 Forum: Server Administration «» Posted on: Wed, 19 March 2014 06:39 «» By: lmontejo
ORA-01034: ORACLE not available (some users only)
Hi, I know I'n runnig a very old version, but i'ts the client choice. I'm getting ORA-01034 error when trying to connect locally to the DB with some unix users, but it works with others. eoc@zpecas:>sqlplus energia3/energia@zpecas SQL*Plus: Rele...
27 Forum: Enterprise Manager «» Posted on: Wed, 05 February 2014 07:43 «» By: Dylz
Oracle 11g Ora error ORACLE not available
Hi I am having a problem connecting to our database, we use an Oracle tool called Oracle Enterprise Data Quality(OEDQ), which we just did an upgrade on, and after the upgrade we ran some data through for testing and it froze halfway through the process ...
28 Forum: Backup & Recovery «» Posted on: Sat, 07 December 2013 14:44 «» By: amjad_alahdal
Error in logging in
Hello guys,,, while I was deleting some not needed files from my computer. I accidentally deleted a file that is an ORACLE file. Now, whenever I try to log in to my database, it shows me this error. ERROR - ORA-01034: ORACLE not available ORA-27101: ...
29 Forum: Client Tools «» Posted on: Sat, 26 October 2013 08:08 «» By: corn_pops
Re: ora-01034 for users other than oracle
Thanks for your fast reply Lalit. I really appreciate it I had followed some replies I saw there, but still no luck after reboot listener and oracle instance, I keep getting the same error with non-oracle users [metro_ctl@LX-TSC2 ~]$ sqlplus me...
30 Forum: Client Tools «» Posted on: Sat, 26 October 2013 07:00 «» By: corn_pops
ora-01034 for users other than oracle
Hello. I am having an issue when trying to connect local through SQLPLUS. If I login to sqlplus using oracle user everything is fine, I,m able to login to the database which is already opened and mounted. But if I try to login to sqlplus with another li...
31 Forum: Server Administration «» Posted on: Mon, 07 October 2013 06:32 «» By: oracle_doubt
ORA-01034: ORACLE not available ORA-27102
Hi all, I am facing ORA-01034: ORACLE not available ORA-27102 error.Please do needful
32 Forum: Server Administration «» Posted on: Tue, 24 September 2013 05:29 «» By: swethaalampally
ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist
Hello, I am facing problem with oracle 11g database, i am continuesly inserting data to oracle database after some time like 2 hours oracle disconnects,it creates erros like ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm d...
33 Forum: Server Administration «» Posted on: Mon, 09 September 2013 00:17 «» By: robdba
Re: Idle Instance issue
SQL> desc v$diag_info ERROR: ORA-01012: not logged on ------------------------------------ SQL> show parameter background ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0 This is what I get...
34 Forum: Networking and Gateways «» Posted on: Thu, 08 August 2013 18:57 «» By: sa_dwhite
listener issues
I tried to log on today to one of my databases and get a TNS Timeout error. ran a ps-aef | grep oracle and noticed that the listener was not up. I tried to restart it but got the following error $ lsnrctl start LSNRCTL for Linux: Version 10.2.0.3.0 ...
35 Forum: Client Tools «» Posted on: Sat, 13 July 2013 11:44 «» By: bhanu6us
ORA-01034:Oracle not available
Hi All, I am trying to login to 10g sqlplus , gives below error: ORA-01034:Oracle not available ORA-27101-shared memory does not exist Need assistance and resolution for this .Please let me know the steps to resolve . Thanks, Bhanu
36 Forum: Server Administration «» Posted on: Thu, 16 May 2013 23:39 «» By: sky-qin
ORA-01034 received when to install
when xp is installing oracle 10.1 display a error ORA-01034 windows xp:memory 1.7G
37 Forum: Server Administration «» Posted on: Tue, 05 March 2013 23:25 «» By: swathi.shilpa
Re: Oracle Database Connection Error
Attaching the screen output from terminal **File1:"output"...This is taken when am connected as user where am getting the error acgx0456>$ echo $ORACLE_SID ac2e acgx0456>$ sqlplus / SQL*Plus: Release 10.2.0.4.0 - Production on...
38 Forum: Server Administration «» Posted on: Tue, 05 March 2013 22:37 «» By: swathi.shilpa
Oracle Database Connection Error
Hi All, While after connecting to server via my userid( its an externally id) ,after setting ORACLE_HOME and SID, while entering sqlplus / command,its not connecting.Error am getting is:- ERROR: ORA-01034: ORACLE not available ORA-27123: unable to...
39 Forum: Server Administration «» Posted on: Thu, 17 January 2013 05:57 «» By: x-oracle
Re: ORA-01034: Oracle not available; ORA-27101: shared memory realm does not exist (split from hijacked thread)
hello i also got this same error michel but i did this steps and my database open successfully in archive mode but i did this step C:\Users\Administrator>sqlplus SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jan 17 15:59:33 2013 Copyright...
40 Forum: Networking and Gateways «» Posted on: Mon, 10 December 2012 20:20 «» By: devenz
Re: NL-00280: error creating log stream
Any help you can get me here? ERROR: ORA-01034: ORACLE not available ORA-27121: unable to determine size of shared memory segment
Pages (2): [1  2    »]

Current Time: Wed Jun 19 05:00:44 CDT 2019