Error 1403 Happened During Db Open Shutting Down Database
does not open! If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 8 of 8 Thread: Oracle does not open! Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 08-07-2002,10:15 PM #1 Mnemonical View Profile View Forum Posts Senior Member Join Date Dec 2001 Location Brazil Posts 282 Oracle 9i Release 2 Linux Red Hat 7.2 I created a database without dbca and everytime I try to startup I get the following error: ORA-01990: error opening password file ' home/dba/OraHome/dbs/orapw' ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 then it stops on mount. When I try to open the db, I get: ORA-01092: ORACLE instance terminated. Disconnection forced. dbca also gets disconnected when it tries to open the database. What should it be? F. Reply With Quote 08-07-2002,11:20 PM #2 SANJAY_G View Profile View Forum Posts Senior Advisor Join Date Feb 2000 Location Singapore Posts 1,758 Cheack these things.. 1. Do you have ROMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE in init.ora? 2. Have you created password file? 3. is the name of pwfile correct? HTH Sanjay Reply With Quote 08-08-2002,11:07 AM #3 Mnemonical View Profile View Forum Posts Senior Member Join Date Dec 2001 Location Brazil Posts 282 1. Do you have ROMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE in init.ora? YES 2. Have you created password file? YES 3. is the name of pwfile correct? $./orapwd file=/home/dba/OraHome/dbs/pwdcti.ora password=oracle my instance name is cti. the funny thing is that connect sys/pass as sysdba accepts any password, if I type connect sys/nothing as sysdba it connects to the instance. F. Reply With Quote 08-08-2002,11:15 AM #4 khussain View Profile View Forum Posts Senior Member Join Date Sep 2000 Location Chicago, IL Posts 316 Password file name is INCORRECT: $./orapwd file=/home/dba/OraHome/dbs/pwdcti.ora password=oracle SHOULD BE: $./orapwd file=/home/dba/OraHome/
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Unable to create 9i database manually Want to Advertise Here? Solved Unable to create 9i database manually Posted on 2012-04-18 Oracle Database 1 Verified Solution 4 Comments 431 Views Last Modified: 2012-04-23 http://www.dbasupport.com/forums/showthread.php?28082-Oracle-does-not-open! Dear Gurus, I have an application that needs only 9i. I am trying to create database manually. the database is created but unable to open , Instance getting terminated forcefully throwing error as below, SQL> startup force mount; ORACLE instance started. Total System Global Area 1242650240 bytes Fixed Size 456320 bytes Variable Size https://www.experts-exchange.com/questions/27681394/Unable-to-create-9i-database-manually.html 922746880 bytes Database Buffers 318767104 bytes Redo Buffers 679936 bytes Database mounted. SQL> alter database open; alter database open * ERROR at line 1: ORA-01092: ORACLE instance terminated. Disconnection forced My alert log says, Errors in file /**/**/admin/udump/pfs_ora_19029.trc: ORA-01403: no data found Error 1403 happened during db open, shutting down database USER: terminating instance due to error 1403 Instance terminated by USER, pid = 19029 ORA-1092 signalled during: alter database open... this trace files says. "/**/**/admin/udump/pfs_ora_19029.trc" [Read only] 42 lines, 1513 characters /**/**/admin/udump/pfs_ora_19029.trc Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production JServer Release 9.2.0.8.0 - Production ORACLE_HOME = /**/**/orahome System name: SunOS Node name: ****** Release: 5.10 Version: Generic_142900-09 Machine: sun4u Instance name: pfs Redo thread mounted by this instance: 1 Oracle process number: 8 Unix process pid: 19029, image: oracle@****(TNS V1-V3) *** SESSION ID:(7.3) 2012-04-18 09:24:47.825 Thread 1 recovery from rba:0x000001.000056b4.0010 scn:0x0000.00001932 ----- Redo read statistics for thread 1 ----- Read rate (ASYNC): 149Kb in 0.13s => 0.00 Mb/sec Longest record: 16Kb, moves: 0/782 (0%) Chang
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/ora03113-endoffile-on-communication-channel-200961 Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX Inside-ERP VoIP_News Inside-CRM maxwellarnold PCMag I_am_the_dragon Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate DukeGanote Dennis error 1403 Stevenson Craig Borysowich Richard mircea_luca Nikki Klein AbhaiTripathi knowscognosdoi Clinton Jones blrvenkat bluesguyAZ59 iudithm COMPANIES RSA Conference UC4 Apperian Sophos View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Database This group is where peers share technical expertise, solve problems, and discuss issues related to error 1403 happened the use of Oracle Databases, including Oracle Grid. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. ORA-03113: END-OF-FILE ON COMMUNICATION CHANNEL User84024 asked Jan 23, 2003 | Replies (27) hi all, i am installing oracle 8.1.6 on w2k professional edition , during the database creation i am getting this error ora-03113: end-of-file on communication channel same thing happens when i create the database using database configuration assistant. i will be thankful if someone