Create As Many As 100 Database With Upto 100 Users (max) For Each Database As Client
Aug 25, 2010
I have CPU based Oracle server license. In this case as per license policies of Oracle I can have unlimited database with unlimited users connecting it.
I need to create as many as 100 database with upto 100 users (max) for each database as client. What is the recommended hardware for this server? CPU/ RAM/Harddisk, recommended chipset on the motherboard (in case of database storage capacity required is not high typically - 20 GB is OK per database - average), redundancy is critical, also Oracle database vault is going to be installed; as security is of prime importance between users of different database. Which specific server models from specific vendors like IBM/ Dell/ HP are good ones for this purpose?
View 2 Replies
ADVERTISEMENT
Apr 12, 2011
I create different database users like STORE, PAYROLL, GL , SYSADMIN, COMMON to contain objects accordingly then I create another user ABC and grant DBA privileges to all users.
After that I grant SELECT/INSERT/UPDATE/DELETE privileges on each and every objects of STORE/PAYROLL/GL/SYSADMIN/COMMON users to ABC then create synonyms of STORE/PAYROLL/GL/SYSADMIN/COMMON users objects into ABC.
Actually, I want to use single user of ABC to build/execute my application but I think I am doing something wrong because whenever I tried to compile my form, its showing this error.
View 8 Replies
View Related
Jan 13, 2011
can we use oracle client version to create a database in that server.
View 3 Replies
View Related
Mar 30, 2012
If i create database on server(remote desktop connection) and try to some R&D like shutdown or startup command it will effect my other database or not.
View 1 Replies
View Related
Oct 11, 2013
on my Windows 7 machine with Oracle Client 12.0.1.0 installed I'm trying to create a database link to a database server, that runs under Oracle Standard Edition1 11.2.0.2. When i login to sqlplus on the client with "sqlplus /nolog" and type the command : SQL> create database link SID connect to user identified by passwd using 'tnsnames.ora connection'; I'm getting an SP2-0640: not logged in.
Ok, thats clear, because i use sqlplus with /nolog option. But on client side normally I have no database, where I can login. So I think, there will be no user, or? The database to which I want to connect is set in tnsnames.ora. Generally: Is it possible to use the Oracle Client to create a database link?
View 8 Replies
View Related
Jun 5, 2013
I heard .MDD file is Database Designer for MYSQL(i don't knw exactly).how to create it..
View 1 Replies
View Related
Feb 17, 2012
we have a production database 'X'. Now i have created a test database 'T' and did'nt configured another listener to it! The issue is when i cam connecting to oracle through sqlplus i am directly connecting to Test database 'T' but not the production database 'X'----ofcourse i can login to production DB afterwards. but initially i want to access the production database 'X'.
View 15 Replies
View Related
Apr 23, 2010
I want to know what will be the performance of my DB before loading data and how many users can connect with my database.
View 7 Replies
View Related
Mar 26, 2011
i am installing oracle database 8.1.7 on dell server power edge 2650 first time database successfully installed but when i want to crate new database by Database Configuration Assistant it is not working for new database creation.
View 1 Replies
View Related
Aug 14, 2012
i have a database nd only 10 users must allowed to access db at any point of time and sessions per user must be 1.that is only 10 users must be able to access the database.
View 6 Replies
View Related
Nov 24, 2010
get the actual password for the database users. If we talk about the dba_users account we have password in the encrypted form how to decrypt them and get actual password.
View 6 Replies
View Related
Nov 7, 2013
I have an application that I am adding users to as end users. How do I assign them to a particular application? I am using Apex 4.1, Oracle 11g.
View 10 Replies
View Related
Mar 19, 2012
select username,account_status,default_tablespace from dba_users;
The ran the above query and it return 80 users but when i ran below query it shows just 14 rows.
select owner,sum(bytes)/(1024*1024) "GB" from dba_segments group by owner;how to get the size of all 80 users from database ?
View 2 Replies
View Related
Apr 10, 2011
it is a good practise to assign different profile for oracle database users according to their job functions.what could be the resons for that?
View 3 Replies
View Related
Oct 25, 2010
I have 10 users in my database, I need to find the time at which a query is fired by any of the users in the database. provide the query for this? I think i have to use V$sql,v$sqlarea or v$sql.
View 1 Replies
View Related
Mar 2, 2012
I have created 2 users named "user_a" and "user_b" in my database and i gave "connect","dba" and "resource" roles to both users,then i created a table,synonym in user_a and i observe that user_b can also access this table and synonym of user_a without "granting" to "user_b", how it is possible. is it because of any of above role?
View 12 Replies
View Related
Jan 11, 2013
1.what is the difference between install database and create database?
2. if i have connected with remote database(server) then it is an instance again?
View 3 Replies
View Related
Jan 22, 2013
Is there a way where I can check users/IPs who connect to the database in a specific time 2 days ago?
View 5 Replies
View Related
Dec 27, 2012
how many users we can create in oracle 11g release 2 database. Is there any specific limit or parameter for that.
View 1 Replies
View Related
Aug 19, 2012
I need to copy more than 1000 database users(without objects) from orcle 9i to oracle 11g. They don't allow to use any graphical tools.which is the best way to complete this task? does conventional export /import works for only users only ?
View 2 Replies
View Related
Apr 22, 2010
i got to find out the users hostname who are connecting to database through remote,i tried with v$session bt it is showing null values in the terminal column.how to find out ?
View 8 Replies
View Related
Aug 23, 2012
Using Apex 4.1 and custom authentication based on Oracle Database users.
I want to be able to show a warning immediately after a user logs in if their password is due to expire in xx days. Oracle raises a warning (ORA-28002) but I don't know how to handle that from the standard Apex login page.
View 1 Replies
View Related
Dec 11, 2012
I have new virtual UNIX machine and I installed oracle client on /usr/lib/oracle. Also I have a oracle database and I am able to connect to this database from my desktop sql developer.
So now I am trying to connect from new UNIX machine. Where I created tnsnames.ora file under /usr/lib/oracle/network/admin and before connecting did export the following
export TNS_ADMIN=/usr/lib/oracle/network/admin
export ORACLE_HOME=/usr/lib/oracle/
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$HOME/bin:/sbin:$ORACLE_HOME/bin
export ORACLE_SID=VFIODSD1
when I try
# sqlplus
username :xxxxxxx
password : xxxxxxx
ORA-12545: Connect failed because target host or object does not exist. Not sure what I missed here. using same tns file I am able to connect from sql developer on windows.
View 1 Replies
View Related
Feb 16, 2011
I type the following command to know what users have access to the database i'm currently connected to:
SQL> select *
2 from all_users
3 /
I know need to know what users are active or inactive. Is there a PL*SQL command for that ?
View 20 Replies
View Related
Feb 27, 2013
I've been issuing commands like these by using a session on my guest Oracle VM that is hosted by Windows 8.
sqlplus / as sysdba
create user PocketGuide3rdEd identified by top-secret-password ;
grant connect to PocketGuide3rdEd ;
grant create table to PocketGuide3rdEd ;
grant create view to PocketGuide3rdEd ;
grant create trigger to PocketGuide3rdEd ;
grant create sequence to PocketGuide3rdEd ;
grant unlimited tablespace to PocketGuide3rdEd ;
I've discovered that I cannot do "sqlplus / as sysdba" remotely. Is there a way I can create another account like sysdba that can issue the above commands from windows so I don't have to log into the oracle guest VM?
View 4 Replies
View Related
Oct 29, 2012
My requirement is to disable access of sys user from all clients even they are providing correct password.
View 2 Replies
View Related
Nov 19, 2010
I do a schema in oracle ... an m my question is if I can create 2 o more users for access to a schema..for example i have schema Project and i need that one administrator and 2 more users with others permission.
View 3 Replies
View Related
Mar 19, 2013
What command can be used to take the previous day upto mid night?
For example
TO_DATE('18-MAR-13 23:59:59', 'dd-mon-yy hh24:mi:ss')
Instead of me entering the date any way to take the previous day till mid-night.
I dont think sysdate-1 will work for me because if I enter sysdate-1 it will take from now -1 that means 18-mar-13 15.45.45 but I want till the previous date until mid-night.
View 3 Replies
View Related
Sep 7, 2011
i am having some indexes upto size of 40gb, i need to rebuild them having only 15 temp tablespace and without downtime
View 5 Replies
View Related
Feb 28, 2013
i have local network 3 pc , and i install database 11g r2 on my server( windows server 2008 r2 64 bit ) ..
i want to access this database from another pc (windows 7 64 bit) to query , insert and modify .
View 2 Replies
View Related
