Server Administration :: Access Logs Via SQL

Jul 14, 2011

I'm currently working on a project in which I do not have permissions to access the Server where the database is installed and configure.Because of company policies, I do not have Admin Rights over Oracle, but I do have an account that can make Selects to DBA_USER_PRIVS for instance.

I would like to know if there is any way to access the database logs to know if there was any kind of problem within the database, because one of my Schemas misteriously went clean (all tables, sequences, triggers, ... vanished)

View 4 Replies


Server Administration :: Comprehension Of Different Logs

May 11, 2010

I always find difficult to understand the alert logs and other log of cluster as well so i am wondering what to read for . do i need operating system knowledge or oracle architecture knowledge or some concepts or ?. as i saw many experts and even normal dba always talk about read logs and they are quite technical so how can i achieve to understand these logs completely

View 1 Replies View Related

Server Administration :: Monitoring Alerts And Logs?

Dec 19, 2012

I have version installed in a server AIX and i'd like to know where are alerts and logs like "max extents reached in table....". I don't see them in alert.log.

Where is the best way to monitoring this class of alerts and logs?

How can i see how many actuals extents go consumed in tables and indexes?

View 10 Replies View Related

Server Administration :: Access To Database Server Machine Login?

Apr 30, 2012

database administration , we are planning to use amazon cloud database , this database does not allow us to login to server machine , unfortunately amazon don't provide ssh to this machine , in general for doing any of adminstration task on the database will there be need to log into the machine ? we can always log in through toad or any other sql client but we cannot do ssh to server..general can this limitation effect administration ?

View 9 Replies View Related

Server Administration :: DB Link For One To Many User Access

Sep 14, 2010

I need to create one to many user DB link in oracle 10g. Meaning I have a user A in database 1 and I want to access the objects from user B,C,D in database 2, how to create a public database link so that i can have this one to many user access?

View 8 Replies View Related

Server Administration :: How To Track The Last Access To A Table

Oct 11, 2011

is it possible to track the last access to a table?

View 2 Replies View Related

Server Administration :: DB Link Access To User

Sep 3, 2013

I have login through the sysdba and created dblink and modified the tnsnames.ora for necessary changes. And the it started working correctly and I can able to get the data by selecting it.But when I login with different user that is showing the following error.

ORA-12154: TNS:could not resolve the connect identifier specified

How to resolve this,is there any privileges or permission need to give to that user.

View 5 Replies View Related

Server Administration :: ASM Instance Did Not Access Raw Devices

Sep 28, 2011

I've to install Oracle 10g on Solaris 10, Sparc. I prepared anything successfully, but, when I gone to create ASM instance, I found the Create new bow did not show any disks into. I take brief something:

1- Sparc & disks preparation:

# isainfo
sparcv9 sparc
# ls -lL /dev/rdsk/c4t50060E800570B715d0s6
crw-rw---- 1 root sys 336, 14 Sep 28 14:08 /dev/rdsk/c4t50060E800570B715d0s6
# ls -lL /dev/rdsk/c4t50060E800570B715d2s6
crw-r----- 1 root sys 336, 62 Sep 28 14:09 /dev/rdsk/c4t50060E800570B715d2s6
# ls -lL /dev/rdsk/c4t50060E800570B715d3s6


Those 6 partitions disks above were supplied to ASM, so, I make mknod to link them.

# ls -lrt /asmdisks
total 0
crw-r--r-- 1 oracle dba 336, 110 Sep 28 15:35 disk6
crw-r--r-- 1 oracle dba 336, 94 Sep 28 15:39 disk5
crw-r--r-- 1 oracle dba 336, 78 Sep 28 15:39 disk4
crw-r--r-- 1 oracle dba 336, 30 Sep 28 15:39 disk3
crw-r--r-- 1 oracle dba 336, 14 Sep 28 15:39 disk2
crw-r--r-- 1 oracle dba 336, 62 Sep 28 15:39 disk1

Well, I go to ASM, but And nothing on Available Disk Groups.

View 2 Replies View Related

Server Administration :: How To Give Full Access To Other Schema

Apr 15, 2012

I want to get clear with one thing yesterday i installed oracle9i and dev 2000 to my client.

when they run one report they got stuck with pl/sql compilation errorrep-1247

when i checked that report in the report builder, in the query they are using some other table which is not belongs to that schema,then I give that schema.tablename and compiled, but this is coming for other reports also, then only i came to know that they are acceessin other schema also, how can i sort this out.

can i fix this by givin full access privilige or what privilige can i give to get full access of other schema table.

how can i check in the old database what are all the roles and privileges given to this user,

View 5 Replies View Related

Server Administration :: Access Redo Generation After Migrating From 9.2.0 To

Sep 14, 2010

We had our production database hosted on Oracle 9.2.0. Few months back we have migrated it to Oracle After Migration I have noticed that redo generation has become very very high. In earlier case no. of log files generating in production hours were around 30 where as after migration it become around 200 files per day. I have run statspack report on this database. Report is saying that db block change & disk write is become very high. Parameter timed_statistics has also been set to FALSE. Even then there is not any reduction on no. of log file generation. I had used import export for upgrading the databases.

