User Profile

Collapse

Profile Sidebar

Collapse
smashzone
smashzone
Last Activity: Dec 4 '07, 01:13 PM
Joined: May 3 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • smashzone
    replied to Cannot able to connect the oracle database
    in Oracle
    Just a follow up, if you want to coonect to a database in windows (and this depends which oracle version you are using), make sure that you have your ORACL_SID environment variable set. And from the command line, simply issue the following:

    sqlplus /nolog

    conn /as sysdba


    Hope this helps
    Cheers
    Smashzone
    See more | Go to post

      Leave a comment:

    • smashzone
      replied to Cannot able to connect the oracle database
      in Oracle
      How can i use the oracle database on a local / single pc . what are the settings required in tnsnames.ora?


      I'm not sure what you want to do, but if you install oracle database on your pc, there are no settings required in your tnsnames.ora file, oracle will configure this automatically during installation.

      Where should i store the database on my local computer, ie. c drive / d drive?


      Well,...
      See more | Go to post

        Leave a comment:

      • smashzone
        replied to how to start a distributed database
        in Oracle
        I do not know why you need two databases, you can use one database and access it via LAN using VPN.

        Hope this helps
        Cheers

        Smashzone
        See more | Go to post

          Leave a comment:

        • smashzone
          replied to Connecting To Oracle Database From Unix(script)
          in Linux
          Definition of a script: a script is an automated sequence of related commands
          Therefore, you dont need a script to connect to a database

          Step 1
          Login to your server (ssh <ip adress>) using program called putty as the oracle user and provide the relevant password

          example:
          login as: oracle
          Sent username "oracle"
          oracle@192.168. 103.60's password:
          Last login: Wed...
          See more | Go to post

            Leave a comment:

          • smashzone
            replied to Oracle certification
            in Oracle
            Hi

            I see you are from South Africa, Oracle Certification is indeed important, for starters...in order to write any oracle exam, you need to attend at least one course provided by http://education.oracle.com , they break down their certification levels in three stages:

            1. Oracle Certified Associate
            2. Oracle Certified Professional
            3. Oracle Certified Master

            My advise to you is to first identify...
            See more | Go to post

              Leave a comment:

            • smashzone
              replied to Connecting To Oracle Database From Unix(script)
              in Linux
              -

              Pleas ellaborate on your question? Why would you need a script to connect to a database? Which Oracle database version are you using? Why can't you run sqlplus from the command line?

              Please be clear on what you need, it helps us to be able to answer your question quicker if we do have answers.

              Regards,
              smashzone...
              See more | Go to post

                Leave a comment:

              • smashzone
                started a topic Renaming a file and append it with a date
                in Linux

                Renaming a file and append it with a date

                Hi All

                Is there a way to rename a file and append a date in the end

                For example:

                if i want to rename file temp and append it with today's date, so in the end i need something like this: temp_20070516

                Thanks,
                smashzone
                See more | Go to post
                • smashzone
                  replied to shell script to create an output file of a "df -m" command with ";" seperators
                  in Linux
                  Thanks a lot guys...it worked
                  See more | Go to post

                    Leave a comment:

                  • smashzone
                    started a topic shell script to create an output file of a "df -m" command with ";" seperators
                    in Linux

                    shell script to create an output file of a "df -m" command with ";" seperators

                    Hi all,

                    Can anyone help me with a script to produce an output file of a "df -m" command with ";" seperators. I assume its very easy but I know nothing about Linux/Unix (I'm a newbie)

                    That is:
                    df -m

                    [philani@slayer ~]$ df -m
                    Filesystem 1M-blocks Used Available Use% Mounted on
                    /dev/md0 9845 4881 4464 53% /
                    /dev/md1...
                    See more | Go to post
                    No activity results to display
                    Show More
                    Working...