Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by markrem

  1. markrem

    how to install Oracle

    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...
  2. markrem

    alert log shows error relating to network buffer

    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...
  3. markrem

    Startup 10g Windows Exclusive

    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...
  4. markrem

    Accessing a 10g database from Citrix

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

    rman materials

    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...
  6. markrem

    ORA12518

    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...
  7. markrem

    Newbie - How do you install ODBC to connect to a RAC cluster?

    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...
  8. markrem

    CDC Time Lag

    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
  9. markrem

    Create PDF

    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...
  10. markrem

    Recovery To Another Database

    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...
  11. markrem

    Segregation of Duties and making auditors happy

    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...
  12. markrem

    any limit on use of Returning clause?

    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...
  13. markrem

    See when a table has been modified

    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...
  14. markrem

    Connect to the oracle without tns name

    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...
  15. markrem

    How to user Onames with 10g

    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...
See more

Part and Inventory Search

Back
Top