Server Administration :: DBLINK Creation For OS Authenticated Users

Jun 14, 2012

will it be possible to create db_link between two operating system authenticated users belongs to different databases?

View 5 Replies


ADVERTISEMENT

Server Administration :: USERS Tablespace Reached 96 Percent After Manual DB Creation?

Mar 14, 2011

I created manually a database in 10g, after succesfully creating the dB, I created a single user re: LAMS. Now, I noticed that my USERS tablespace is currently at a 99.96% usage:

SQL> @check_space_used.sql
Monday, March 14, 2011 2:46:22 PM SGT

TABLESPACE_NAME TOTALSPACE TOTALBYTES PERCENTUSED
------------------------------ -------------------- -------------------- --------------------
SYSTEM 1073741824 239599616 23
UNDO 268435456 16449536 7

[code]...

View 5 Replies View Related

How To Exclude Externally Authenticated Users In Sql Statements

Sep 13, 2012

I want to exclude externally authenticated users from the following sql statement. i give the following command but still i get the ops$ schema.

SELECT DISTINCT GRANTEE FROM dba_role_privs WHERE GRANTED_ROLE LIKE '%DBA%' AND GRANTEE NOT IN ('SYS', 'SYSTEM','OPS$%');

GRANTEE
------------------------------
OPS$ORAB
OPS$BPRA

View 8 Replies View Related

Server Administration :: Externally Authenticated User Login Syntax As Proxy User?

Nov 15, 2010

I created an externally authenticated user in database. And can login without password with below syntax.

SQL> connect / @TESTDB
Connected.
SQL> show user;
USER is "SCOTT"

This scott user has a proxy permission to another DBuser PROXY_USER. Previously I used to login using below syntax.

connect scott[proxy_user]/password_for_scott@TESTDB

So now, what syntax should be used for this "ExternallY Authenticated" user to login as a proxy user?

View 10 Replies View Related

Server Administration :: Unable To Access Remote Database Using DBLink

May 21, 2010

We have created a new db link. But we are not able access the remote database. When we are trying to access any table using db link system is getting hanged.

We would like to know what are the parameters/permissions which affect the db link access either at data base level or at server level.

One observation we made is that that particular db link is not getting dropped when we tried to drop it.

View 2 Replies View Related

Server Administration :: Db Creation Ctl Error?

Jun 10, 2010

It's been 2 days from now that I'm bugging with this kind of error in my manual dB creation. I used DBCA first but we had a default directory settings, that's why I resorted to create the db manually. The dB was already created and currently has a status of STARTED.. I cannot mount it due to this error:

SQL> startup nomount
ORACLE instance started.
Total System Global Area 247463936 bytes
Fixed Size 2235856 bytes
Variable Size 177840688 bytes

[code]....

View 3 Replies View Related

Server Administration :: Tablespace Creation

Jun 24, 2012

Problem Description: There are five range partitioned tables which are partitioned by date,designed by previous DBA.Four tables are in one tablespace and one more table is in another tablespace.For every three months there are two tablespaces are created autamatically in new names for future dates.There is no scheduled job for this.How they are created?.This is our question.

View 3 Replies View Related

Server Administration :: Manual Database Creation

Jan 21, 2011

manual DB creation.I gone through the below steps:

1) created appropriate folders.

2) Copied a PFILE from an existing DB and changed the contents like DB name etc...

3)Then I Created a text file called %ORACLE_HOME%DATABASEinitmuktha.ora with the following contents: ifile=c:pragpfileinitmuktha.ora

4) Then i set Oracle SID (Through Environment variable in MY COMPUTER --> PROPERTIES...)

5) Then I Created a Windows service for the DB.

6) startup nomount pfile= c:pragpfileinitmuktha.ora

7) Then I ran the database creation command.

The DB was created but when i log in again, it is looking for the pfile in the another DB's location rather than from "%ORACLE_HOME%DATABASE". Where i missed out to create new oracle_home folder?

View 6 Replies View Related

Server Administration :: Manual DB Creation In UNIX

Feb 7, 2011

I am trying to create a DB manually.

1) How to create a UNIX services as we use oradim in windows.
2) While trying to use DBCA command it shows the below message.

SET DISPLAY ENVIRONMENT THEN RE-RUN.

My login is already in admin group only.

View 7 Replies View Related

Server Administration :: IFile In Manual DB Creation?

Feb 5, 2011

While creating a Manual DB creation, syntax as below:

