Oracle DBA Corner

Welcome. Please Login, Register, Or Activate! 
type your username and password to login
Date: November 08, 2009, 10:45 AM
423562 members and 291103 Topics
Latest Member: pukar
Nairaland [Nigerian Forum] Home Help Search Who is currently online? Login Register
Nairaland Forum  |  Technology  |  Programming  |  Oracle DBA Corner
Pages: (1) ... (8) (9) (10) (11) (12) (13) (14) Go Down Send this topic Notify of replies
Author Topic: Oracle DBA Corner  (Read 15893 views)
azum
Re: Oracle DBA Corner
« #416 on: May 22, 2009, 07:37 PM »

Quote from: jimblaze on May 22, 2009, 02:17 PM
well i tnsping and it says  TNS-12535: TNS:operation timed out and my sqlnet.ora file on both the server and client is this-# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)
 

this is not good right : Cheesy

Change that to ALL.
And if you still can not connect post the following files here for review:

1. listener.ora file from the server end
2. sqlnet.ora from the server side
3. tnsnames.ora file from the client side.

Meanwhile can you please answer the following question: can you ping the server from the client?
jimblaze (m)
Re: Oracle DBA Corner
« #417 on: May 25, 2009, 07:35 AM »

yea i did change the sqlne.t.authenticatin_services to all and no i cant ping the server from the client, anyway i have already unstalled the client and i am gona reinstall it back, by the way how come when opening enterprise manager 11g from a web browser it would not open with http:// but with https://? why the s? when i did a fresh install of 11g, EM  would not open  so i went online and got the solution from an oracle dba blog tha said i should try https
azum
Re: Oracle DBA Corner
« #418 on: May 25, 2009, 07:50 AM »

Quote from: jimblaze on May 25, 2009, 07:35 AM
yea i did change the sqlne.t.authenticatin_services to all and no i cant ping the server from the client, anyway i have already unstalled the client and i am gona reinstall it back, by the way how come when opening enterprise manager 11g from a web browser it would not open with http:// but with https://? why the s? when i did a fresh install of 11g, EM  would not open  so i went online and got the solution from an oracle dba blog tha said i should try https

S there means secured. Since Oracle 10g EM runs in secured mode by default.
If you can not ping the server from the client how then do you expect to be able to connect via Oracle?
jimblaze (m)
Re: Oracle DBA Corner
« #419 on: May 25, 2009, 08:06 AM »

you mean 11g? because i did not get the problem with 10g, anyway it was after i could not connect that i pinged it
azum
Re: Oracle DBA Corner
« #420 on: May 25, 2009, 08:27 AM »

Quote from: jimblaze on May 25, 2009, 08:06 AM
you mean 11g? because i did not get the problem with 10g, anyway it was after i could not connect that i pinged it

Apologies. What i meant is that right from Oracle 10g EM GC, it runs in secured mode by default and thus requires that you connect to it using https. Maybe Oracle has implemented this as the default mode for Oracle 11g DBConsole now.

As per pinging, open a command prompt on the client and then ping the server to test if your client can talk to the server.
jimblaze (m)
Re: Oracle DBA Corner
« #421 on: May 26, 2009, 10:35 AM »

thanks azum for all the info but i have reinstalled oracle instant client 11g and the instant client does not have any sql interface or gui so how do i connect to the database?
jabbok (m)
Re: Oracle DBA Corner
« #422 on: June 01, 2009, 09:07 AM »

hi all,

Can anybody help me out with a good tutorial on PLSQL? I'll really aprc8 it.

Thanks
ibizgirl
Re: Oracle DBA Corner
« #423 on: June 03, 2009, 07:58 PM »

hI i AM KIND OF NWE TO THIS ORACLE THING JUST WROTE MY SQL AND 047 EXAMS WHAT NEXT CAN i GET A JOB WITH THIS
jabbok (m)
Re: Oracle DBA Corner
« #424 on: June 03, 2009, 11:25 PM »

Yes u can get a job with it, just seek and ye shall find.
all d best

Quote from: ibizgirl on June 03, 2009, 07:58 PM
hI i AM KIND OF NWE TO THIS ORACLE THING JUST WROTE MY SQL AND 047 EXAMS WHAT NEXT CAN i GET A JOB WITH THIS
jabbok (m)
Re: Oracle DBA Corner
« #425 on: July 03, 2009, 03:22 PM »

Hello House,

I've been called for an interview tommorow by Tavia Technologies. Anybody got some ideas of what the interview for the post of
Oracle ETL/EDW Developer will be like??? Please Advise.
jellyface (m)
PLS HELP! I NEED ASSISTANCE TO INSTALL ORACLE 10G REL.2 ON LINUX UBUNTU 7.04
« #426 on: July 11, 2009, 09:09 PM »

 :'(dba gurus, i am new to linux and i need your help to install oracle 10g rel. 2 on linux ubuntu 7.04. the funniest thing is dat i know nothin about linux ubuntu. i need guide from scratch (detailed steps) to install it successfully. pls ,someone come 2 my aid soonest.tanx. Sad
jabbok (m)
Re: Oracle DBA Corner
« #427 on: July 16, 2009, 11:19 PM »

