₦airaland Forum

jimblaze:
you mean 11g? because i did not get the problem with 10g, anyway it was after i could not connect that i pinged it

jimblaze:
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

jimblaze:
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 :

jimblaze:
hello guys were are all of you?lemoor, a40, cabali, wats happening? i installed oracle 11g db on a coworkers pc and i installed oracle 11g client on my pc and i have been trying to use the client to connect but not possible, i keep getting ORA-12154: TNS:could not resolve the connect identifier specified and ORA-12154: TNS:could not resolve the connect identifier specified so, solutions

ceso:
@ azum, I followed the steps but no luck, my guess is that it has something to do with admin rights as all attributes in the oracle folder are set to readonly. As soon as i uncheck readonly and close properties, the attributes automatically goes back to readonly. Anyway thanks for all your effort; i will delete and re-install enterprise manager.

ceso:
@ azum,
im still not able to login as sysman, keeps saying my account is locked. I just found out that oracle 10g is not compatible with windows vista Home premium and im not sure if that has anything to do with the system 5 error i encountered while stopping dbconsole and also the loss of connection to my database. I find it strange that i was able to download 10g on vista home premium inspite of the compatibility issue.

ceso:
@azum, Apologies couldnt reply to your post soon enough. Just tried both emctl stop/status dbconsole, and i keep getting the error message "system 5 error has occured, access is denied". After poking around a bit, i figure this is an admin rights issue but i'm logged in as the administrator.

ceso:
@ azum, Not sure what happened but i'm not able to connect to the chin db through EM

(1) They are both on port 1521

(2) I'm trying to open the orcl database

(3) I can connect to chin via sqlplus and when i try orcl in sqlplus i get the error message the account is locked ora-28000

(4) There arent an other oracle services besides what i sent you

ceso:
@ azum, Happy Easter--> i checked under services and the dbconsole status is set to"started" and startup type is "automatic". I tried restarting both the oracleDBconsole and Oracleservice orcl, but no luck.

ceso:
Thanks for the quick response azum. I downloaded oracle 10g database on my laptop (OS windows vista) and for a while i was able to login and then all of a sudden i cant connect to my database anymore. When i try to login i get the message"enterprise manager is not able to connect to the database instance"; i can see that my database instance is open and my listener is up however the agent connection to instance failed(ORA-12505). I have tried to define the SID but no luck. Anyway I ended up creating another DB but i still want to find out why i lost connection on the first database.

ceso:
@azum: came across this site while searching for solutions on how to connect to my db. I have a similar problem as jabbock however i'm still getting the message that my oracle_sid is not defined. I restarted oracledbconsole, oracle tns listener and oracle services, but no luck. Any ideas on how i can fix this ?

A-40:
T[b]he sore point is there are not that many DBA jobs[/b] in Nigeria its still a growing field definitely and the experience thing is another issue people expect you to have been on the job for donkey years so its still a bit hard out there for most of us that are still pretty new to it

Kemjisuper:
Hello Database Newbies, Gurus & Guruettes

I'd like us to use this forum to educate ourselves & discuss issues

concerning ORACLE Database Administration. I know there's already a

thread on Oracle, but it's packed full of Professionals and some of

the discussion points are way beyond the scope for us Newbies. We

really need to pick up on the very basics of being a DBA like for

instance

- What's the job of a DBA like?

The link below will help in addressing some of the tasks of a DBA.

http://www.oracle.com/technology/getting-started/coredba.html

- Would you be going to work every morning to issue SELECT statements?

Not necessary. Except when you're a Developer DBA, your use of SELECT statement is very minimal. Your use of this is restricted mainly for exploring the database for information. There is this wrong conception here that being a DBA is all about SQL and PL/SQL. Please there is far more to being a DBA than knowing PL/SQL and SQL.

- Is it an interesting job besides high paying?

It a fun job. Being in it for a few years now and cant see myself giving it up for anything.

- What professional ethics are associated with being a DBA?

This is one of those unwritten rules of being a DBA. As a DBA you have access to sensitive information stored in the databases you manage. So as a DBA a high standard is expected. That is why these days in the US after 9/11 certain DBA jobs require not only being a US citizen but also having a Secret Clearance.

- What professional Certifications are attainable for ORACLE?

There are just so many. Here is a link to help you.

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=141

- Which are the best Institutions to study Oracle in Nigeria?

Unfortunately cant help here. More or less a visitor to Nigeria these days.

- What's the demand for Oracle DBA's like in Nigeria?

I believe the demand for those with relevant experience is high. That i know for sure going by what my contacts on ground tell me. But like everywhere else in the world, there is this apathy towards beginner. Employers seem to forget there the guru of tomorrow needs somewhere today to cut his teeth.

- What are the risks involved if something goes terribly wrong?

Very high. That's why the job interviews are always very demanding. You tend to e grilled on practical aspect of the job that even the exams dont cover. Employers put a lot of emphasis on ability to demonstrate hands-on capability than anything else. I remember sometimes in 2004 when i nearly ran into trouble for refreshing a listener on one of my environments that the client can not afford to go down for a minute. It takes something like less than the twinkle of an eye lid for a listener to be refreshed. Believe me, i hardlylogged out of the listener command line when the phones starting ringing and questions were being asked.
But all in all, even the strictest employers give room for mistakes. Most Oracle shops are segregated. DBAs are assigned job and duties based on their experience and comfortability. In such environments, junior DBAs are expected to ask questions from the senior DBAs. But in some one DBA environments, then you have a jack of all DBA. Here the margin for error is very minimal. It is more important for a DBA to know where to look for solution to a problem than to claim to know it all. As such employers these days are incorporating questions on the Internet Search engines like google and metalink as part of drill for DBAs being interviewed for a job.
Generally though, Oracle database is so robust that the possibility of a DBA doing something grave is very minimal. Unless for someone masquerading as a DBA. What is common though i DBAs being slow or unable to solve a problem. For example while it may take an experience DBA a short time to recover and restore a lost control file, it may take a beginner DBA like forever to do it.
All the above being said, its easier for a DBA to be fired for incompetence just like in other jobs than for a DBA to be fired for doing something stupid. It will really take a stupid DBA to go and delete all his control file.

- , and so on!

Lastly, let me add here being a DBA requires a lot of hardwork and lots and lots of continous education. Thank God for the internet. There are so many resources out there for one to access. Nearly any possible problem a DBA will encounter must have been encountered by someone before. So to succeed as a DBA you need to know where to look for for help. This key. And be ready to read wide.

Please note what i have written here can be aid to be global in nature. I wish i can give more Nigerian specific situations.

Here we'll be seeking help and advice from those who have gone far,

and those possibly through with their Oracle Certification.

As time goes on, we'll also practice revising some codes and SQL

statements which may be familiar or strange to us (Professional help

required here pls).

Please, let's respond to this topic positively in our best interests.

Cheers

I hope you find my post useful. If you have further questions please dont fail to post them and time permitting i will try my utmost best to address your concerns.

Goodluck.

cabali:
Prior to that I used mozilla and IE7 successfully with JRE update 13. I reverted back to IE7 and it isnt still working; thats the issue.

Toyosi R:
HELLO PROGRAMMERS
Do any body have an idea of any of the following
please help me out.


1. importing and exporting from excel to sql server database using vb.net


2.  Making application run on network. (local area network)

3. Backing up and restoring


Thanks so much

cabali:
BTW I am working on ERP on the E-business Suite.

Azum, any idea?

JerseyGirl:
please help! can i install Oracle 11g on my personal laptop?. how many applications can i install?. i don't want to kill my pc. thanks.