%ORACLE_HOME%DATABASEinitprag.ora which will have a seperate file as below:
ifile=c:pragatpfileinitprag.ora

1) Why we need to divert the pfile into another location?

2) Can we keep the pfile inside the location - %ORACLE_HOME%DATABASE?

View 1 Replies View Related

Server Administration :: Number Of Users Logged On

Aug 12, 2013

How to find the number of users logged, in a database level(Oracle), b'coz generally in OS level (Linux) , the command will be '$ users',

View 4 Replies View Related

Server Administration :: Default Users In Oracle 9i?

May 31, 2010

how many default users available in oracle 9i version.

View 4 Replies View Related

Server Administration :: How To Get Password For Database Users

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

Server Administration :: How To Get Size Of All 80 Users From Database

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

Server Administration :: Database Creation Manual Error

Sep 16, 2011

i am creating database manually in oracle 9i os version ibm-aix5.3 it showing following error

CREATE DATABASE "varathu"
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: controlfile could not be created
ORA-00202: controlfile: '/backup/varathu/control01.ctl'
ORA-27040: skgfrcre: create error, unable to create file
IBM AIX RISC System/6000 Error: 13: Permission denied

View 18 Replies View Related

Server Administration :: Manually Oracle Database Creation?

Feb 21, 2013

how to create database manually(without dbca).

View 2 Replies View Related

Server Administration :: System And Users Table Space

Oct 15, 2011

a newbie dba here..

select TABLESPACE_NAME,
sum(BYTES) Total_free_space,
max(BYTES) largest_free_extent
from dba_free_space
group by TABLESPACE_NAME
/

result output is attached .txt file.

the SYSTEM & USERS table space shows only <10 mb free space. Is it a bad sign? What I should do ?

View 7 Replies View Related

Server Administration :: USERS Tablespace Should Not Contain Schema Objects?

Jan 31, 2012

I heard that USERS tablespace should not contain any other application schema objects.

If the above statements is true , why it should not contain other schema objects ?

View 7 Replies View Related

Server Administration :: Transfer All Users From Server A To B?

Feb 23, 2012

i want to transfer all users from server A to server B how can i do that along with their rights and password?

View 2 Replies View Related

Server Administration :: Deferred Segment Creation - Default True?

Jan 20, 2010

What do you think of this 11.2 parameter? It can give some pretty weird results.

SQL> create tablespace ts1 datafile size 10m;
Tablespace created.
SQL> create table t1 (c1 date) tablespace ts1;
Table created.
SQL> drop tablespace ts1;
Tablespace dropped.
SQL> insert into t1 values(sysdate);
insert into t1 values(sysdate)

[code]...

View 5 Replies View Related

Server Administration :: Modified Objects - Compare Two Users On Different Databases

Oct 2, 2012

I want to compare two users on different databases, actaully there are two users one in user a on database a and another user b on database b they have same tables, and everytime when a table or object is created on user a (database a) i will take the table name ,procedure or any other object from user_objects based on ddl_created date and then i need to recreate the same on user b on database b, is there a way to find out tables which are not only created but also i need to check whether if there is any column added or any change in procedure or any other objects.Is there a way to generate the scripts based on list of objects selected from user_objects.
all i want is.

a)Find out the list of objects added along with creation scripts
b)find out the list of objects modified along with creation scripts.

View 2 Replies View Related

Server Administration :: How Many Users Can Be Created In Oracle 11g Release 2 Database

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

Server Administration :: TNS Error - DBCA After Database Creation Script Complete

Aug 15, 2010

I'm getting a "TNS disconnect" after database creation script creation in DBCA. Haven't figured out what's going on. I'm attempting to create a 2nd database on one linux 64 server. I get all the way through DBCA, but it won't go the final mile. Any thoughts? I've tried setting the port to a different port from the existing LISTENER, creating a LISTENER2 and associating it with the 2nd instance.

View 1 Replies View Related

Server Administration :: Get Details Of SYS / SYSTEM Users Logon And Logoff Time

Aug 13, 2012

I want to get the details of the SYS/SYSTEM users logon and Logoff's time.

Steps 1:
=======
SQL> SHOW PARAMETER AUDIT

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string C:ORACLEPRODUCT10.2.0ADMIN
DB10GADUMP
audit_sys_operations boolean FALSE
audit_trail string NONE
SQL>

