HomeОбразованиеRelated VideosMore From: khaled alkhudari

Solving ORA-01033 oracle initialization or shutdown in progress 12c

59 ratings | 10814 views
Solving ORA-01033 oracle initialization or shutdown in progress 12c select name, open_mode from v$pdbs; Solution 1 Alter pluggable database pdborcl open Solution 2 create or replace TRIGGER pdb_startup AFTER STARTUP ON DATABASE BEGIN EXECUTE IMMEDIATE 'alter pluggable database pdborcl open'; END;
Html code for embedding videos on your blog
Text Comments (37)
Prince Oryema (16 days ago)
Thanks to you
Abo Hamzah (1 month ago)
وعزه جلال الله انك مكانك موش هنا...تسلم
Bhavya Gaur (2 months ago)
King..
احمد محلي (4 months ago)
سهرة كاملة وانا بمشاكل التنصيبرلاوراكل ولكن بعد هذه المعلومة اوجه لك الشكر
PRITHU KUMAR (8 months ago)
Perfect...
Med Jelidi (8 months ago)
Thank you so much, it worked!
Wasim (8 months ago)
its work and thanks sir
Joshua CC (8 months ago)
CREATE OR REPLACE TRIGGER PDB_STARTUP AFTER STARTUP ON DATABASE DECLARE n_nombreConDB VARCHAR2(140); q_queryF VARCHAR2(1000); BEGIN SELECT NAME INTO n_nombreConDB FROM V$PDBS; q_queryF := 'alter pluggable database ' || n_nombreConDB || ' open'; DBMS_OUTPUT.PUT _LINE(q_queryF); EXECUTE IMMEDIATE q_queryF; END;
정동호 (9 months ago)
I'm watching your udemy lectures, and I'd forgotten your tip which is solution 1. So I was in stuck two days(all day long!) looking for Oracle community, facebook, stackoverflow, developer community and finally find this video. the fuc**king ORA-01033 problem was gone. Thank you!. V~ery~ NICE!!
khaled alkhudari (9 months ago)
정동호 Thank you. But also i solved the issue in my course in Udemy
Waleed Abboud (1 year ago)
you are prince
Mohamd zouin (1 year ago)
brother khaled i have this issue always when i want to switch sys user to hr user : ORA-00257: archiver error. Connect internal only, until freed. I have done this steps : shutdown immediate; alter database nomount; alter database mount; alter database clear unarchived logfile group 1; .................................................................group 2; ...............................................................group3; alter database open ; it works and open but next time shut it down and try open it give me same first error . any idea how to fix this error please wachokran
Luis Carlos (1 year ago)
its work. well play.
Steve Mungai (1 year ago)
I managed at last. Resolving errors is part of being a DBA I guess. I bought your 12c course in Udemy to refresh on my SQL skills and it has helped me very much. Tomorrow am starting a new job as a DBA in a Bank and I will keep referencing to the course. Thanks very much Khaled I will keep in touch.
khaled alkhudari (1 year ago)
Steve Mungai You are welcome Thank you so much
Steve Mungai (1 year ago)
I managed at last. Resolving errors is part of being a DBA I guess. I bought your 12c course in Udemy to refresh on my SQL skills and it has helped me very much. Tomorrow am starting a new job as a DBA in a Bank and I will keep referencing to the course. Thanks very much Khaled I will keep in touch.
Vimal Patel (1 year ago)
how to fix ORA-65054: Cannot open a pluggable database in the desired mode ?
هيثم مكية (1 year ago)
استاذ خالد هذه الحلول دائما نستخدمها عندما يرفض الربط هاي اولا الحل الثاني الي انت نفذته نفس الاول اكتبة بال sql dev وما هو فرقه عن الحل الاول
Nida Akram (1 year ago)
hey i am having error at v$pbds
Nida Akram (1 year ago)
i dont know the password of my database which is shown after i ran this database what can i do
khaled alkhudari (1 year ago)
Nida Akram Ok It is v$pdbs
khaled alkhudari (1 year ago)
Nida Akram You should be on the container db The root database Show con_name
Nida Akram (1 year ago)
i am connecting as sys as sysdba in sql plus and i am using 12c but its not recognizing
khaled alkhudari (1 year ago)
Nida Akram U should connect sys as sysdba And this only for 12c Pluggable database is 12c
Braday Siwar (1 year ago)
tutorial oracle forms من فضلك أنا عندي إمتحان عايزة
khaled alkhudari (1 year ago)
Braday Siwar اعذريني انا لا اتعامل مع الفورمز لانها تكنولوجيا عقيمه في جميع المقاييس
Moh Has (1 year ago)
جزاك ربي خير استاذ خالد
Chirag Shah (1 year ago)
can you suggest me the steps to resolve issue
khaled alkhudari (1 year ago)
try to restart your computer first if not working go to start menu in windows and search for services open it and start all services start with oracle
Chirag Shah (1 year ago)
i am unable to open any other connection with same error
khaled alkhudari (1 year ago)
this mean u should start the service manual check component services from windows and see oracle service
Ibrahim Madkor (1 year ago)
وإذا كان الأكونت الماستر DBA يعطي نفس الخطأ وما يفتح عشان نصلح منه الخربان .. ايش نسوي
khaled alkhudari (1 year ago)
صح لسا ما وصلنا لموضوع creating triggers بس راح تفهمو كل شي قريبا بس تبدا في الترجرز اتذكرو انو هذا الكود لازم ينكتب على قاعدة البيانات الرثيسيه الكونتاينر يعني لازم تشبك sys as sysdba
mohammed elsayed (1 year ago)
khaled alkhudari جزاكم الله خيرا
khaled alkhudari (1 year ago)
طبعا لا...مفهوم القواعد الفرعيه فقط في ١٢ في درس عندي بوضح معماريه قواعد البيانات ١٢ موجود في دروس sql 12 c غالبا موجود في اول ٥ فيدوهات
mohammed elsayed (1 year ago)
الكود ده ينفع علي 10g
Ghost Of Iraq (1 year ago)
سلمت يداك

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.