Tag Info

Hot answers tagged

4

I'm afraid it is practically impossible. In Oracle's terminology external authentication means: "If users's name on client machine is identical to user's username in database, then user does not have to enter ANY password". This way of authentication is very weak and must be combined with other security features, for example you allow users to login only ...


4

Because you are not logged in as the user system. When you execute conn system/password as sysdba, Oracle won't even check the user and password (--> from the local systeem where the db is running on). If you enter the system/password as sysdba and then execute 'show user', you'll notice you are logged in as user 'SYS'. So you are actually entering the wrong ...


3

No, you have to upgrade in stages, which wouldn't actually be possible now because Oracle 8.x and 9.x are now unsupported and the software is unavailable (unless you have an Oracle support contract and ask them for copies of the software). Read the Oracle® Database Upgrade Guide 11g Release 2 (11.2) for more information. Your best bet, assuming you have ...


3

First, if you are creating a procedure in a package, the package name will need to be included when you call the procedure. begin hotel.fill_city(10000); end; / should correctly invoke your procedure. Second, you have issues with the naming of your local variables. Normally, you would not create local variables like city and postal_number that are the ...


3

You can create tables because the RESOURCE role has the CREATE TABLE privilege granted. To create a view, you need to have granted the CREATE VIEW privilege additionally, because, by default that privilege is not granted, not even to RESOURCE. SQL> select privilege from dba_sys_privs where grantee='RESOURCE'; PRIVILEGE ...


2

You can find this information in dba_users.profile view: http://docs.oracle.com/cd/E18283_01/server.112/e17110/statviews_5081.htm


2

So the disaster has been averted. The issue is an apparent "bug" - because I have no other word for it - with Oracle when you attempt to use a pfile that exists in the %ORACLE_HOME%\database directory. Oracle 11gR2 will apparently not correctly load any pfile that exists in the same directory as the spfile, even if you supply the full path and filename. ...


2

You'll find that information the the Oracle reference document 1307195.1: Certification Information for Oracle Database on Microsoft Windows x64 (64-bit). The latest Windows server version where 11.2 is supported is Windows 2008R2. Oracle 12c (12.1) is supported on Windows 2012 (including Hyper-V guests), but only in single instance mode (no RAC). You can ...


2

You don't want your test database to retain the same internal id number as the production database. Hence it would be best to use RMAN's command DUPLICATE, because it sets a different id (and also a new database name). This command is specifically designed to do what you require.


2

In-fact if you need to do the external authentication for client you it can be done via external password store: 1) you need to make the password external use SHA-1 hashing algorithm. (note this is not compatible with jdbc-4). 2) open sqlnet.ora and make sure it contain the following line (if note you need to add it then save and close) ...


2

They are Oracle Resource Manager waits. Resource Manager is a set of Oracle functionality that lets you prioritise work. See the list of possible waits in the documentation.


2

The document that has the client/server compatibility matrix is 207303.1 Client / Server / Interoperability Support Matrix For Different Oracle Versions. (Oracle support account required) Oracle client version 12c is compatible with Oracle server version 11.2 (and below), so no your error isn't likely to come from that. Check that the listener is indeed ...


2

Generate the statements you need select 'DELETE FROM '||table_name||' ;' from user_tables;


1

since you confirmed the character set in the database is AL32UTF8, you need to make sure the fonts is installed on the Linux machine, and install the message libraries. that will make ORA_NLS33 has been set appear when you execute alter session set nls_language=


1

Roles are not owned, but granted to users: select grantee from dba_role_privs where granted_role = 'LANDING_R'; Object privileges granted to LANDING_R: select * from dba_tab_privs where grantee = 'LANDING_R'; System privileges granted to the LANDING_R: select * from dba_sys_privs where grantee = 'LANDING_R';


1

Yes it can. We are currently using it on a 11g RAC database. Do you need any other details?


1

Thanks for the information. I was in the middle of a case where OLS wasn't installed. So, the procedure I used was as follows: Shutdown all instances On the main node, as user oracle, run $ORACLE_HOME/oui/bin/runInstaller (it could be necessary count on installation media) Select "Advanced Options", select "OLS" (after that, option changes to ...


1

This is the expected behaviour on a unix system. either a process' effective user id allows to read/write a file or itseffective primary or its effective secondary group ids allow to read/write the files If you log on to a unix system the effective user id , the effective group id and the effective secondary group ids are the ids defined for your login ...


1

I'm hard-pressed to imagine how you'd accomplish that with a single cursor in SQL Server. The same question has been asked and answered on StackOverflow. If you want to get really tricky, you could also use an XML Query to search across objects with a single query. In either case, the result is going to be insanely slow since you're full scanning every ...


1

DB links are probably not going to work as a solution. Oracle7 is crazy old. The question's facts are little limited. What types of objects (e.g., tables, stored procs, triggers, etc.) are involved? How much data? That said: As it relates to table data, my solution would be to spool the data to text and access the text via external tables you setup in the ...


1

It looks like resource manager is in action. Your dba configured this most likely to give certain processes priority over other processes. Oracle Scheduler is fuly integrated with Resource Manager but the way this is presented is a bit misleading. Often it has nothing to do with Scheduled Jobs at all. You can find which sessions are waiting for resource ...


1

So you have a VARCHAR column, and a NUMBER filter. The implicit conversion indeed allows a NUMBER -> VARCHAR conversion, but the problem is that when applying the filter, Oracle tries to do it the other way, ie. to convert the VARCHAR column into a number, thus the error gets thrown :) Don't really see any solutions here except updating the SQL query. This ...


1

That is the MySQL documentation, not the Oracle Database documentation. There is no such clause in Oracle Datababase. Use a trigger. Here is an example: link


1

From this link: An old ORACLE_HOME had not been deinstalled/removed correctly and the following registry information still existed: [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OracleMTSRecoveryService] [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OracleMTSRecoveryService\Protid_0] "Name"="HTTP" "Host"="hostname" "Port"="49155" ...


1

The error you encounter can have many causes. One is an incorrect environment. For Oracle, the variable ORACLE_HOME is very important. Start with setting that to where you installed your Oracle software. Next make sure that PATH points to %ORACLE_HOME%\bin After that, set the variable ORACLE_SID to the sid of your database instance. (The sid is part of the ...


1

For your database to open and mount, first ensure that you are logged in as the user oracle Then start by checking whether your listener has been started, using the command lsnrctl status Also, please provide the details of the environment in which you are running Oracle, i.e as an active/standby in dataguard, or standalone, and also what version of Oracle ...


1

set ORACLE_SID=database set TWO_TASK= sqlplus /nolog CONNECT /@database as sysdba startup


1

I have worked with Oracle Xmltype for the last 4 years, starting with Oracle 10.2.0.4 and now on Oracle 12c. I find it very reliable. We have used it not only for storage, but also XML manipulation. In that regard Oracle has chosen XQuery above XSLT. The performance is dependent on the way you define the storage of these XMLs. You can store them as CLOB, as ...


1

Ultimate source for such answers is Oracle Database Licensing Information. Sadly to downgrade from Enterprise to Standard Edition you have to export all the data install Oracle Standard Edition and import data (Doc ID 139642.1). From your list "Automatic SQL Tuning Advisor" is Enterprise Edition only feature. As a rule of thumb - features which needs AWR ...



Only top voted, non community-wiki answers of a minimum length are eligible