View 13 Replies View Related

Server Administration :: ORA-16000 / Database Open For Read-only Access

Apr 5, 2010

I am facing a strange issue on 11gR2 (OEL 5.4) standby readonly with apply database.It's throwing 16000: database open for read-only access during SELECT's .

Here is snapshot of errors.

ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access

SQL> l
1* SELECT t0.airportID, t0.archived, t0.assetTag, t0.bluetoothID, t0.cmBundle, t0.createdDate,
t0.currentProductTaskID, t0.ethernetID, t0.failOrReworkCount, t0.highestCompletedTaskTypeID, t0.lastModDate, t0.lastStationID,
t0.modCount, t0.modelID, t0.oemSerialNumber, t0.orgSerialNumber, t0.pdmVersion, t0.preburnComplete,
t0.productID, t0.reworked, t0.secondaryEthernetID,
t0.serialNumber, t0.shipped, t0.specialBuildTypeID,


View 7 Replies View Related

Server Administration :: How To Access Active Directory With Oracle Database

Oct 12, 2012

How to access Active directory(Microsoft 2003) with oracle database 11g.

View 1 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 Utilities :: Remove Current Archive Logs

Sep 12, 2011

Developer is importing some large volumes of data. As the filesystem was filling up fast, I removed the all the archive log files. Will this affect the functioning of database? It is a development environment.

View 6 Replies View Related

Server Utilities :: How To Access Local File Residing At Client From DB Server

Nov 23, 2011

I have a requirement to read flat text file(around 15000 lines) residing at a client location from DB server and write into a table in One cell.

I tried UTL_FILE and DBMS_LOB but, i am not able to access client location to read the file as it reads path from Oracle Directory.

my client path is and my DB server is in unix say
file location is: \
So I created One Oracle directory as MY_DIR having DIRECTORY_PATH as '\'.
But both UTL_FILE and DBMS_LOB is not able to access the file.

Error Message:
Unable to process CLOB -22288 ~ ORA-22288: file or LOB operation FILEOPEN
No such file or directory

Few Details for reference:
File Location: \
Unix DB Server location:
Table : Test (filename varchar2(30), Content CLOB)
Oracle Dir: MYDIR
Directory_Path: \

View 7 Replies View Related

Application Express :: ORA-24247 / Network Access Denied By Access Control List

Apr 5, 2013

When I invoke SOAP Web-Service using APEX_WEB_SERVICE.MAKE_REQUEST, then I'm able to get response from web-service. However all German character are replaced by JUNK data. However data is coming fine when I test web-services using SOAP UI.

I tried to invoke web-service using UTL_HTTP. However when I use UTL_HTTP, then I'm getting following error.

ORA-24247: network access denied by access control list

<li> Why German characters are replaced by Junk data while invoking web-service from APEX, while it's working fine from SOAP UI

<li> When I can access web-service successfully using APEX_WEB_SERVICE, then why it's throwing ORA-24247 error when I call using UTL_HTTP?

DB: Oracle Database 11g Enterprise Edition Release - 64bit Production
Web-Server: EPG


View 4 Replies View Related

ORA-24247 / Network Access Denied By Access Control List (ACL)

Dec 12, 2012

I am having oracle database version standard edition, where one of my users requirement is that he wanted to send mails from oracle database but he is getting below error

ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 267
ORA-06512: at "SYS.UTL_SMTP", line 161
ORA-06512: at "SYS.UTL_SMTP", line 197
ORA-06512: at "HF_REPORTING.SEND_MAIL", line 12
ORA-06512: at line 18

is it possible to send mails from oracle database in STANDARD Edition?

View 1 Replies View Related

SQL & PL/SQL :: ORA-24247 / Network Access Denied By Access Control List (ACL)

Nov 15, 2011

While Running the proc,it's raising the below error.

Error report:

ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 246
ORA-06512: at "SYS.UTL_SMTP", line 115
ORA-06512: at "SYS.UTL_SMTP", line 138
ORA-06512: at line 1


View 12 Replies View Related

SQL & PL/SQL :: Access Table From One To Another Database On Same Server

Jun 22, 2010

How can we access a table from one database to another database on the same server.

Let us say One database is "A" and the Other database is "B" both databases are running on one server "ABCD".

My question is how can we access a table from database B to database A.

View 21 Replies View Related

Forms :: 10g Server - Access Each Form Via Button

Mar 30, 2011

i am building a system and have created some forms, but when i view them on 10g server online i only want each form to be accessed via a button of which i have placed code to go to that block. not be able to use the arrows to skip.

View 1 Replies View Related

Forms :: Access File From Server Via Static IP At Outside LAN

Jul 4, 2011

I am using oracle 9i release 2 and forms 6i.I have a question,I have stored all the fmx files under one folder in a single server called "MAINSERVER".From here only client system calls the forms.In am calling forms in call_form function like


