Server Administration :: Unable To Find Server Process In Oracle Database For Specific Application / Client
Feb 13, 2013
I am trying to find the unix process for one of my application in the database but I am unable to view the same. To simulate, I did the following.
1. My database runs on different server.
2. I invoked "sqlplus" from another unix box to login to the database.
3. I found that the process id (ps -ef |grep sqlplus).
4. When I execute the below mentioned query it does not display the process id that I am looking for. But the osuser, username, program and machine details are correct. How can I know the process details from the database?
SELECT SYS.GV_$SESSION.OSUSER, SYS.GV_$SESSION.USERNAME, SYS.GV_$PROCESS.SPID,
SYS.GV_$SESSION.MACHINE, SYS.GV_$SESSION.PROGRAM,
SYS.GV_$PROCESS.PROGRAM ,SYS.GV_$SESSION.SQL_ID
FROM
SYS.GV_$PROCESS, SYS.GV_$SESSION
WHERE
SYS.GV_$PROCESS.ADDR=SYS.GV_$SESSION.PADDR and SYS.GV_$SESSION.USERNAME='TEST'
and SYS.GV_$SESSION.MACHINE like '%hostname%'
when we ran SELECT statement against CUBE, we got below wait event: resmgr: cpu quantum.Further, we checked below 2 parameters :
NAME VALUE ------------------------- -------------------------------------------------- resource_limit TRUE resource_manager_plan SCHEDULER[0x12B943C]:DEFAULT_MAINTENANCE_PLAN [code]....
It has been found that these sessions did not get enough CPU to process the request. how to find out how many CPU has been allocated to this database ?
> uname -a Linux dukedmts03db02.corp.cox.com 2.6.18-128.1.16.0.1.el5 #1 SMP Tue Jun 30 16:48:30 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
how to analyze how much % of CPU being utilized for a specific session ?
Yesterday I found in alert log file bellows warning. and In that time some clients inform us they are cannot log on to the application. after few times they could log on to database automatically.
In parameter file ---------------------- processes = 4000
Content of alert log file.
Mon Dec 6 16:03:00 2010 Thread 1 advanced to log sequence 67690 (LGWR switch) Current log# 3 seq# 67690 mem# 0: /d01/oracle/oradata/stlbas/redo03.log Mon Dec 6 16:20:39 2010 Process J000 died, see its trace file Mon Dec 6 16:20:39 2010 kkjcre1p: unable to spawn jobq slave process
[code]....
content of listener log file like bellows (in that time only)
I have installed Oracle 10gR2 database server recently in the Windows box. The database works fine. But I am unable to connect through the Internet Explorer. I found that the service for the isqlplus is not available. Do I need to run any script for creating the service?
We are getting problem with the Chinese character set. My current character set is as follows.
PARAMETER VALUE ---------------------------------------------------------------- ---------------------------------------------------------------- NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., [code]....
My column description for the table product is as follows.
when trying to insert Chinese character using the insert command below
insert into product(part_nbr,part_desc,cust_name) values('322341',unistr('功'),'test');
I am getting the value when selecting the same record using the select command
select a.part_nbr,a.part_desc,a.cust_name from product a where a.part_nbr='322341'322341¿test
When I running this command on TOAD
select a.rowid,a.part_nbr,a.part_desc,a.cust_name from product a where a.part_nbr='322341'
and manually editing/inserting '功' character in output from select command above. After that I am able to get the same Chinese character when I am running select next time.
I am getting below ORA-01555 error in alert log everyday.
ORA-01555 caused by SQL statement below (SCN: 0x09ad.86a4562a): Sat Jan 21 08:39:45 2012 SELECT (NVL(MAX(BLOCK_ID + BLOCKS ),0) * :b1 ) / 1024 FROM DBA_EXTENTS WHERE TABLESPACE_NAME = :b2 AND FILE_ID = :b3
I cannot able to find the sql_id here. So how can I find from which process or session this query is firing? before increasing the undo size, I need to analyze as why it is occuring?
Currently maximum process is set to 150 in one of the RAC database. What should we do if the current session is about to reach maximum process or has exceeded the max process.
all of the client cann't connect the db,and using sqlplus / as sysdba also cann't login there are many error of TNS-12535 and in the listener.log
alert.log: Sun Apr 29 18:10:36 2012 opidcl aborting process unknown ospid (42992060) as a result of ORA-604 Sun Apr 29 18:10:54 2012 opidcl aborting process unknown ospid (26280196) as a result of ORA-604
We performed image copy of production Oracle server (OS and instances) to a backup server. After a few weeks, we try to restore a latest Oracle database backup from production server to backup server. As we know, Oracle instance must be unique on the network.
Even we log on to backup server and bring up the instance, I think that still point to production instance since all init file, TNSNAMES.ora and listener file are still same. If we restore the database, we will end up bring down the production instance and restore on top of productions. How to change instance name on backup server including TNSNAMES, sqlnet, listener files in order for us to restore Oracle database from production to backup server?
I have a Client Server application that I created using an MS-SQL Server Database (MS-SQL Server 2008 R2 Express).Since MS-SQL Server has wide range (and number) of DATA_TYPEs, I elected to dedicate a few of those DATA_TYPEs to application-specific processing (mainly the MONEY and BOOLEAN DATA_TYPES).
I further decided that within the Client Application that the general processing of a particular field would be determined by the corresponding DATA_TYPE stored in the database.
The DATA_TYPE of a particular field within the SQL Server database and may be determined by querying:
"select DATA_TYPE from INFORMATION_SCHEMA.Columns where ( ( Column_name = 'my_Field' ) and ( Table_Name = 'myTable' ) )"
I also extract/use other DATA_TYPE information as needed/appropriate.
With this information the Client Application can consistently process a MONEY (a DATA_TYPE in MS-SQL Server) differently than perhaps either a DECIMAL or a BIGINT (two other DATA_TYPEs in MS-SQL Server). I have to create the field with the correct DATA_TYPE in the database, but after that I don't have to worry about it.
I am now moving over to an Oracle Database (Oracle Database Express Edition 11g Release 2). And I would like to have the same (or similar) functionality as described above.
Oracle has fewer DATA_TYPES so it is more difficult to tie an application-specific-datatype to an Oracle-database-specific-DATA_TYPE. There simply aren't as many to "sacrifice" to my application-specific-processing. I don't want to treat every NUMERIC field as "the-apps-money-type."
With Oracle I can associate "the-apps-money-type" with, let's say, a NUMERIC(9,2) and then the Client Application will treat all NUMERIC(9,2) as "the-apps-money-type."The Client Application queries the Oracle database for DATA_TYPE, DATA_PRECISION, and DATA_SCALE to make this determination.
But this approach does not appeal to me, suppose that I have other NUMERIC(9,2) fields that are not of "the-apps-money-type." How can I set and then later determine, from the Oracle backend, if the NUMERIC(9,2) field is meant to be used as "the-apps-money-type" or just a regular number?
Is there some way I may create some sort of "sub DATA_TYPE" in Oracle?I considered indicating this in the COMMENTS field that is associated with particular field. Then query for that comment when I process NUMERIC DATA_TYPEs. But the COMMENTS field does not seem to make it into user_tab_columns or all_tab_columns.
(With Oracle SQL Developer one can create/modify/delete the user created tables/fields. COMMENTS may be added to particular fields within a table--these are the COMMENTS that I am referring to above).What I would like to do, and most direct approach to me, would be to somehow create a user defined DATA_TYPE that is simply:
1) a user defined DATA_TYPE name (like, MY_MONEY_TYPE), 2) associated with an Oracle Built-in datatype (like NUMERIC(9,2).
Then when the client application queries user_tab_columns the field may be processed appropriately. If I cannot do that, perhaps there is somewhere else that I may set and subsequently query for this sort of information. What is(are) the most direct way(s) to implement the functionality described above?
I'm having some difficulty securing my Oracle APEX + Oracle HTTP Server environment.
There are currently around 20 Applications running on the APEX Server, and I'd like to publish 2 of them Externally for users.
I have added a certificate to Oracle Wallet Manager to secure the OHS, but I can access all the Applications on the APEX Server by just changing the Application ID suffix.
How can allow only two applications to be accessible via the internet?
I'm trying to connect a oracle client application on the client machine to a remote oracle server on the server machine but i get a connection fail.
On the server machine I configured oracle server in the following way:
Installed oracle server. Created a database "DB_Test" with the database configuration assistant Created a LISTNER with the Oracle NET Manager with the following parameter:
Protocol: TCP/IP HOST: server pc hostname (ENZOVAIO) or server machine address ip (192.168.0.71) in the network lan Port Number: 1521 Created "dbtest" service with the Oracle NET Manager with with the following parameter: Service Name: "dbtest" Protocol: TCP/IP HOST: server pc hostname (ENZOVAIO) or server machine address ip (192.168.0.71) in the network lan Port Number: 1521
All services on the server machine are running and I opened port number (1521) in the router. On the client machine I installed SQL PLUS and SQL Developer.
With SQL Plus as by the official documentation I have entered the following command:
CONNECT username/password@[//]host[:port][/service_name]. In my case is: CONNECT SYSTEM/oracledb@//ENZOVAIO:1521/testdb.
With SQL Developer I have entered the same parameter.
But with both SQLPlus and SQL Developer the connection fails.
I have installed Oracle in workgroup, while i workgroup it is working fine. But latter I have change the server from workgroup to domain. At that time Oracle was not working , not able to connect. After that I change the Domain to workgroup again. And same problem exist. But I found that lsnrctl is working fine. But OracleServiceXXX is not able to startup in services.msc
I am installing Oracle 12c R1 on Windows 2012. The windows is configured as a domain controller. I am logged in as the domain administrator.I created a normal domain user -- DomainNameORACUSER. I provided this as the existing user id during Oracle installation.
The software installs fine, but when creating the DB using the database configuration assistant, an error is shown "error in process:...inoradim.exe. Enter password for Oracle service user: DIM-00019: create service error. O/S-Error: (OS 87) The parameter is incorrect". The DB is not created.
I skipped the db creation and completed the installation. When tried to create the db using the database configuration assistant after installation, I received the same error.I performed the same installation on Windows 8 and was successful in creating the db.
I have installed a database in D drive. I want to create another database in the same machine. I tried installing the new database using DBCA. Installation was ok. I added entry in TNS file.
When i try to login to this new database from other machine, i am unable to connect to this database. I made an entry in TNS on my local machine. It says the user id /password is wrong, even though they r correct. I am using the same password to delete the database.
I migrated one database ( DB1) from old database server to new database server where user accounts were locked before migrating the database.But migration was successful and database and accounts got created in new database server.
In old database server , user accounts status is locked and in new database server user accounts are open but still i am unable to connect to database using new user in new database server.
why im unable to connect to database whose accounts are open?
im new to DBA.i installed oracle on my pc but im not able to startup database...im manually creating database ..CRD files r still not created as im unable to startup nomount..im getting this error.
SQL> startup nomount ORA-24324: service handle not initialized ORA-24323: value not allowed ORA-03113: end-of-file on communication channel
i almost worked on this for 10 days but im getting the same error...
I am having database A and database B and I am inserting into database b by selecting some records from database a using db link.Is there any way to find whether database link is being used?
We are unable to drop user due to below error, how to drop the below user without shutdown the database.
SQL> drop user mvm_2010 cascade; drop user mvm_2010 cascade * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-14452: attempt to create, alter or drop an index on temporary table already in use
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.
In Process of upgrading Oracle EBS 12.0.4 to 12.1.1 I updated the $IAS_ORACLE_HOME/appsutil/jdk to jdk 6u24. After replacing the original jdk with jdk 6u24 when I attempted to start the apps adoacorectl.sh failed with below error.
Quote:ld.so.1: /d4/app/oracle/apps/12.0.0/vdd700/web/10.1.3/appsutil/jdk/bin/java: fatal: libjli.so: open failed: No such file or d irectory
I followed below steps to update the jdk 1. extracted the jdk-6u24-solaris-sparcv9.tar.Z to $IAS_ORACLE_HOME/appsutil/jdk 2. Copied lib from old jdk to $IAS_ORACLE_HOME/appsutil/jdk 3. Copied lib from oldjdk/jre to $IAS_ORACLE_HOME/appsutil/jdk/jre 4. The java was not infact in jdk/bin rather it was /bin/sparcv9 so I copied them to /jdk/bin. The same way copied the executables from /jdk/jre/bin/sparcv9 to /jdk/jre/bin .