December 24, 2010 at 3:42 am
Ok got the followinbg problem
I create database Test
On Test I create testUser (using Enterprise Manager), I use SQLserver to log in OK works
I create database Test2
On Test2 I create test2User (using Enterprise Manager), I use SQLserver to log in OK works
I then try testUser
And I get ORA-01017: invalid username/password; login denied
December 27, 2010 at 1:35 am
Please, don't take offence. but... wait until you receive your books and start studying.
Things will be much clearer.
-- Gianluca Sartori
December 27, 2010 at 3:26 am
Yeah, I hope so bloody snow is delaying delibvery
December 27, 2010 at 1:28 pm
Resender (12/23/2010)
If i log into sql*plus how can i determine on what database I am.
From SQL*Plus issue:
SELECT name FROM v$database
.ORA-00942: Table or view does not exist[/quote]
Try...
select instance_name from sys.v_$instance;
select name from sys.v_$database;
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 3, 2011 at 6:53 am
OK the books have finally arrived (after 2 weeks delay and then the postman left them at my frontdoor without waiting for me to come to the door (stupid b-post))
I have reinstalled the database and started running through the OCA book and the biggest problem is getting to some of the table.
I'm using the buildin user HR bu!t this only has access to HR tablespace (How do I make a user that has acces to more then 1 tablespace)
Better question woulld be how do I create a user that can access all the tables in all the tablespaces of a database preferably the HR example database
January 3, 2011 at 12:22 pm
Resender (1/3/2011)
OK the books have finally arrived (after 2 weeks delay and then the postman left them at my frontdoor without waiting for me to come to the door (stupid b-post))I have reinstalled the database and started running through the OCA book and the biggest problem is getting to some of the table.
I'm using the buildin user HR bu!t this only has access to HR tablespace (How do I make a user that has acces to more then 1 tablespace)
Better question woulld be how do I create a user that can access all the tables in all the tablespaces of a database preferably the HR example database
In Oracle access is granted/restricted by schema and objects, not by tablespace.
User account HR has access to whatever is in HR schema e.g. owned by HR.
To have full access to everything you should be logged into the system as "SYS as SYSDBA" but you should not use these credentials for trivial access - this is like login into the system as "sa".
My suggestion would be, log into the system as SYS AS SYSDBA, create an account with DBA ROLE, log into the system with such account then grant privs as needed to other accounts.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 4, 2011 at 1:30 am
I used the enterprisemanager and created a user based on the oe user (in the hr examplke db)
only the tabs are empty under this user
January 4, 2011 at 6:48 am
Resender (1/4/2011)
I used the enterprisemanager and created a user based on the oe user (in the hr examplke db) only the tabs are empty under this user
And the question is?
Please do not take this in the wrong way but, if you want to be an Oracle DBA you have to stop clicking on a GUI, open SQLPlus and do it properly - no other way to understand what you are doing.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 5, 2011 at 3:38 am
if you spend 4 years working only with SQLServer you get indeed spoiled
i'm training to become a general dba (oracle, ms sql server)
I got the OCA books last week and started on them (already on page 600)
some of the things seem to be off in my installation in retrospect to the book
One of the things i'm currently stuck at is savepoints
i create one
create savepoint a1;
but if i want to rollback to it i'm getting the ora-01086 saying its not established in the session or not valid.
January 5, 2011 at 5:39 pm
You can download and install Oracle 10g Express edition on your XP or Vista laptop, no need for a seperate PC. Last time I checked there not yet an 11g version of XE.
Also, Oracle has very good online documentation and quick start guides. Here is a "2 Day DBA" guide for 11g that covers the issues you are currently encountering.
http://st-curriculum.oracle.com/obe/db/11g/r2/2day_dba/index.html
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 6, 2011 at 5:44 am
There is an example database called EXAMPLES provided with the 11g installation
January 7, 2011 at 6:39 am
Resender (1/5/2011)
One of the things i'm currently stuck at is savepointsi create one
create savepoint a1;
but if i want to rollback to it i'm getting the ora-01086 saying its not established in the session or not valid.
Savepoint? Savepoints are a feature that allow for partial transaction rollback... shocked?
They are rarely used, I would suggest to start trying to rollback a whole transaction.
By the way, ORA-01086 suggests savepoint was not properly issued, it has to be established inside a transaction.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 7, 2011 at 6:50 am
today i spend trying to figure out why the laptop i'm working on slowed down seriously in the past 24 hours
the best answer i can think off atm is that the demand by 2 or more oracle databases is to much
January 7, 2011 at 7:40 am
Resender (1/7/2011)
today i spend trying to figure out why the laptop i'm working on slowed down seriously in the past 24 hours the best answer i can think off atm is that the demand by 2 or more oracle databases is to much
Since your Oracle instance is running locally on your laptop, it's possible that some process other than Oracle is competing for resources. You need at least 2 GB of RAM to really work with Oracle or SQL Server locally on a PC while performing other tasks. There is an excellent tool called Process Explorer which is part of Microsoft's free Sysinternals toolset. Selecting the columns: Working Set, Peak Working Set, CPU, CPU Time, I/O Read Bytes, I/O Write Bytes, CPU History, I/O History, and start off by sorting the processes by CPU. Also add CPU Usage and Physical Memory Usage to the Status Bar.
http://technet.microsoft.com/en-us/sysinternals/bb896653
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 7, 2011 at 7:48 am
Resender (1/7/2011)
today i spend trying to figure out why the laptop i'm working on slowed down seriously in the past 24 hoursthe best answer i can think off atm is that the demand by 2 or more oracle databases is to much
Two instances in a laptop? You are most probably right - depending on laptop configuration that may be exhausting resources.
Start by checking... physical memory on the laptop vs. size of the two Oracle SGAs and PGAs. I would say you should point to have at least 50% of physical memory free.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 15 posts - 16 through 30 (of 43 total)
You must be logged in to reply to this topic. Login to reply