ORA-01033

By
Mis aplicaciones no funcionaban, me salia este error. ORA-01033: iniciacion o detencion de oracle en curso. el problema fue porque habia apagado forzosamente el servidor, y al reiniciarlo me salia este error.

la solucion:

SQL> conn sqlplus as sysdba
ingresas la clave.
SQL>shutdown immediate
SQL>startup mount

la base de datos esta montada, lo que pasa es que al reiniciarla, algunos archivos del redo log se han corrompido, por lo que es necesario un recovery.

SQL>recover database;
SQL>alter database open;

resultará base de datos modificada, y listo.
espero que les ayude, tengo que agradecer a http://aitoreus.blogspot.com/2010/01/errores-oracle-ora-01033-ora-01219-ora.html por su ayuda.

Comments

Post a Comment

Popular posts from this blog

add header image itextsharp c#

By
Image
I thought that when you set the margins on ITextSharp document, you set also the margin for the header. but then I realized the margins are just the margins, and there is no headers by default on ITextSharp. In order to add a header in ITextSharp, you have to use PageEvent. And implement the class HeaderFooterFDA2, you can rename that class. To avoid header overlaps your content, when there are a lot of content that break on a new page. You have to set an additional margin on the method WriteSelectedRows(), in my case I added + 70 units. I hope It helps you.
Read more

How to stop procrastination as a remote developer

By
Procrastination is one of the biggest challenges for remote developers.  The comfort of home and being around family can sometimes lead you to focus on things that aren’t related to your job. Before you know it, the day is nearly over, and you’re left feeling unproductive and frustrated. If you’re struggling with this, here are a few key tips that I recommend to help combat procrastination. Let’s dive in! 1. Identify What Makes You Procrastinate The first step is figuring out what’s actually distracting you. These distractions can be small or big, and sometimes you might not even realize they’re there—they just blend into the background. Identifying them is crucial if you want to avoid them. Advice : Use an app tracker on your laptop and phone to see exactly where your time is going. This helps make those invisible distractions visible. 2. Create a Dedicated Workspace When you’re working from home, shared spaces can easily become sources of distraction. It’s important to have a sep...
Read more