Step by Step Oracle guides
Here, I’ve collected all my “Step by Step Guides” which help you to understand basic concepts very easily
Installing CentOS on VMware – Step by Step
Step by Step installing Oracle 10g RAC on VMware
Step by Step installing Oracle 11gR2 on Oracle Solaris 10
Step by Step installing Oracle 11gR2 on OEL 5.5
Step by Step Installing Oracle Database 10gR2 on Oracle Solaris 10
tejas patel said
my goal is made a oracle DBA.so please help me…
Kamran Agayev A. said
I’d suggest you to read the following article written by Turkish Oracle Expert – Tonguc Yilmaz
http://tonguc.files.wordpress.com/2009/06/oracle-introduction-for-newbies.doc
Mohammed.Ateeq said
Hi Kamran,
I am a newbie in oracle. I have installed VMWare workstation 7 on windows and my guest OS is Linux ES3. I have installed Oracle 10g Rel2 on the guest OS. Most of the things r working f9, except the RMAN. It hangs up when i enter RMAN at command prompt. Please suggest how to proceed. DO i need to check Bash Profile or some other area.
Thank You
Kamran Agayev A. said
Hi Mohammad
When you change PATH environment variable and add $ORACLE_HOME/bin directory to it, and when you issue rman target / command, system looks for rman executable in all directories which were registered at the PATH environement variable. There’s an rman executable (non-Oracle rman) at the folder /usr/X11R6/bin and it comes before $ORACLE_HOME/bin directory at the PATH environement variable, so system runs that file.
So you need to define $ORACLE_HOME/bin directory at the beginning of PATH environement variable and run rman target / command as follows
export PATH=$ORACLE_HOME/bin:$PATH
rman target /
Please let me know if you have solved this issue
Good Luck
Praneeth said
hi kamran,
I cleard (java)SCJP,SCWCD certifications.now i want to oracle certification.can you tell me.which certification exam is suitable for me(sql queries). and how can i prepare step by step clearly.
thank you.
Narsing said
Hi Kamran,
Iam having 3years of experience in app testing,Now i made my mind to work on a better technology and completed RHCE/OCP 9i but i dnt have any realtime knowledge. Can you tell me how to make my subject strong so that i can put 2years of experience as a oracle Dba.
Thank You…
Kamran Agayev A. said
Dear Narsing
I have only one suggestion: “You have to test everything you know. You have practice everything you learn” After making a lot of practicec and being OCP you can start as a junior DBA in any company you’re invited. Why I say junior because you haven’t real time practice. And after working as a junior DBA in any company whicih uses Oracle database, you’ll be assigned a lot of tasks and thus improve yourself
Good Luck!
zindaba said
hi firstly i want to thank you for the help you giving to us new dbas,i managed to install oracle 10g database after following your guide. now i need help on to install apex on the same database. so you have another step by step guide for that.
regards
Kamran Agayev A. said
Dear Zindaba
Unfortunately I haven’t such step by step instruction on APEX installation, but you can check the following link:
http://tinyurl.com/y7qhzk6
Narsing said
Hi Kamran,
How are you , Thank you very much for helping me out. Iam having a doubt .
What are the main advantages of creating DATABASE manully . And hw to allocate SGA to a particular user.
Regards,
Narsing
Kamran Agayev A. said
Dear Narsing
There might some circumstances where you might not be able to use GUI to create a required database. In such situations, the manual creation might be useful
According to the question on allocation SGA to particular user, I’d suggest you to use profiles (PRIVATE_SGA)
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_6010.htm#SQLRF01310
Narsing said
Hi Kamran,
Hello Big Bro, The information which you had provided is really good but its very high level for me to understand i think unless any realtime experience i cannot understand.
Can you suggest me how to practice real time at home on network iam having 2 systems. The reason why iam asking this is because lot of my friends are good at concepts but when it comes to implementation stage the cannot explain why it is like that.
Kamran Agayev A. said
Dear Narsing. I thinkg it’s not so high level as you have mentioned. It’s just step by step explanations. I can’t make it more easy 🙂
Let me know what problem you face. You can ask your question on OTN forums or drop me an e-mail
Narsing said
Hi Kamran,
Hey Bro How are you i did not mean that i did not understand. Ok Let me be perfect actually as in my first post i told that iam having 3 years of exp in TESTING and as i dnt have any realtime exp on Oracle DBA iam not getting any calls so i planned to put an experience of 2years as a junior DBA and try but as you know that having knowledge and working in real time environment will be total different. And the question which i asked was based on this. In 1 of the interview they asked me
How u manage sga,
What was your role as a junior dba,
Why you need pga,
What is database cloning,
Do u have knowledge on RAC,
How many databases did you maintained ,
On which database you worked i.e dev or testing,
what kind of errors u faced with respect to developers.
So Brother what exactly i want to know from you is the above mentioned points how can i practice at home with the help of two systems .
And bro People like you make life easy for people like us. And by browsing your blog iam building confidence day by day. I learnt many things.And iam very thankful to YOU.
Vaibhav Marathe said
I want to start up with the Oracle can you guide me how to start with Oracle. I want to be a Database Administrator.
Kamran Agayev A. said
Dear Vaibvah
I’d suggest you to read Tonguc Yilmaz’s article from the following link:
http://tonguc.files.wordpress.com/2009/06/oracle-introduction-for-newbies.doc
Good Luck!
justin said
hi kamran
can u pls send the datapump architecture and work wrounds will be great help for me
ur job is fantastic
justin
Kamran Agayev A. said
Hi Justin
Just check the following link from the documentation and you’ll get much more information on Data Pump
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm
Arvind said
Hi Kamran,
I really liked the way you explained the steps for installation.
Can you provide me link/document for Oracle 11gR1 preferable (11.1.0.7) on Oracle Enterprise Linux 5/5.3
I would really appreciate if anyone else who has experience installing can post the link.
Thank you
Arvind
Kamran Agayev A. said
Hi Arvind
I’m currently working on creating video tutorial on installation Oracle 11g on Linux
There’re a lot of aricles written on Oracle 11g installation, you can find them from google.com 🙂
Good Luck
Khan said
Assalamualaikum WRB
Hi Kamran
How are you? hope you are good over there. I trained my Oracle9i in Linux on 2007, i wrote SQL and Fundamentals II exams. Bcoz of some circumstances i need to change my field to Purchasing, now i would like to join as an DBA. I want to refresh all my past scripts of SQL and Oracle. I have installed Oracle10g in my Windows Vista. Please help me to refresh all the scripts from the begining. If you send any tutorial guide or video it’ll be much useful for me and appreciatable for you.
Regards
Khan
Kamran Agayev A. said
Va aleykum salam dear Khan
About whicih script are you talking? Could you elaborate more please?
I’d suggest you to read “Administration Guide” and “Oracle Concepts” from http://tahiti.oracle.com
Good Luck
Khan said
Hi Kamran
Thanks for your prompt response. I would like to learn all the practical lessons with video tutorial or picture view from the basic after installation of Oracle 10g in Windows and i need to know from where i can install the patches. Because i am new to Oracle on Windows, please let me know from the begining to learn. Because i am in the situation to shift the job as DBA, please try to help me out brother.
Regards
Khan
Kamran Agayev A. said
Dear Khan
There’s no enough video tutorials over the net. I’d suggest you to read documentation, make more practices and use Oracle on Linux, because most of databases run on Linux rather that Windows
Good Luck
P.S. Please ask your further questions over OTN forum – http://forums.oracle.com or drop me an e-mail to get detailed advice
Khan said
Salamalaikum Kamran
Thanks for your guidance, it was much useful. I installed my OEM successfully in my Vista, after installing when i startup the database. It requires host credential and database credentials, i entered the credentials as i did. But it shows the error as
“Error Message
Couldnot contact the agent. Verify that the url for the agent is null”
Please clear to solve the problem,, Is there any other credential will use? .
Waiting for your reply.
Thanks and Regards
Khan
Kamran Agayev A. said
Dear Khan
Please ask your questions over OTN forum – http://forums.oracle.com
Before asking a question, try to search over the net. There’re a lot of discussions there. Use the following link:
http://tinyurl.com/35pmmhu
vedat said
Merhaba Kamran Hocam;
Sİzin anlatımınıza göre centos ve oracle enterprise serverlar üzerine oracle 10g r2 kurdum.Elleirnize sağlık.Şimdi bir sorum olacak.Ben bu iki database i birbirleri ile konuşturmak istiyorum.Yani oracle enterprise üzerindeki oracleden centostaki oracleye yine centostaki oracleden diğerindeki bilgilere ulaşmak istiyorum.Nasıl bir yol izlemeliyim.Teşekkürler.
Kamran Agayev A. said
Salam Vedat
Bunu men “Creating Duplicate and Standby database using RMAN” videosunda gostermisem. Onu izlesen, goreceksen
Basarilar
venkatadevendrareddy said
hi kamran,
i am working as peoplesoft dba on AIX OS.I am looking for more documents and scripts related to peoplesoft admin and any peoplesoft enhancements from oracle company.
kindly let me know if any new updates.
Regards,
p.v.devendrareddy
Kamran Agayev A. said
Dear Devendra
Unfortunately I haven’t enough information on PeopleSoft DBA blogs. You can find the list of such blogs from google. Use the following address
http://tinyurl.com/2afl7ns
Good Luck!
Tejaswi said
Hello Sir.
I want to become an Oracle DBA.
I have started learning Oracle 11g DBA with “Oracle for Dummies”,”Oracle Beginners Guide”,”Oracle SQL” which are Oracle Press Books.
I java if we learn any new concept we practise programs through examples.But in Oracle what kind of examples can we practise with.Where they are available?.
Also tell me the Best way to Start Learning Oracle 11g DBA.
Kamran Agayev A. said
Hi Tejaswi
I’d suggest you to get the book of Tom Kyte “Expert Oracle Database Architecture (second edition)”, install Oracle and start reading and practicing the book
Tejaswi said
Thank You Very Much sir.
I also would like to know Whether the openings for Oracle will be more as For Java Programmers.
And What wiil be the salary range for a novice Oracle DBA in India?
Ather Hussain said
Hello Kamran
Do you have any performance tuning video ?
Ather Hussain
India
atherhussain9@yahoo.com
Kamran Agayev A. said
Dear Ather
As I’m concentrated only on RMAN video tutorials, I haven’t any tuning tutorials for now
Ziya said
Assalamu Alaikum WRWB Dear Brother Kamran,
You are doing a great Job. Keep it up.
May Allah swt accept and grant you success in this world and the hereafter.
Wassalam,
Ziya
Kamran Agayev A. said
Aleykum salam dear Ziya
Thank you for your feedback, I really appreciate it. Wish you the same
nassyam basha said
hi Kamran,
assalam alaikum, khairiat..
i saw your videos really its amazing… the videos are like “spoon feeding”, thanks for you help… you are helping a lot to world..
i have one question.
if i want to migrate database to enterprise to standard edition.. i checked with Metalink, it suggesting to follow exp/imp, but it was updated very old,
can you tell me what is the better way to migrate database from enterprise edition to standard edition..
my view is to go with ” transportable tablespaces.”
waiting for your reply.
Thanks in advance.
Tejaswi said
Hello Mr.Kamram can you suggest me any web site where i canfind the Video on Oracle 11g Architecture?
Kamran Agayev A. said
Aleykum salam dear Nassyam
The only way of converting Enterprise Edition to Sdandard that’s described in metalink, is the following note:
Converting An Enterprise Edition Database To Standard Edition [ID 139642.1]
Mukhtar Ahmad said
Dear Brother Kamran,
Asalamu-Alikum,
I see you have been doing a great job by helping society and mankind,thats the best service our Prophet (PBUH)has asked us to do.
I am a newbie in the field of IT and Oracle in particular,I would like to get your help on me getting hands with Oracle Financials EBS.R12.
Kindly suugest the best way to acquire indepth knowlege and good hold on the Oracle Financials as I aspire to be a Functional Consultant in Oracle Financials.R12
Thanks,
Mukhtar Ahmad
Kamran Agayev A. said
Va aleykum salam dear Mukhtar
Unfortunately I’m not using Oracle Financials, so can’t help you on this. Check the following google result and contact those admins who use the product you mentioned
http://tinyurl.com/23dvvva
Good Luck
Aijaz Khan said
Dear Mr, Kamran
I need your help. I have a question to you please i will be very thankful to you if you assist me how to do it.
My Question is: How i can connect two linux virtual machines in vmware?
I have install vmware workstation on Windows 7 operating system.
1) In VMware workstation i made 1st virtual machine of linux 4 and install oracle 11g on it with database ready.
2) In Vmware workstation i made 2nd virtual machine of linux 4 and install oracle 11g on it without database.
Now my question is i want to play with this two virtual machines as Client and Server.
1st virtual machine will act as a server
2nd virtual machine will act as a client
now i want to connect from client to my server database using two files i.e. listener.ora and tnsnames.ora.
I justed wanted to know how i can ping with these two linux machines. If you suggest me help with snapshots i will be very thankful to you.
i dont have two pc though i am working on my laptop someone has suggest me it can be possible in vmware workstation to communicate with client and server.
Please help me.
Best regards,
Aijaz Khan
Kamran Agayev A. said
Dear Aijaz
I’ve shown it in my “Performing Disaster Recovery with RMAN” tutorial
You can get it from the following link:
Just change network configuration of both vmware machines to “Host Only” and enable the network. Each machine will get automatically DHCP ip and you’ll be able to ping from one to another
Good Luck!
seetharam said
Dear Kamran ,
please assit to do schema separation steps Developement database .
Thanking u
Kamran Agayev A. said
Could you please elaborate more? Do you want to migrate a schema or anything else?
Avinash said
sir, im having a dought..plz help me…
im trying to become a dba with self study..my question is -on which os is better to practise dba i.e on windows(gui)or linux(command line)…i dont know much about linux…this is my problem…..plz give me reply….
Thanks & regards
Avinash
Tejaswi said
Hi Mr.Kamran.
I have installed Oracle 11g for windows on Windows 7 and installed Solaris 10 x86 on windows 7 as host and Solaris 10 as guest through Oracle Virtual Box.I have also installed Oracle 11g for Solaris on Solaris 10.
Now i want to make Windows 7 as client and Solaris as Server.How can i do this? Do you have any videos on this.
Please Reply soon.
Kamran Agayev A. said
Dear Avinash
I’d strongly suggest you to start practicing on Linux. If you don’t know Linux, don’t worry, I’ve video tutorials on installing Linux and Oracle, so you can start from it
If you want to learn Linux commands, visit the following post
Good Luck!
Kamran Agayev A. said
Dear Tejaswi
Unfortunately I don’t have a video tutorial on this. As I’m using a Vmware for creating virual machines, so it’s not a problem to connect from local PC to the vmware machine
Avinash said
Thank You Very Much Sir………….
Tejaswi said
Hello Mr.Kamran.
I regularly visit many of the top Oracle Blogs.But the thing which i found really good in this blog than others is your blog is very Interactive to those seek your help.
Thanks a lot for your Kind Service towards us.
Regard’s Tejaswi
Raghav said
Hello Mr Kamran Agayev,
At present i am a Sun Certified Java Professional.I want to Become an Oracle DBA since i found it is more challenging than Java.So i need your suggestion for the start up.
I hope that you would suggest the best.
Awaiting for your Answer.
Tejaswi said
What is the exact Difference between Oracle Application server and Oracle Data Base?
kasante said
thank you for helping the newbie in oracle database. please i want step by step installation of oracle 10gR2 on red hat Linux 9. i will be glad if you would help or you can send it through my mail. thank you.
Kamran Agayev A. said
Hi dear Kasante
I haven’t tested it yet, but it should be same as in my Oracle+Centos installation. Just try it and let me know
Kamran Agayev A. said
Hi dear Raghav
I’d suggest you to read Tonguc Yilmaz’s (Oracle ACE) introduction for newbies doc from the following address:
http://tonguc.files.wordpress.com/2009/06/oracle-introduction-for-newbies.doc
kasante said
hello mr kamran, i try installing i finished the installation on redhat linux 9 and i have set the environmental variables but when i execute sqlplus i receive the following message:( error 6 initializing SQL*plus message file sp1 msb not found. sp2-0750: you may need to set ORACLE_HOME to your oracle software directory.)please help sort it out. thanks
Kamran Agayev A. said
Read the error message again and you’ll see that you need to set ORACLE_HOME environment variable. Please use google before posting such easy questions
Thanks and good luck
Hemanth said
Hello sir,
I’m Hemanth.Right now i’m pursuing B.Tech 2nd year under Electronics dept.But i want to become an Oracle DBA.
I heard about your blog from Tejaswi who had posted some threads in this blog.
As i’m pursuing engineering i can’t afford time to got for Institutions for Learning DBA.So i would like to prepare at home.
“Can you suggest me on how to Startup learning and Practise Oracle 11g DBA?”
Kamran Agayev A. said
Dear Hemanth
I’d suggest you to start reading Oracle documentation from http://tahiti.oracle.com by installing vmware+OEL+oracle on it
You can start practicing my video tutorials as well
kasante said
thank you very much iam now using oracle on redhat linux 9, thank you very much
kasante said
Dear mr kamran, please i want to work with oracle RAC so i will be happy if you can help me with it. thank you.
Neeraj said
Dear Kamran,
I want to learn Oracle RAC can you help me on this if you have any Oracle book for learning RAC or video which was created by you please share with me.
Kamran Agayev A. said
Dear Neeraj
I’ll let you know when the RAC video tutorial will be posted
Sakhavat said
Good work!
Imran said
Assalamualaikum WRB
Good job kamran, i have a doubt in my certifications.
I wrote Oracle9i SQL and Fundamentals-II on 2007 and i did Oracle10g AdminI&II with the same testing id of 2007 in this November. I wanna know whether i completed OCP or not?
Thanks in Advance
Kamran Agayev A. said
Aleykum salam Imran
After passing all three exams you need to “Complete the Course Submission Form”
I’d suggest you to register at http://certview.oracle.com and provide your old accout to merge all your exam history with Oracle and there you’ll see your certification status
Good Luck!
Imran said
Walaikum salaam Kamran
Very thanks for your help, i have merged the exams which cleared.
But, when i click the Certification Status its showing as OCA not as OCP.
see the below view:-
Test Start Date Exam Number Exam Title Grade Indicator
20-NOV-10 1Z0-043 Oracle Database 10g: Administration II PASS
19-NOV-10 1Z0-042 Oracle Database 10g: Administration I PASS
03-APR-07 1Z0-007 Introduction to Oracle9i: SQL PASS
30-NOV-06 1Z0-032 Oracle9i Database: Fundamentals II PASS
Please advice further brother.
Thanks in advance.
Kamran Agayev A. said
Dear Imran
In my previous comment I’ve written:
After passing all three exams you need to “Complete the Course Submission Form”
So please check the link and complete the course submission form if you have taken any Oracle University class. Without it, you’re OCA
Imran said
Dear Kamran,
Thanks for your info, i updated the course submission form accordingly.
Hope i will receive my OCP. 🙂
mehdi said
Dear kamran,
hello, how are you? I hope every thing is well.
my name is mehdi from iran, Azerbaijan. I am very glad to see your web site because you are really senior at oracle. i need your help.
9 month ago I apply for take state sponsor from victoria in australia in oracle DBA, but they rejected my application in spite of my good resume and experiences(more than 8 years experiences) . I really was shocked due to this matter.
Mr kamran ,would it be possible send me a sample senior oracle DBA resume that help me to take sponsore this time.
I look forward hearing from you.
Best wishes,
Mehdi
Kamran Agayev A. said
Hi dear Mehdi.
I’d suggest you to investigate CV of Oracle professionals from http://www.linkedin.com page. There’re a lot of DBA’s registered their CVs and you can find more useful information
Good Luck!
Mohan said
Hi Kamran,
Good Morning, i am Mohan from India..i saw ur video’s very nice. i need to how to install oracle 11gr2 on OEL.so i would request you to put that video if possible.
Thank You,
Mohan
Kamran Agayev A. said
Dear Mohan
I’m currently working on 11gR2 installation on OEL, so just keep visiting my blog
Tejaswi said
Hello Mr. Kamran,
I’m Installing Oracle 11g R2(11.2.0.1.0) On Oracle Enterprise Linux Media Update 6 .
I’m getting the error as Follows:
“Oracle Error :: INS-06101
IP address of localhost could not be determined
Cause
The localhost is not mapped to a valid IP address in Hosts file (Eg. /etc/hosts in Unix).”
I’m Totally a Newbie to Linux Os.
So i don’t know how to map the Host to a =n Valid IP.
So, can you please telly me in Detail, how can i solve this Problem
Thank you in Advance
Regard’s Tejaswi………
Kamran Agayev A. said
Dear Tejaswi. Please check the following link:
http://forums.oracle.com/forums/thread.jspa?threadID=982024
suvajit said
We need more more vedio…U r really done a really good job. Please upload more more vedios. it is relly nice to become ur student. What i like in you is u r very transparent. Just simply superb all ur vedios. I am your big fan. I wisj i can meet wid you physically. Thank you thank you thank you so much……
Kamran Agayev A. said
Thank you Suvajit for kind words 🙂
I’m currently working on some video tutorials, so jus tkeep visiting my blog
P.S. I try to attent Oracle OpenWorld Conference every year in San Francisco, so we can meet there 🙂
David Mayfield said
I want to install sqlplus into putty. Can you give me some insight, step by step. I’m new to the Oracle field and I will be graduating within two months and I want to practice.
Kamran Agayev A. said
What do you mean with installing sqlplus into putty?
You can install Oracle database and install putty to contact to that database
David Mayfield said
The reason I said that, is because I use sqlplus in putty through my school, however they give me a password, but it expires pretty soon, so I want to configure sqlplus in putty. How can I install oracle and putty to contact to a database.
riaz ahmad ansari said
assalam alikum kamran
i am from india and i enter in dba field in 2009.i am 9i ocp certified in dba and i am a trainer in india.today first time i read your blog it is very helpfull but i am confused about scn and redo entries plz help me
khuda hafiz
Kamran Agayev A. said
Aleykum salam Riaz
For SCN, check the following link:
For redo thread, check the following link:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/onlineredo.htm#sthref853
Kamran Agayev A. said
Dear David
You should connect to the host server (where database installed) using putty and don’t need to install anything
Tejaswi said
Happy To Know that VIrtual Installation Videos of Oracle 11g R2 on OEL and Solaris are Available ……
Thanks a lot Mr.Kamran ……
Sanjeev Kumar said
Hello Kamran,
My heartiest thanks to you for such a wonderfull document related to ORACLE RAC installation.
Tom said
You are doing a lot for this world.
I have an experience of 1 year on different technology.Now i want to shift to Oracle DBA showing experience of 1 year.
What are the questions and what level,the Interviwer may ask and what are the difficulties i may face after i join so that i can prepare as of now.
Regards
Tom
Abdul Wahab said
Hi Kamran Sir,
I follow your posts, which are really nice for our day to day life. Thanks a lots for your effort.
I need one favour from you. I want to install Oracle 10g R2 in text mode in an unix server.
For that can you please help me how to install Oracle 10gR2 by using response file…
Sir waiting for your response.
Thanks in Advance.
Regards,
Abdul Wahab
Lekha Subash said
Hi Kamran,
Hope your doing great…I wanted to know where the listener log file in text format will be present.(I mean the location of the listener log file in Text format.).Could you please let me know the location of the file in ORACLE 11g Database.
Awaiting your reply.
Regards
Lekha
Kamran Agayev A. said
Dear Lekha
It should be at $ORACLE_HOME/rdbms/network/admin/log folder
Or type lsnrctl status command and you should see the log file destination at the top
Kamran Agayev A. said
Dear Abdul Wahhab
Check the following link:
http://www.oracle-base.com/articles/misc/OuiSilentInstallations.php
Gaurav said
Hi Kamran,
Please upload patching videos…..
thanks for other videos …these are very helpful.
Lekha Subash said
Hi Kamran,
Thank you .Thank a lot for ur help.
Regards
Lekha
harsimran said
Hello Kamran ,
scn range limit
regards
Harsimran
Rashid Ali said
salam Kamran Brother
i am Rashid Ali from pakistan and i want to be oracle developer and also
i am learning in developer so which step by step guide for oracle developer
would u prefer me .
please sir i am waiting ……..
Kamran Agayev A. said
Aleykum Salam Rashid
I’d suggest you to read Oracle documentation from http://tahiti.oracle.com
If you’re interested on books, then “Oracle SQL Recipes” and “Oracle PL/SQL by examples” are the most suggested books for the developers
Good Luck!
Rashid Ali said
Thanks kamran brother
again thanks very much
ABHI said
hi sir
i m new to oracle and solaris .I have installed it and have little bit of error while installing ,but when i started my terminal(login with oracle user) i have to use the export ORACLE_HOME,export PATH,export ORACLE_SID with their it’s own value again and again before logging in sqlplus………
totally helpless…
no idea what to do..
and next after entering into the sqlplus (as sys) i am also not able to run EDIT command.It gives SP2-0110 can not create save file “afiedit.buf”
please help sir..
Kamran Agayev A. said
Hi
for system default edit /etc/profile and put all environment variables in that file. Logout and login again, and you’ll see that all environment variables were exported automatically
For any user there is a .profile in the users homedirectory.
Check my Step by step guide on installing Oracle on Solaris:
Now change the profile of the “oracle” user and set environemnt variables:
gedit /export/home/oracle/.profile
export ORACLE_BASE=/export/home/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=solaris
export DISPLAY=:0.0
abhi said
dear sir
lot of thnx for quick reply.but the problem remain same.
i have to login again and again to start the sqlplus with export ORACLE_HOME,export PATH,export ORACLE_SID.
as u have suggested to edit the etc/profile i have done so.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
please look at the etc/profile (login with root user)
#ident “@(#)profile 1.19 01/03/13 SMI” /* SVr4.0 1.3 */
# The profile that all logins get before using their own .profile.
trap “” 2 3
export LOGNAME PATH
if [ “$TERM” = “” ]
then
if /bin/i386
then
TERM=sun-color
else
TERM=sun
fi
export TERM
fi
# Login and -su shells get /etc/profile services.
# -rsh is given its environment in its .profile.
case “$0” in
-sh | -ksh | -jsh | -bash)
if [ ! -f .hushlogin ]
then
/usr/sbin/quota
# Allow the user to break the Message-Of-The-Day only.
trap “trap ” 2″ 2
/bin/cat -s /etc/motd
trap “” 2
/bin/mail -E
case $? in
0)
echo “You have new mail.”
;;
2)
echo “You have mail.”
;;
esac
fi
esac
umask 022
trap 2 3
export ORACLE_SID=orcl
export ORACLE_BASE=/export/home/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_2
export PATH=$ORACLE_HOME/bin:$PATH
export DISPLAY=:0.0
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
and local.profile
#
# Copyright (c) 2001 by Sun Microsystems, Inc.
# All rights reserved.
#
# ident “@(#)local.profile 1.10 01/06/23 SMI”
stty istrip
PATH=/usr/bin:/usr/ucb:/etc:.
export PATH
TMP=/tmp
TMPDIR=$TMP
export TMP TMPDIR
export ORACLE_SID=orcl
export ORACLE_BASE=/export/home/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_2
export PATH=$ORACLE_HOME/bin:$PATH
export DISPLAY=:0.0
please sir help me.
abhi said
hi sir i need ur help….please assist me..requested to u…
ashwini said
Hi Kamran.
I need your help.please i will be very thankful to you if you assist me how to do it.
I am getting below error while taking schema level export using expdp
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [INDEX_STATISTICS]
ORA-22923: amount of data specified in streaming LOB write is 0
I have searched on google.com website, but not getting proper solution.database is on windows server 2003 and version is 10.1.0.2
Please help in resolving the issue.
ashwini said
Hi Kamran.
I need your help.please i will be very thankful to you if you assist me how to do it.
I am getting below error while taking schema level export using expdp
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [INDEX_STATISTICS]
ORA-22923: amount of data specified in streaming LOB write is 0
I have searched on google.com website, but not getting proper solution.database is on windows server 2003 and version is 10.1.0.2
Please help in resolving the issue.
Regards,
Ashwini
Kamran Agayev A. said
Dear Ashwini
Check the following metalink note:
Expdp fails ORA-39125 while calling DBMS_METADATA.FETCH_XML_CLOB [COMMENT] [ID 780033.1]
yograj said
HI,
i need oracle 11g installation on windows. we are using oracle 11 or another machine after installation, need to restore backup as well.
thanks in advance
syed said
Dear Kamran ,
I have successfully migrated Oracle database 10 R2 from windows server 2k3 to Linux 5.0 using user video.Thanks for that.
I want to install Oracle10 R2 on Red Hat Enterprise Linux6.0
Cloud you send me post Step by Step Installing Oracle Database on Red Hat Enterprise Linux6.0.
I have complete within two days. Please help Me Send it as soon as possible.
Thanks in Advanced.
Kamran Agayev A. said
Dear Syed
Try my step by step installation for OEL 5. It should work
Kamran Agayev A. said
Instaling Oralce on Windows is simple. Just download the installation from oracle.com and start installing it
If you want to restore backups from another server, you can use the following video tutorial :
abhi said
dear sir
lot of thnx for quick reply.but the problem remain same.
i have to login again and again to start the sqlplus with export ORACLE_HOME,export PATH,export ORACLE_SID.
as u have suggested to edit the etc/profile i have done so.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
please look at the etc/profile (login with root user)
#ident “@(#)profile 1.19 01/03/13 SMI” /* SVr4.0 1.3 */
# The profile that all logins get before using their own .profile.
trap “” 2 3
export LOGNAME PATH
if [ “$TERM” = “” ]
then
if /bin/i386
then
TERM=sun-color
else
TERM=sun
fi
export TERM
fi
# Login and -su shells get /etc/profile services.
# -rsh is given its environment in its .profile.
case “$0″ in
-sh | -ksh | -jsh | -bash)
if [ ! -f .hushlogin ]
then
/usr/sbin/quota
# Allow the user to break the Message-Of-The-Day only.
trap “trap ” 2″ 2
/bin/cat -s /etc/motd
trap “” 2
/bin/mail -E
case $? in
0)
echo “You have new mail.”
;;
2)
echo “You have mail.”
;;
esac
fi
esac
umask 022
trap 2 3
export ORACLE_SID=orcl
export ORACLE_BASE=/export/home/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_2
export PATH=$ORACLE_HOME/bin:$PATH
export DISPLAY=:0.0
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
and local.profile
#
# Copyright (c) 2001 by Sun Microsystems, Inc.
# All rights reserved.
#
# ident “@(#)local.profile 1.10 01/06/23 SMI”
stty istrip
PATH=/usr/bin:/usr/ucb:/etc:.
export PATH
TMP=/tmp
TMPDIR=$TMP
export TMP TMPDIR
export ORACLE_SID=orcl
export ORACLE_BASE=/export/home/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_2
export PATH=$ORACLE_HOME/bin:$PATH
export DISPLAY=:0.0
please sir help me.
Arun said
Hi Kamaran,
I am migratig oracle 9i DB Schemas to Oracle 11g through exp/imp utilities (This is because of user need). There are two schemas have bigger size nearly 180G and 120G. If I used exp/imp utility then it will take minimum 3-4 full days to complete the activity. I will not get that much down time. Can you please suggest which utility I can used other than exp/imp to migrate those schema which will not take more than 4-5 hrs.
Thanks in advance and waiting for your precious suggestins.
Arunabh said
Thanks Mr. Kamran,
Such a good technical stuff to learn. I’ve just step in to oracle clustering. Can u guide me to setup a RHEL 5 based (Cluster suite) cluster with oracle 11g r2 failover in active/passive mode. Where, I node will have the share san volumes mounted and DB running at a time while the passive node will live idle. In case of failure of primary node, the cluster resources (i.e. share san vols, virtual ip etc). will relocated to secondary node, and DB in primary node shutdown properly and then start on secondary node. After resolving the primary node issue, as soon as it get online all the services & resources again shifted to primary node accordingly.
Regards
Arunabh
Kamran Agayev A. said
Hi Arunabh
You can check my Step by Step RAC installation guide for 10g, I’ve already shown how it works