here mainserver is the server name, forms is the folder name and employee is the form name in fmx format.My question is when i call form from server with in a network no problem but When i call form from outside lan that through internet via static ip forms are not called.I tried like this way call_form('\',no_hide).Here i have specified static ip and forms folder but is not working.

View 7 Replies View Related

ORA-01115 - ORA-01110 - Cannot Access Dbs.after Reboot Server Only Db?

Jul 22, 2012

After getting the following error ,Our production oracle db server is crashed,we cant access the dbs.after reboot the serveronly we can access the db,

ORA-01115: IO error reading block from file ORA-01115: IO error reading block from file 83 (block # 639938)
ORA-01110: data file 83: '/oradata/prod/prod_data04.dbf'
ORA-27091: unable to queue I/O
ORA-27072: File I/O error


View 3 Replies View Related

Windows :: Connecting Oracle To Remote Access Server?

Mar 2, 2011

Is it possible to connect Oracle to MS Access database sitting on remote server? I need to join the tables in Oracle and MS Access.

View 5 Replies View Related

Monitoring Script From Client Side (no Access To Server)

Sep 12, 2012

We are on oracle on Solaris 10. I dont have acces to the db server but connect to the db from the client side using sqlplus. though I have dba privilege (at oracle level) but no access to db server at os level. I also dont have access to enterprise manager console where such information is available.

I want to set up monitoring so that I can get a mail when the space falls below some threshold like say tablespace is 90% full. Is it possible to get mail from pl/sql script for example?

View 1 Replies View Related

Server Utilities :: Cannot Access NLS Data Files Or Invalid Environment Specified

May 15, 2010

I exported oracle database from one server in a dmp file. then i imported it in another oracle database server. when i saw the imported data the columns which were storing german data is in rubbish characters.

then i remember that the database from where i exported is having nls language as german. i executed this statement to set the nls on the new server

alter system set nls_lang=german SCOPE=SPFILE

but now my database is not getting started always giving me error - cannot access NLS data files or invalid environment specified.

i also set the path NLS_LANG=german in the solaris environment.

View 1 Replies View Related

Server Utilities :: KUP-00554 / Error Encountered While Parsing Access Parameters

Dec 2, 2010

I receive the following error message

ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "identifier": expecting one of: "binary_double,


when I select count(*) on the external table created below.

SQL> CREATE TABLE cac_500_load
2 (


Here is the db version info:

SQL> select * from v$instance;
--------------- ----------------

View 12 Replies View Related

Server Utilities :: How To Load Data In Oracle From Microsoft Access Database (MDB) File

Aug 24, 2012

I have one .mdb (Microsoft Access Database) file and it has some tables in it. I had load it once using toad. But now i have to load it frequently into the database. Is it possible using external table, so i can access that tables using "select" statement.

View 6 Replies View Related

SQL & PL/SQL :: UTL_FILE.FGETATTR Can't Access Files On Network Disk After Database Server Was Restarted

Jun 20, 2012

I managed to upload images to a database server, resize them, copy to the application server and everything worked just fine - the Apex page successfully displayed images. Since last week, things have broken. This is how: there's a directory object which points to application server's directory:

SQL> select * from all_directories;

------- ------------------------------ -----------------------------------
SYS SLIKE_4005_UPLOAD d:gisslike_4005_upload --> on a database server
SYS SLIKE_4005 \my-iasd$homegisslike_4005 --> on an application server


I can use a directory located on a database server:

D:GISSlike_4005_upload>dir photo_resize.*
Volume in drive D is RAID
Volume Serial Number is 88F2-69D2
Directory of D:GISSlike_4005_upload

How come it doesn't work? I was absent last week, database server was restarted for some reason (there were Windows' updates which required restarting). After that, all applications (lucky us, just two of them, but in multiple procedures/functions) return FALSE for UTL_FILE.FGETATTR.

We recreated directory objects, but that didn't work (UNC or not, no difference). I Googled quite a lot, read Metalink notes - nothing I did solved the problem.

what these OS updates were about; maybe they are not to be blamed at all. Both servers (database & application) run MS Windows Server 2003 Standard Edition Service Pack 2. In the meantime, a colleague developed a workaround (it uses UTL_HTTP) which works, but it is MUCH slower than the previous UTL_FILE.FGETATTR option.

Why don't we keep these images on the database server (instead of the application server)?I was told that Apache is incapable of accessing mapped network directories so we used what we could.

View 13 Replies View Related

PL/SQL :: Index Range Scan And Table Access By Index Rowid Versus Table Access Full

Oct 5, 2013

Let's consider such table that all rows fit into single block:

SQL> create table test as select rownum id, '$'||rownum name from dual connect by level <= 530;
Table created.
SQL> create index i_test on test(id);
Index created.
SQL> begin


why does approach with full scan take longer even if table occupies only one data block? PS. 11gR2

View 8 Replies View Related

Server Administration :: Create Tablespace For Administration

Nov 29, 2010

i'm a student currently learning database administration security.

I need to create a tablespace for administration of database but i don't know what datafile settings are best suited for admin usage.

I have attached the schema that was given to me for this assignment.

View 12 Replies View Related

Copyrights 2005-15, All rights reserved