Recent content by markrem

I think you are missing something big, like a database. During installation of OAE it will ask you to select a database where it can install schema objects. This means before installing OAE you should create an Oracle database and ensure the client computer has connectivity to the database...

It means log writer (LGWR) was able to pass data to the log network service (LNS) faster than the LNS was able to post the data to the remote or "standby" location. That make sense, because LGWR operates locally and LNS operates over the network, and network operations are slow relative to a...

If you are not using RAC, then STARTUP is exclusive by definition of non-RAC. If you are using RAC then then command STARTUP EXCLUSIVE requires you first set initialization parameter CLUSTER_DATABASE=FALSE in the SPFILE, then shutdown all instances, and then start the one instance you want...

Speaking of permissions, your Oracle guys should look at Oracle Note 361325.1.

I put a free copy of my book's RMAN chapter on the Internet. http://www.remidata.com/book_nuts2soup_samples.htm This was the draft version, but it should have what you are looking for. Keep in mind it's an RMAN chapter, not an RMAN book. :) MarkRem Author, Oracle Database 10g: From Nuts...

On 32-bit Windows you can have a maximum of (2 GB / thread-size) threads within the overall oracle.exe process. The default thread size on Windows is 1 MB, but is genearlly 3+ MB per thread for dedicated oracle connections. Don't forget Oracle uses many threads for itself. This all implies...

Of course your ODBC Data Source is mapped to a tnsnames entry, not directly to an IP address. For example, in ODBC you create a datasource named SALES and map it to tnsnames.ora alias ORCL123. On the client computer you install Oracle Client, and then you setup the file...

The logs need to be pushed along so there's something to scrape. Did you setup the heartbeat table? MarkRem Author, Oracle Database 10g: From Nuts to Soup http://www.remidata.com/book_nuts2soup.htm

One way to do this is using Oracle ExtProc. First, get a PDF generator like the earlier poster said. Then, configure your Oracle listener for extproc. Then, you must create a C or Java program at the operating system level that calls the PDF software and passes parameters necessary to...

Do not open the database until after you have rolled forward. Try this: startup nomount create the new control file alter database mount set autorecovery on recover database until cancel alter database open reset logs using backup controlfile. MarkRem Author, Oracle Database 10g: From Nuts to...

Yes, there are several Oracle books on the market which suggest you separate the Database Administration from Security Administration. I think most of the time they refer to this new user or role as secmgr. There's much more separation than you discussed. For example, when you say a DBA can...

You can use the RETURNING clause with INSERT, UPDATE, and DELETE provided they do not involve queries. For example, the following would be illegal: insert into emp_tmp select * from emp where id=12 returning emp_name into :myvariable; I suspect that because you are using a refcursor and...

set init.ora parameter audit_trail=true. this only enables the feature, does not actually do anything. second, issue command AUDIT ALL ON COUNTRY_LIST BY ACCESS; The results are produced faster and safer than when using triggers. Third, to see the results SELECT * FROM DBA_AUDIT_TRAIL WHERE...

The ODBC drivers shipped with Oracle require a local copy of the Oracle Client software. The ODBC driver does a callout to TNS, which reads sqlnet.ora to determine what type of names resolution you are using, such as tnsnames. It then reads tnsnames (or whatever resolution method you are...

ONames was desupported in 9i, I believe. It wasn't removed until 10g. Yes, the replacement is your choice of OID, tnsnames, easy connect, hostname, cds, or nis. OID is Oracle's LDAP and heart of their identity management solution, which can also be used as a names server to support sqlnet...