Quote from: jellyface on July 11, 2009, 09:09 PM
:'(dba gurus, i am new to linux and i need your help to install oracle 10g rel. 2 on linux ubuntu 7.04. the funniest thing is dat i know nothin about linux ubuntu. i need guide from scratch (detailed steps) to install it successfully. pls ,someone come 2 my aid soonest.tanx. Sad

I can assist you on installing Oracle 10g on Soalris 10. I blv u'll knw linux ubuntu when u knw solaris. SAme Unix
seyi_ola
Re: Oracle DBA Corner
« #428 on: July 20, 2009, 10:42 AM »

Pls,  how or where do i get dumbs for OCP?Huh? Thanks
ojojames
Re: Oracle DBA Corner
« #429 on: July 23, 2009, 12:39 PM »

I need your help guys.
I want to get OCA as soon as possible but I know very close to nothing.

I also need a copy of 10g or 11g to practice with.
Please help me if you can. Pleaaaaaaaaaaaaaaase.

ojojames@yahoo.com
jabbok (m)
Re: Oracle DBA Corner
« #430 on: July 24, 2009, 06:58 PM »

@ojojames n all,
Everythng u nd 2 master 10g is in my kitties. Texts, videos ,
Email: denham.inc@gmail(dot)com
ewom1028
Re: Oracle DBA Corner
« #431 on: July 26, 2009, 04:25 PM »

Hi guys,pls i am interested in getting the following software: Oracle 10g developer suite on windows and Linux, i got a copy but it wont progress past the first screen, can any1 hep me out? also , i will love to discuss with any1 who develops applications for oracle databases using pl/sql
ewom1028
Re: Oracle DBA Corner
« #432 on: July 26, 2009, 05:02 PM »

Hi guys,pls i am interested in the following software, Oracle 10g developer suite( for windows and linux), and also documentation on installation, finally i would love to discuss with application developers that use pl/sql, thanx
Kemjisuper (m)
Re: Oracle DBA Corner
« #433 on: August 06, 2009, 01:59 PM »

Quote from: jabbok on July 03, 2009, 03:22 PM
Hello House,

I've been called for an interview tommorow by Tavia Technologies. Anybody got some ideas of what the interview for the post of
Oracle ETL/EDW Developer will be like??? Please Advise.

@Jabbok
How did the interview with Tavia Tech go? Been thinking of doing something with them in the near future.
Quote
jabbok (m)
Re: Oracle DBA Corner
« #434 on: August 11, 2009, 07:08 PM »

Thanks for the concern. I cant really say anything cos I've not heard from them. Developers Track Experts dey scarce for this country, thats why we need to wake up. Many thanks
ieghosa
Re: Oracle DBA Corner
« #435 on: August 20, 2009, 07:51 AM »

Hi everybody pls i need a solaris10DVD .Pls its urgent i have been searching for this Dvd for months now.Pls some body should pls show me love.These are my contact physics4eghosa@yahoo.com  jigbine@gmail.com 07037206581.I would be the happiest person if i can get it before week end.   
deebsman1
bobonatty
« #436 on: September 21, 2009, 11:22 PM »

Hello house, got an info 4rm a friend that want 2 sit 4 d ocp exams but was told that as 4rm next month october, d oracle exams will cease 2 b on prometric, that it's going 2 b pure practical stuff. How 2rue culd dt b?
FOD (m)
Re: Oracle DBA Corner
« #437 on: September 23, 2009, 02:11 PM »

Quote from: deebsman1 on September 21, 2009, 11:22 PM
Hello house, got an info 4rm a friend that want 2 sit 4 d ocp exams but was told that as 4rm next month october, d oracle exams will cease 2 b on prometric, that it's going 2 b pure practical stuff. How 2rue culd dt b?

See: Oracle To Begin Certification Exam Delivery Through Pearson VUE
deebsman1
Re: Oracle DBA Corner
« #438 on: September 23, 2009, 06:17 PM »

@FOD, Thanks brother, d link given is really informative.
jimblaze (m)
Re: Oracle DBA Corner
« #439 on: October 12, 2009, 06:14 PM »

Le moor, A-40, etc were are you guys @?dont tell me this thread is dead?anyway have you guys heared aboutR ROCKWISE CEMIS?its a construction and engineering  mgt software that runs ontop of oracle 10g,and trying to install oracle 10g r2 on solaris 10 on virtual box but its always reboots, any solution?
 Tutorials On Game Programming  Java Programming For Dummies  Page 2
Pages: (1) ... (8) (9) (10) (11) (12) (13) (14) Go Up Send Topic to Friend by E-mail Reply 


Sections: Autos/Cars (2) Jobs/Vacancies (2) (3) Career Talk Education General(2) Politics Romance Computers Phones Travel
Sports Fashion Health Religion Celebrities TV/Movies (2) Music/Radio (2) Books Webmasters Programming

Links: Page1 Page2 Page3 Page4 Page5 Page6 Page7 Page8 Page9 Page10

Nairaland is owned by Oluwaseun Osewa. See also: Nairalist Classified Ads
Nairaland Forum | Powered by SMF 1.0.12.
© 2001-2005, Lewis Media. All Rights Reserved.