Oracle Error 27121
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 1 2 Previous Next 29 Replies Latest reply on Feb 2, 2012 10:10 AM by Girish Sharma Go to original post This content has been marked as final. Show 29 replies 15. Re: Instance status with UNKNOWN Aman.... Feb 1, 2012 2:06 PM (in response to karti) And the error is? Aman.... Like Show 0 Likes(0) Actions 16. Re: Instance status with UNKNOWN CKPT Feb 1, 2012 2:13 PM (in response to Aman....) .. Edited. @OP, Enter user-name: sys as sysdba Enter password: ERROR: ORA-01031: insufficient privilegesCheck file permissions on ORACLE HOME, What is the contents of sqlnet.ora file. Can you check any more errors in Alert Log file? Edited by: CKPT on Feb 1, 2012 7:41 PM Like Show 0 Likes(0) Actions 17. Re: Instance status with UNKNOWN karti Feb 1, 2012 2:11 PM (in response to CKPT) Also, please note that Im not able to login using sys as sysdba with oracle user. It shows 'Insufficient Privileges'. $ su oracle oracle's Password: $ id uid=206(oracle) gid=202(dba) groups=204(oinstall) $ echo $ORACLE_SID ORATECH $ sqlplus SQL*Plus: Release 10.2.0.3.0 - Production on Wed Feb 1 19:36:48 2012 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. Enter user-name: sys as sysdba Enter password: ERROR: ORA-01031: insufficient privileges Like Show 0 Likes(0) Actions 18. Re: Instance status with UNKNOWN karti Feb 1, 2012 2:18 PM (in response to CKPT) This is the error for last one day in alert log .......... .......... Wed Feb 1 19:41:03 2012 Process m000 died, see its trace file Wed Feb 1 19:41:03 2012 ksvcreate: Process(m000) creation failed Wed Feb 1 19:42:04 2012 Process m000 died, see its trace file Wed Feb 1 19:42:04 2012 ksvcreate: Process(m000) creation failed Wed Feb 1 19:43:05 2012 Process m000 died, see its trace file Wed Feb 1 19:43:05 2012 ksvcreate: Process(m000) creation failed Like Sho
and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing https://community.oracle.com/thread/2342685?start=15&tstart=0 NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process and OperationsSourcing and https://scn.sap.com/thread/718585 ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverviewBusiness IntelligencePredictive AnalyticsGovernance, Risk, and ComplianceEnterprise Performance ManagementApplication Platform and InfrastructureOverviewApplication PlatformContent and CollaborationInterface ManagementProcess Management and IntegrationData ManagementOverviewBig Data on HadoopData WarehousingDatabase ManagementEnterprise Information ManagementIT ManagementOverviewApplication Lifecycle ManagementIT Infrastructure ManagementSecurity SoftwareOverviewApplication and IT Infrastructure SecurityIdentity, Access and Authentication ManagementBrowse by ProductAnalyticsConte
ORA-27121: unable to determine size of shared memory segment [message #297610] Fri, 01 February 2008 12:55 monto Messages: 60Registered: November 2007 Location: DALLAS Member Hi , I am facing the below http://www.orafaq.com/forum/t/96598/ error when trying to connect through sqlplus client, but can logon to database http://oracleinstance.blogspot.com/2009/07/ora-27121.html locally . sqlplus testq@test.com SQL*Plus: Release 8.1.7.0.0 - Production on Fri Feb 1 18:18:49 2008 (c) Copyright 2000 Oracle Corporation. All rights reserved. Enter password: ERROR: ORA-01034: ORACLE not available ORA-27121: unable to determine size of shared memory segment HP-UX Error: 13: Permission denied But can connect locally. ORACLE_BASE=/oracle ORACLE_SID=test oracle error PS1=[${ME}:${UNAME}:${ORACLE_SID}] ${PWD} > ORACLE_ADMIN=/oracle/admin ORACLE_HOME=/oracle/product/8.1.7ee sqlplus testq SQL*Plus: Release 8.1.7.0.0 - Production on Fri Feb 1 18:18:22 2008 (c) Copyright 2000 Oracle Corporation. All rights reserved. Enter password: Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production With the Partitioning option JServer Release 8.1.7.4.0 - 64bit Production SQL> show user USER is "testq" Permission on oracle [testA:server:test] /oracle/product/8.1.7ee/bin > ll oracle -rwxrwx--- 1 oracle error 27121 oracle testdba 38264760 Sep 14 23:30 oracle NOTE:database created user(testA) is different from the one who own the binaries(testB) but belongs to same dba group. owner of binaries id uid=117(testB) gid=105(testdba) groups=104(dba) owner of db id uid=122(testA) gid=105(testdba) groups=104(dba) Please any suggestions would be great. Report message to a moderator Re: ORA-27121: unable to determine size of shared memory segment [message #297611 is a reply to message #297610] Fri, 01 February 2008 13:01 BlackSwan Messages: 24958Registered: January 2009 Location: SoCal Senior Member I suspect the listener.ora has a problem; possibly a incorrect ORACLE_HOME. Report message to a moderator Re: ORA-27121: unable to determine size of shared memory segment [message #297613 is a reply to message #297610] Fri, 01 February 2008 13:17 monto Messages: 60Registered: November 2007 Location: DALLAS Member Here is my listener.ora. STARTUP_WAIT_TIME_LISTENER_SERVER = 0 SID_LIST_LISTENER_SERVER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = orcldb.kk.xxx.com) (ORACLE_HOME = /oracle/product/8.1.7ee) (SID_NAME = orcldb) ) (SID_DESC = (GLOBAL_DBNAME = test.kk.xxx.com) (ORACLE_HOME = /oracle/product/8.1.7ee) (SID_NAME = test) ) ) LISTENER_SERVER = (ADDRESS_LIST = (ADDRESS =(HOST = SERVER.kk.xxx.com)(PROTOCOL = TCP)(PORT = 1131)) ) CONNECT_TIMEOUT_LISTENER_LISTENER_SERVER = 10 CONNECT_TIMEOUT_LIST
- txnmgrPassword:DEV:/d02/txnmgr>sqlplusSQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 24 17:15:40 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.Enter user-name: ftuserEnter password:ERROR:ORA-01034: ORACLE not availableORA-27121: unable to determine size of shared memory segmentLinux Error: 13: Permission deniedsolution:ORACLE:/home/oracle>cd $ORACLE_HOME/binORACLE:/d01/app/oracle/product/10.2.0/db_1/bin>chmod 6751 oracleORACLE:/d01/app/oracle/product/10.2.0/db_1/bin>Enter user-name: ftuserEnter password:Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsSQL> select * from dual;D-X Posted by Rajeshkumar Govindarajan at Friday, July 24, 2009 Labels: ora error solutions No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) There was an error in this gadget all documents have been done in my testing environment. If you find any mistakes, please inform me to rectify my mistakes. Thanks for reading my blog post and your appreciation.Rajeshkumar Govindarajan."knowing is knowledge" "Do something (anything). If you don't do anything, you won't get anywhere. Make it your hobby, not a chore, but above all have fun!" Google Blog Search Archives ► 2014 (1) ► January (1) ► 2012 (6) ► September (1) ► May (1) ► February (1) ► January (3) ► 2011 (7) ► October (1) ► September (1) ► August (2) ► May (1) ► April (1) ► January (1) ► 2010 (45) ► November (1) ► October (3) ► September (2) ► August (11) ► July (10) ► June (1) ► May (7) ► April (1) ► March (2) ► January (7) ▼ 2009 (58) ► December (21) ► November (11) ► October (4) ► August (8) ▼ July (4) sysdate in oracle database Triggers ORA-27121 ora-00054 error ► May (7) ► April (3) defeat the defeat before defeat defeats you. "Give a man a fish and you feed him for a day.Teach aman to fish and you feed him for a lifetime." Popular Posts Step b