Step 2:
=======
Set the Necessary parameters:
-----------------------------
alter system set audit_trail=db scope=spfile;

Step 3:
=======
Shutdown the DB

Step 4:
=======
Restart the DB

Step 5:
=======
For auditing the Session. Fire the below command.

AUDIT CREATE SESSION;

Step 6:
=======
select DISTINCT USERNAME,os_username,timestamp,logoff_time
from DBA_audit_session;

When I fire the above query, I couldn't get the SYS user's LOGOFF time. But for rest of the users, I am getting.

View 12 Replies View Related

Server Administration :: Creating A New Tablespace With Datafile / Assign Users To Current Tablespace

May 27, 2011

i have a tablespace which contains 121 datafile(max limit reached) as a dba what we have to do?

creating a new tablespace with a datafile and assign the users to the current tablespace which i created now.iif the above process is correct,after some time the tablespace which was filled up got freed up.now can i give the access to the users previous (i.e. freed up tablespace) and current tablespaces

View 9 Replies View Related

Getting Data Over SQL Server DBLink

Apr 17, 2012

I just created a dblink from our Oracle 9i database to a SQL Server 2008 R2 Server using oracle heterogeneous services. The dblink seems to be OK and I can query the remote SQL Server database but I only get results for numeric columns.

Say the remote SQL Server table was created like:

CREATE TABLE [MITLOC] (
[MLCONO] [numeric](3, 0) NOT NULL,
[MLWHLO] [nchar](3) NOT NULL,
[MLITNO] [nchar](15) NOT NULL,
[MLWHSL] [nchar](10) NOT NULL,
[MLBANO] [nvarchar](20) NOT NULL,
[MLCAMU] [nvarchar](20) NOT NULL,
[MLFACI] [nchar](3) NOT NULL,
[MLWHLT] [nchar](2) NOT NULL,
[MLSTQT] [numeric](15, 6) NOT NULL)

The remote dblink is named after M3PREP.

Then if I run:

CODEselect MLCONO, MLSTQT from MITLOC@M3PREP => this works OK and I get the two columns.

If I run:

CODEselect * from MITLOC@M3PREP => I get the same results as in the previous query and all nchar, nvarchar type columns are missing, I only get the same two columns.

If I run:

CODEselect MLCONO, MLWHLO from MITLOC@M3PREP=> I get ORA-00904 - the column name entered is either missing or invalid.

I set up my .ora init file like this, I suspect there is something missing here, is it related to the NLS_LANG or so?

CODE#
# HS init parameters
#
HS_FDS_CONNECT_INFO = M3PREP
HS_FDS_TRACE_LEVEL = 4
HS_FDS_TRACE_FILE_NAME = M3PREP.LOG

#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>

View 1 Replies View Related

SQL & PL/SQL :: Accessing Data From Server By Using DBLINK

Oct 22, 2010

We are accessing data from the server ADM.WORLD by using DBLINK.We got the following error.

PL/SQL: ORA-04052: error occurred when looking up remote object
sysadm.PS_HP_INC_ELIG_VW@ADM.WORLD
ORA-00604: error occurred at recursive SQL level 1
ORA-28000: the account is locked
ORA-02063: preceding line from ADM

For that we checked in the server ADM.WORLD for the account the account is showing locked .After that we successfully accessed the object sysadm.PS_HP_INC_ELIG_VW@ADM.WORLD.

For next day also the account is locked.Why the account is frequently locking.

View 15 Replies View Related

Server Utilities :: Connect To Databases With DBLINK

Jul 17, 2013

I'm try to connect to databases with DBLINK. It works, but I drop the dblink to do it again in the final server. The problem that I now is that there is not any DBLINK in my database but I can see the data of the other database (with select 1 from DATABASE.TABLE)

Is my database saving the data of the other database without de DBLINK?

View 4 Replies View Related

Heterogeneous Connectivity :: Connecting MS SQL Server From Oracle Using DBLink?

Nov 12, 2013

Oracle 11g on linuxdestination : ms sql server 2005 i need to create the db link from oracle to ms sql server to view the tables , is it posibble without configuring the gateways( as looks like it is licenced product) 

View 2 Replies View Related

ASM Disk Groups Creation After ASM Instance Creation

Jul 9, 2012

During ASM Disk Groups creation after the ASM instance creation, receive the following error: Disk Group ORAASMGROUP2 already exists. Cannot be created again

The Grid infrastructure was deinstall one time and still the same issue.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved